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
501. Which control does access use to link data access page components to access data ?
- Microsoft Dynamic Data Control
- Microsoft Data Connection control
- Mcrosoft Office Data source Control
- None of the above
502. Which program do you use to edit code for data access pages ?
- Microsoft script editor
- Microsoft code editor
- Microsoft data access pages editor
- None of above
503. The way a particular application views the data from the database that the application uses is a
- Module
- Relational model
- Schema
- Sub-schema
504. Which of the following is a database management system?
- Ms-Word
- Lotus 1-2-3
- Oracle
- None of above
505. What is the corresponding text for the <#1/1/95# validation rule setting ?
- Neter a value less or more than 1,195
- Value must be less than 95 characters
- Enter a data before 1995
- All of above
506. What is the corresponding text for the <#1/1/95# validation rule setting ?
- Neter a value less or more than 1,195
- Value must be less than 95 characters
- Enter a data before 1995
- All of above
507. What is the name of the Visual Basic Editor utility that allows you to view the Microsoftt Access type library's available objects and members ?
- Object Viewer
- Object Browser
- Type Library Spy
- None of above
508. A computer language for informing the DBMS regarding the data structure used is
- PASCAL
- DDL
- PROLOG
- FORTRAN
509. Which of the following is not a data type ?
- Picture/graphic
- Data/time
- Text
- Number
510. The executive responsible for the data processing function in an organization is
- PM
- DBMS
- DP
- DPM