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(39287)

Back to Parent Category
Create QuestionPDF  
.
Question: Which of the following is another name for weak entity?

Answer:Child


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 ____________

Answer:domain


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

Answer:UNIQUE


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

Answer:trigger


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.

Answer:committed


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

Answer:SQL


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