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
481. The mdify operation is likely to be done after
- delete
- lookup
- insert
- all of above
482. The criteria BETWEEN 1/1/99 and 12/31/99 would which is proper
- Display record between the dates 1/2/99 and 1/1/00
- Display record between the dates 1/1/99 and 12/31/99
- Display record whose dates equaled 1/1/99 or 12/31/99
- All of above
483. DDP stands for
- distributed Double Processing
- Double Decimal Processing
- Distributed Data Programming
- Distributed Data Processing
484. To see sales amount figures totaled, into which drop area would you drag that field ?
- Drop column fields here
- Drop row fields here
- Drop data items here
- None of the above
485. Which access feature do you use to develop applications that host access data on the web ?
- Dynamic web data
- Data access pates
- Html data pages
- None of the above
486. What is the common name for a column of data within an Access table ?
- Field
- Record
- Row
- None of the above
487. A data structure consisting of several fields, some or all of which are instances of the same data structure, is called
- Field
- Bead
- Database
- Data collection
488. A group of characters used to identiry a given low level instruction is
- File
- Record
- key field
- label
489. One or more characters used to identify a data field in a computer program is
- File name
- Database
- Label
- Group
490. In form view, which command displays records alphabteically ?
- find
- Advanced Filter/Sort
- Sort
- All of the above