get the app get the app       get the app       get the app

Database Managment System QUESTIONS

Exam NameDatabase Managment System QUESTIONS
DescriptionDatabase Managment System QUESTIONS and Answers exams contains the questions from various competitive exams.These questions are the part of previous year paper.These kind of questions would be helpful in preparing for exams like IAS, PCS, UPSC, NDA, CDS SSC, RRB, PSC, IBPS
Exam TypeMASTER EXAM
Authenticity9999
creatorAnirudh(39270)

Back to Parent Category
Create QuestionPDF  
.
Question: Which database level is closest to the users?

Answer:External


Question: What are the desirable properties of a decomposition?

Answer:Dependency preservation


Question: The conceptual model is

Answer:independent of both hardware and software


Question: In b-tree the number of keys in each node is ____ than the number of its children.

Answer:one less


Question: Which SQL-92 standard SQL command can be used to change a table name?

Answer:None of the above is correct.


Question: What rows will this select statement return ? SELECT * FROM products WHERE ordernumber > = 1000?

Answer:All rows in the products table whose order number is greater than or equal to 1000


Question: Which one of the following statements is false?

Answer:Data elements in the database can be modified by changing the data dictionary.


Question: What is full form of ODBC ?

Answer:Open Database Connectivity.


Question: It is an abstraction through which relationships are treated as higher level entities

Answer:Aggregation


Question: Which of the following SQL statements are helpful in database redesign ?

Answer:Both of the above are helpful


Question: SQL stands for ________ .

Answer:Structured Query Language


Question: An association of several structure of a data base can be expressed graphically by?

Answer:Relationship


Question: In an E-R diagram double lines indicate

Answer:Total participation


Question: What is a disjoint less constraint?

Answer:It requires that an entity belongs to no more than one level entity set.


Question: In an E-R diagram attributes are represented by

Answer:ellipse


Question: Which one of the following is a direct benefit of database normalization?

Answer:reduced data redundancy


Question: Which of the following applies to a class rather than an object?

Answer:Scope


Question: _________ clause is an additional filter that is applied to the result.

Answer:Having


Question: The database environment has all of the following components except ____________

Answer:users


Question: A constructor operation does which of the following?

Answer:Creates a new instance of a class