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

Answer:No partial FDs exist.

Question: Block-interleaved distributed parity is RAID level


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 ?


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.


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


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


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 _________


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