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
421. Pack command is used to
- Remove records permanently
- Remove records temporarily
- Restore records permanently
- Restore records temporarily
422. Modules are
- Selection of commands used to automate repetitive tasks
- Programs written in Visual C++
- Object tabs
- Group of records
423. APPEND command is used to
- Add record to the end of active database file and starts full screen data entry
- Add Record to the start of active database file
- Add record to the start of active database file and starts full screen data entry
- Add record to the end of database file
424. Append from command is used to
- Add records from information in an array
- Adds records from a file
- Add records from a variable
- Add records from stock
425. Examples of centralized multi-user database are
- Barclay's Bank customer accounts
- Supermarket stock control, organ donor database, client database
- Airline reservations and other national global booking systems
- None of the above
426. New record is added using
- Append record from browse menu
- Append record into from browse menu
- Add record froml edit menu
- All of above
427. When a customer makes an online hotel booking, the database is updated in
- Batch mode
- Pseudo real-time
- One month
- All of above
428. A database that contains tables linked by common fields is called a
- Centralized database
- Flat file database
- Relational database
- None of above
429. The use of integrated collections of database records and files for data storage and processing. The best fit for answer.
- Database management approach
- DBMS uses
- Database adminisrator
- Query language
430. DBMS allow you to create, interrogate, and maintain a database, create reports, and develop applicaion programs, select the best fit answer.
- Database management approach
- DBBMS uses
- Database administrator
- Query lanugage