DBMS MCQ Questions and Answers
DBMS MCQ questions with answers form a vital part of technical exams and campus interviews. This topic explores database concepts, normalization, SQL queries, transaction management, and ER models. Practicing programming questions and answers from this section strengthens your database design and query optimization skills. These questions are frequently asked in GATE, Infosys, TCS, and Wipro assessments, making them essential for students and professionals alike. Detailed solutions and explanations make this section perfect for both beginners and advanced learners aiming to master database management fundamentals.
DBMS MCQ
Showing 10 of
527 questions
311. Aborting a transaction
- removes changes made so far in the current transaction.
- removes changes made in a transaction after it has committed.
- is only possible in Microsoft Access.
- results in deadlock.
312. interaction with the file manager is the responsibility of _______
- data base manager
- data base designer
- data base administrator
- none.
313. back up and recovery is the responsibility of ___________
- data base manager
- data base designer
- data base administrator
- none.
314. _________ is the person having central control over data and programs accessing that data.
- data base manager
- data base designer
- data base administrator
- none.
315. the following are the roles of data base designer
- schema definition
- storage structure and access method definition
- schema and physical organization modification
- all the above.
316. making a change in the conceptual schema by not effecting the external schema is called
- physical data independence
- logical data independence
- functional dependency
- none.
317. Select the correct statement/s from among the following on proper naming of schema constructs:
- Entity type name applies to all the entities belonging to that entity type and therefore a plural name is selected for entity type
- In the narrative description of the database requirements, verbs tend to indicate the names of relationship types.
- The nouns arising from a database requirement description can be considered as names of attributes.
- Additional nouns which are appearing in the narrative description of the database requirements represent the weak entity type names.
318. Which of the following statement(s) is (are) true for database management systems?
- Provide protection for data against unexpected loss, damage or destruction.
- Allow maintenance of high quality, consistent and up to date data.
- Keep data and the programs that manipulate it together.
- both a & b
319. Which of the following statement(s) is (are) components of DBMS?
- Data dictionary/directory subsystem
- Security and integrity subsystem.
- Database administrator.
- both a & b
320. a table consists of ________
- spread sheet
- tuples and attributes
- descriptors
- none