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
511. Which of the following is NOT a type of Microsoft Access database object?
- Queries
- Workbooks
- Forms
- Tables
512. A file containing relatively permanent data is
- Random file
- Transaction file
- Master file
- Sequential file
513. The complete picture of data stored in database is known as
- Record
- Scheme
- System flowchart
- DBMS
514. A subset of characters within a data field is known as
- Record
- File
- Data string
- Byte
515. Data items groped together for storage purposes are called a
- Record
- Title
- List
- string
516. Which of the following terms does not describe a database structure used by a DBMS to link data from several files /
- Reatioal
- Structural
- Network
- All of the above
517. In a relational schema, each tuple is divided into fields fields called
- Relations
- Domains
- Queries
- All of the above
518. How do you filter by selection ?
- Right click the field value and select filter by selection from the shortcut menu
- Find and double click the value on which you want to base the filter
- Find and select the value on which you want to base the filter and select tools>filter by selection from the menu
- None of the above
519. What is a fast way to adjust the width of a column ?
- Right click the left side of the column heading
- Double click the left side of the column heading
- Double click the right side of the column heading
- Select tools>adjust column width from the menu
520. What are the columns in a Microsoft Access table called ?
- Rows
- Fields
- Cells
- Records