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

Back to Parent Category
Create QuestionPDF  
.
Question: Composition is a stronger form of which of the following?

Answer:Aggregation


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 _________

Answer:pipelining


Question: The database schema is written in

Answer:DDL


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

Answer: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

Answer:superkey


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.

Answer:third


Question: Data independence means ____________

Answer:both (B) and (C)


Question: The graphical representation of a query is ________.

Answer:Query Tree