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
381. What is a largest collection of data stored in a computer ? You might use this type of program to keep a record of all the friends in your address book.
- Information processing
- Spreadsheet
- Operating system
- Database
382. Which command is used to replace
- REPLACE
- REPLACE ALL
- Add record from edit menu
- All of above
383. All of the Following terms are related to computerized database except which one ?
- Search
- Sort
- Field Names
- Record Grab
384. Need to see all the information from two tables on one form . Insert
- A page break
- A subform
- A linked command button
- None of the above
385. What is the primary difference between a pivot table report and a cross tab query ?
- A Pivot table report can contain sums, counts, and averages while a cross tab query cannot.
- You can't pivot a cross tab query
- A cross tab query lets you group similar items. A Pivot table report does not
- None of above
387. What's the best Access object for an invoice you'll mail to customer's ?
- A report
- A form
- A table
- All of the above
388. What is a grouped Report ?
- A type of report that can be generated by the Report Wizard
- A report that displays data that has been sorted in ascending or descending order
- A report that displays data grouped by fields you specify
- None
389. Which field allow to select items from drop down list ?
- An OLE field
- Memo Field
- A lookup field
- A hyperlink field
390. What did the first Table Analyzer Do ?
- Analyze the data in a set of flat files and automatically create a relational database system from that information
- Provide a graphic way to design relational databases
- Automate process of connecting tables to SQL Server
- None