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

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


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


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?


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


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?


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


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


Question: A constructor operation does which of the following?

Answer:Creates a new instance of a class