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
391. Pivot Table reports are good for
- Analyzing large amounts of data
- turning tables upside down
- Breaking spreadsheet data into multiple worksheet
- None of above
392. Which of the following are common ways to enforce data validation when entering data into an access Form ?
- Creative an input mask to restrict the kind of value that can be entered in positions across the field.
- Define a validation rule for that field
- A and B
- None of the above
393. The purpose of the Add-in Manager is to
- Create macros and automata data processing
- Add or remove data in an existing database
- Add or remove templates, macros, and wizards
- All of above.
394. Sub-schema can be used to
- Creative very different, personalized views of the same data
- Present information in different formats
- Hide sensitive information by omitting fields from the subschema's description
- All of the above
395. If you are entering data in a form, a quick way to copy a value rom the previous record is to press
- CTRL +'
- F6
- Ctrl + D
- None of the above
396. DBMS is
- Collection of data
- Set of programs to access those data
- Set of programs to update those data
- All of the above
397. COPY STRUCTURE command is used to
- Copy contents of an active database to a new ffile
- Copy all records of an active database to disk
- Copy contents of an active database to disk
- Copy structure of an active database to a new file
398. COUNT command is used to
- Count the number of data fields in an active database file
- Count the number of data files which are active
- Count the records which are updated
- Count the number of records in an active database file
399. What is the term to ask the computer to pt information in order numerically or alphabetically ?
- Crop
- Report
- Sort
- Organize