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: Composition is a stronger form of which of the following?


Question: DML is provided for

Answer:Manipulation & processing of database.

Question: It is better to use files than a DBMS when there are _________

Answer:Multiple users wish to access the data.

Question: Which of the following is an advantage of view?

Answer:All of the above

Question: The term Complete for a UML has the same meaning as which of the following for an EER diagram?

Answer:Total specialization rule

Question: Which of the following is not the function of client?

Answer:Query optimization

Question: Which one is true statement ?

Answer:With finer degree of granularity of locking a high degree of concurrency is possible.

Question: What is Hypertext Transfer Protocol (HTTP)?

Answer:The transfer protocol to transfer Web pages to a browser

Question: The cost of reading and writing temporary files while evaluating a query can be reduced by _________


Question: The database schema is written in


Question: _________ table store information about database or about the system


Question: The process of reading a database schema and producing a data model from that schema is known as _________

Answer:reverse engineering.

Question: Relational Algebra does not have

Answer:Aggregation operators.

Question: The relational model feature is that there _________

Answer:is much more data independence than some other database models

Question: If the closure of an attribute set is the entire relation then the attribute set is a


Question: The physical location of a record is determined by a mathematical formula that transforms a file key into a record location is _________

Answer:Hashed File

Question: An advantage of the database management approach is ____________

Answer:data is integrated and can be accessed by multiple programs

Question: A .................. normal form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.


Question: Data independence means ____________

Answer:both (B) and (C)

Question: The graphical representation of a query is ________.

Answer:Query Tree