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 of the following is another name for weak entity?


Question: A list consists of last names, first names, addresses and pin codes. If all people in the list have the same last name and same pin code a useful key would be ____________

Answer:the compound key first name and last name

Question: A set of possible data values is called ____________


Question: Aggregation is which of the following?

Answer:Expresses a part-of relationship and is a stronger form of an association relationship.

Question: Which of the following is a valid SQL type?

Answer:All of the above

Question: Which of the operations constitute a basic set of operations for manipulating relational data?

Answer:None of the above

Question: The keyword to eliminate duplicate rows from the query result in SQL is


Question: The DBMS acts as an interface between what two components of an enterprise-class database system?

Answer:Database application and the database

Question: Before any changes to database structure are attempted one should first _________

Answer:All of the above should be done.

Question: An entity set that does not have sufficient attributes to form a primary key is a

Answer:weak entity set

Question: In SQL the statement select * from R, S is equivalent to

Answer:Select * from R cross join S

Question: A DBMS query language is designed to ____________

Answer:all of the above

Question: The statement that is executed automatically by the system as a side effect of the modification of the database is


Question: Which is not true of a correlated subquery?

Answer:They are very similar to a regular subquery.

Question: The DBMS language component which can be embedded in a program is ____________

Answer:The data manipulation language (DML)

Question: Key to represent relationship between tables is called

Answer:Foreign Key

Question: A transaction is in __________ state after the final statement has been executed.


Question: The code that relational database management systems use to perform their database task is referred to as _________


Question: Conceptual design

Answer:involves modelling independent of the DBMS

Question: Relations produced from an E-R model will always be

Answer:First normal form