Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q371: In which scenarios is replication commonly used?
- A: When frequent updates are needed
- B: When updates are infrequent
- C: For every database operation
- D: For small databases
View Answer
B
Q372: What does clustering improve in database design?
- A: Query writing
- B: Physical space management
- C: Access efficiency
- D: Data integrity
View Answer
C
Q373: SQL-92 is a standard for which language?
- A: HTML
- B: CSS
- C: SQL
- D: JavaScript
View Answer
C
Q374: What is the primary tool used for SQL queries in Microsoft SQL Server?
- A: Visual Studio
- B: Query Analyzer
- C: MySQL Workbench
- D: Enterprise Manager
View Answer
B
Q375: Fill in the blank: In replication, ______ made to the original source are propagated to copies.
- A: Changes
- B: Inserts
- C: Deletes
- D: Alterations
View Answer
A
Q376: Fill in the blank: SQL is used to ______ with a database.
- A: connect
- B: manipulate
- C: design
- D: write scripts
View Answer
B
Q377: Fill in the blank: Clustering improves the ______ by placing related records together.
- A: security
- B: efficiency
- C: backup
- D: redundancy
View Answer
B
Q378: Which type of SQL operation is used to retrieve data from a database?
- A: SELECT
- B: INSERT
- C: DELETE
- D: UPDATE
View Answer
A
Q379: Which DBMS is commonly used with SQL Server 2000 for our course?
- A: Oracle
- B: Sybase
- C: Microsoft SQL Server
- D: MySQL
View Answer
C
Q380: What is one of the first steps in transforming a logical data model into a physical model?
- A: Adding constraints
- B: Choosing data types
- C: Transforming entities into tables
- D: Writing SQL scripts
View Answer
C