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
281. Duplication of data in files may cause
- data integrity problems.
- data items with the same names used for different purposes.
- data items with different names in different files.
- A and C
282. Which of the following is NOT an advantage of database systems?
- better data quality
- program-data independence
- redundant data
- standards enforcement
283. Which of the following is NOT a function of a DBMS?
- data storage, retrieval, and update.
- logical data dependence.
- recovery services.
- integrity services
284. Which of the following is used to store the structure and format of user forms, reports, queries, and other application components?
- Application MetaData
- Report Table
- Query By Example
- None
285. Data in the database that represent a description of the database structure are called:
- Indexes
- User Data
- Application metadata
- Metadata
286. The intermediary between the design tools and run-time subsystems and data is called:
- DBMS engine
- Database schema
- Operating system
- User interface
287. Restrictions on the business activities that need to be reflected in the database and database application are known as:
- Database schema
- Relationships
- Business rules
- None
288. Which of the following is not a way in which a query can be expressed?
- By surrogate keys
- Query by form
- Use the data access language SQL
- Query by example
289. What is Database?
- Collection of Information
- Collection of meaningful real world data
- Which stores Data
- All the above
290. Advantages of DBMS. Which statement is true? (i) security (ii) Redundancy is controlled (iii) Providing backup and recovery (iv) Providing multiple user interfaces.
- (i) and (ii)
- (iii) and (vi)
- (i),(ii),(iii) and not (iv)
- (i),(ii),(iii) and (iv)