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
461. Auto form allows you to
- View a subset of your data
- Create a data simple report
- Create a data entry form
- Enter records
462. The asterisk (*) is sometimes used in database queries. This character is then called a
- Wildcard
- Dummy
- Ditto
- All of above
463. When performing a look-up operation using a form
- You enter the search value into the form
- You look at each form sequentially until you see the one you want
- you type thekey in an entry line, and the correctform is displayed
- All of above
464. Which custom date format displays the numeric day of the year when a data is entered ?
- YY
- YYYY
- Y
- All of above
465. When you save an Access project, what file format do you use ?
- .adp
- .xm
- .mdp
- All of above
466. Which of the followig criterion would find records whose personality field dies not equql "Nice" ?
- <>Nice
- NOT Nice
- <>"Nice"
- IS NOT Nice
467. What is the following fields would not make a suitable primary key ?
- A data field
- An invoice number
- An auto Number field
- A customer's social security number
468. Auto reports can contain each of the following elements except
- A detail section
- A page footer
- A group header
- All of the above
469. What is the abbreviation used for a software package that permits the user to create, retrieve and maintain records in a database ?
- DASD
- FMS
- EMMS
- DBMS
470. A repository for data, usually covering some specific topic is called
- Data acquisition
- Data bank
- Real time
- Database