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(39042)
Create QuestionPDF  

Back to Parent Category
Question: DBMS is a collection of ………….. that enables user to create and maintain a database.

Answer:Program


Question: In a relational schema, each tuple is divided into fields called

Answer:Domains


Question: In an ER model, ……………. is described in the database by storing its data.

Answer:Entity


Question: DFD stands for

Answer:Data Flow Diagram


Question: A top-to-bottom relationship among the items in a database is established by a

Answer:Hierarchical schema


Question: ……………… table store information about database or about the system.

Answer:System


Question: …………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs.

Answer:Schema




Question: ……………… clause is an additional filter that is applied to the result.

Answer:Having


Question: A logical schema

Answer:is a standard way of organizing information into accessible parts.


Question: A relational database developer refers to a record as

Answer:a tuple


Question: .......... keyword is used to find the number of values in a column.

Answer:COUNT


Question: An advantage of the database management approach is

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


Question: The collection of information stored in a database at a particular moment is called as ......

Answer:instance of the database


Question: Data independence means

Answer:both B and C


Question: A ......... is used to define overall design of the database

Answer:schema


Question: Key to represent relationship between tables is called

Answer:foreign key


Question: Grant and revoke are ....... statements.

Answer:DCL


Question: DBMS helps achieve

Answer:Both A and B


Question: .......... command can be used to modify a column in a table

Answer:alter


Question: The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is

Answer:Non-Procedural DML