Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Chapter: 23
Q361:
Horizontal partitioning divides a table based on _______.
A. columns
B. rows
C. data types
D. primary keys
Correct Answer:
B
Chapter: 23
Q362:
The technique of merging two entity types with a one-to-one relationship helps in _______ performance.
A. degrading
B. improving
C. complicating
D. reducing
Correct Answer:
B
Chapter: 23
Q363:
Hash partitioning helps in reducing the chances of _______ partitions.
A. unbalanced
B. fixed
C. list
D. range
Correct Answer:
A
Chapter: 23
Q364:
In vertical partitioning, a table is split based on _______.
A. rows
B. columns
C. indexes
D. data types
Correct Answer:
B
Chapter: 24
Q365:
What is vertical partitioning based on?
A. Rows
B. Attributes
C. Tables
D. Relations
Correct Answer:
B
Chapter: 24
Q366:
In vertical partitioning, what is repeated in all vertical partitions of a table?
A. Primary Key
B. Foreign Key
C. Data Types
D. Constraints
Correct Answer:
A
Chapter: 24
Q367:
What is the process of copying a portion of a database from one environment to another called?
A. Replication
B. Partitioning
C. Clustering
D. Denormalization
Correct Answer:
A
Chapter: 24
Q368:
What is clustering in a database?
A. Placing records from the same table together
B. Placing records from different tables adjacently
C. Merging two databases into one
D. Splitting tables vertically
Correct Answer:
B
Chapter: 24
Q369:
Which of the following is a benefit of SQL standardization?
A. Reduced training cost
B. Application complexity
C. Vendor dependence
D. System isolation
Correct Answer:
A
Chapter: 24
Q370:
What is the language used to access and manipulate databases?
A. HTML
B. SQL
C. Python
D. JavaScript
Correct Answer:
B
Chapter: 24
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
Correct Answer:
B
Chapter: 24
Q372:
What does clustering improve in database design?
A. Query writing
B. Physical space management
C. Access efficiency
D. Data integrity
Correct Answer:
C
Chapter: 24
Q373:
SQL-92 is a standard for which language?
A. HTML
B. CSS
C. SQL
D. JavaScript
Correct Answer:
C
Chapter: 24
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
Correct Answer:
B
Chapter: 24
Q375:
Fill in the blank: In replication, ______ made to the original source are propagated to copies.
A. Changes
B. Inserts
C. Deletes
D. Alterations
Correct Answer:
A
Chapter: 24
Q376:
Fill in the blank: SQL is used to ______ with a database.
A. connect
B. manipulate
C. design
D. write scripts
Correct Answer:
B
Chapter: 24
Q377:
Fill in the blank: Clustering improves the ______ by placing related records together.
A. security
B. efficiency
C. backup
D. redundancy
Correct Answer:
B
Chapter: 24
Q378:
Which type of SQL operation is used to retrieve data from a database?
A. SELECT
B. INSERT
C. DELETE
D. UPDATE
Correct Answer:
A
Chapter: 24
Q379:
Which DBMS is commonly used with SQL Server 2000 for our course?
A. Oracle
B. Sybase
C. Microsoft SQL Server
D. MySQL
Correct Answer:
C
Chapter: 24
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
Correct Answer:
C