DBMS MCQ Questions and Answers

Take Exam

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

521. How do you update Pivot Table report data after changes are made to the source data?

  • Save your changes, close the workbook, and then reopen it.
  • Select the Pivot Table worksheet and press F9 on the keyboard
  • Click the report, and on the Pivot Table toolbar, click the refresh data button
  • All of the above
Show Answer Report

522. In access, the best types of queries to use for data analysis are:

  • Select queries
  • Parameter queries
  • Action queries
  • All of the above
Show Answer Report

523. How can you add a table to the relationship window ?

  • Select Tool>Add table from the menu
  • Select the table from the table list on the toolbar
  • Click the show table button on the toolbar
  • Select Edit>Add table from the menu
Show Answer Report

524. What is the first step in creating  a form or report with the form wizard or report wizard ?

  • Selecting the fields that you want to appear in the form or report
  • Selecting the underlying table or query on which you want to base the form or report
  • Reading several screens of mostly useless information and clicking next
  • Selecting how the form or report should be formatted
Show Answer Report

525. Which action wil optimize your database performance ?

  • Set the record set type to snapshot
  • Use the compact and repair database tool
  • Create a replica of the database
  • All of the above
Show Answer Report

526. If a piece of data is stored in two places in the database then a

  • Storage, space is wasted
  • Changing the data is one spot will cause data inconsistency
  • it can be more easily accessed
  • Both (A) and (B)
Show Answer Report

527. A relational database management (RDBMS) package manages data in more than one file at once. Hoe does it organize these file?As

  • Tables
  • Relations
  • Tuple
  • Both (A) and (B)
Show Answer Report
Database
Questions and Answers for Competitive Exams Various Entrance Test