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: Which two files are used during operation of the DBMS?

Answer:Data dictionary and transaction log


Question: The database schema is written in

Answer:DDL


Question: The way a particular application views the data from the database that the application uses is a

Answer:sub schema


Question: The relational model feature is that there

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


Question: Which one of the following statements is false?

Answer:Data elements in the database can be modified by changing the data dictionary.


Question: Which of the following are the properties of entities?

Answer:Attributes


Question: Which database level is closest to the users?

Answer:External


Question: Which are the two ways in which entities can participate in a relationship?

Answer:Total and partial


Question: The candidate key is that you choose to identify each row uniquely is called ……………..

Answer:Primary Key


Question: …………….. is used to determine whether of a table contains duplicate rows.

Answer:Unique predicate


Question: To eliminate duplicate rows ……………… is used

Answer:DISTINCT


Question: State true or false

i) A candidate key is a minimal super key.

ii) A candidate key can also refer to as surrogate key.


Answer:i-true, ii-true


Question: DCL stands for

Answer:Data Control Language


Question: …………………… is the process of organizing data into related tables.

Answer:Normalization


Question: A ………………. Does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity.

Answer:Weak entity


Question: …………….. is the complex search criteria in the where clause.

Answer:Predicate


Question: ………………… is preferred method for enforcing data integrity

Answer:Constraints


Question: State true or false.
i) Select operator is not a unary operator.
ii) Project operator chooses subset of attributes or columns of a relation.


Answer:i-False, ii-True


Question: …………… database is used as template for all databases created.

Answer:Model


Question: One aspect that has to be dealt with by the integrity subsystem is to ensure that only valid values can be assigned to each data items. This is referred to as

Answer:Domain Integrity