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: In 2NF

Answer:No partial FDs exist.


Question: Block-interleaved distributed parity is RAID level

Answer:5


Question: Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.

Answer:It will immediately be granted.


Question: The collection of information stored in a database at a particular moment is ?

Answer:Instance


Question: As per equivalence rules for query transformation, selection operation distributes over

Answer:All of the above


Question: What SQL command can be used to delete columns from a table?

Answer:ALTER TABLE TableName DROP COLUMN ColumnName


Question: In the _________ normal form, a composite attribute is converted to individual attributes.

Answer:first


Question: Relational Algebra is ____________

Answer:Procedural query Language


Question: Which of the following is not a characteristic of a relational database model?

Answer:Tree like structure


Question: ____________ is a special type of stored procedure that is automatically invoked whenever the data in the table is modified

Answer:Trigger


Question: The DBMS utility, _________ allows to reconstruct the correct state of database from the backup and history of transactions.

Answer:Recovery


Question: Which of the following is record based logical model?

Answer:Network Model


Question: A report generator is used to ____________

Answer:print files on paper


Question: Which of the following statements is not true about two tier client server database architecture?

Answer:Business logic is mostly processed on clients


Question: The level of abstraction describes only part of the entire database called _________

Answer:View Level


Question: An object can have which of the following multiplicities?

Answer:All of the above.


Question: According to the levels of abstraction, the schema at the intermediate level is called _________

Answer:none of these


Question: The process by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is _________

Answer:Normalization


Question: In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect ?

Answer:Operationally, if X is deleted, so is Y


Question: The full form of DDL is

Answer:Data Definition Language