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
231. A _____________is a data repository along with a user interface providing for the manipulation and administration of a database.
- DBMS
- TBMS
- SDMs
- Nothing
232. A specific example where physical data independence would hold is when data file is changed from an unordered file to a sorted file. when an additional access structure, (e.g. an index) is created for a relation. when DBA decides to store the data in a B+ tree. when the user retrieves data from the database. when the user writes an application program to join tables.
- i,ii and iii
- I,ii,ii and iv
- iv and v
- none
233. A relation (from the relational database model) consists of a set of tuples, which implies that
- relational model supports multi-valued attributes whose values can be represented in sets
- for any two tuples, the values associated with all of their attributes may be the same.
- for any two tuples, the values associated with one or more of their attributes must differ.
- all tuples in a particular relation may have different attributes.
234. If K is a foreign key in relation R1, then
- every tuple of R1 has a distinct value for K.
- K cannot have a null value for tuples in R1
- K is a key for some other relation
- K is a composite key for R1.
235. Practitioners and Users are involved with database systems. Which of the statements below is/are true regarding them?
- Systems Designer is a user
- Departmental Heads are users.
- Information Systems Manager is a user.
- Clerical staff are practitioners.
236. Which of the following statements is a/are characteristic(s) of
- a,b and c
- a,c and e
- a,b,c and e
- a,b,c,d and e
237. Components of a DBMS includes
- a user query and reporting facility
- a database access sub system
- a security and integrity sub system
- All the above
238. The blanks of the following three statements have to be filled. The (i) level provides the physical view of the database. The (ii) level gives a user oriented description of the data elements and relationships. The (iii) level provides all users information needs and definition of data items needs to meet them. Which of the following will correctly fill the blanks?
- (i) conceptual (ii) external (iii) internal
- (i) internal (ii) external (iii) conceptual
- (i) external (ii) conceptual (iii) internal
- (i) internal (ii) conceptual (iii) external
239. Protecting a database from unauthorized or malicious use is termed
- data integrity.
- concurrent processing.
- data security.
- data recovery.
240. Which of the following closely resemble(s) an
- A large health care Organization that operates a group of hospitals.
- A software development team maintaining a list of software components.
- A student
- A salesman