Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Chapter: 14
Q201:
What is the main purpose of denormalization?
A. To add redundancy for improved performance
B. To reduce redundancy
C. To simplify the database schema
D. To enforce data integrity
Correct Answer:
A
Chapter: 14
Q202:
Denormalization is typically used when:
A. The database structure is more important than performance
B. Performance is less critical than data integrity
C. The database is small and simple
D. The database performance is a concern and needs improvement
Correct Answer:
B
Chapter: 14
Q203:
Which of the following describes the need for denormalization?
A. Reducing the number of tables to simplify design
B. Reducing running time of queries that involve multiple joins
C. Increasing data redundancy to ensure data integrity
D. Normalizing the database to remove anomalies
Correct Answer:
B
Chapter: 14
Q204:
Normalization focuses on:
A. Increasing the number of joins to improve performance
B. Reducing data redundancy and inconsistency
C. Improving query execution speed
D. Storing data in fewer tables
Correct Answer:
B
Chapter: 14
Q205:
When is it appropriate to denormalize a database?
A. When data integrity is a higher priority than performance
B. When running time of queries is a critical factor
C. When the database schema needs to be simplified
D. When ensuring logical relationships is important
Correct Answer:
B
Chapter: 14
Q206:
A common denormalization technique involves storing:
A. Only primary keys
B. Only foreign keys
C. Calculated values to improve query performance
D. Redundant data to reduce joins
Correct Answer:
C
Chapter: 14
Q207:
In denormalization, which scenario might involve storing an end date?
A. When records are updated frequently
B. When historical data needs to be queried efficiently
C. When multiple child tables need to be merged
D. When grandparent-grandchild relationships are queried frequently
Correct Answer:
B
Chapter: 14
Q208:
Which of the following is an example of storing details in the master table?
A. Keeping order details in a separate table from orders
B. Merging order details into the order table to reduce joins
C. Storing customer feedback separately from order data
D. Using a separate table for product reviews
Correct Answer:
B
Chapter: 14
Q209:
What is a short circuit key used for in denormalization?
A. To link parent and child tables
B. To ensure relationships between different levels of master tables
C. To store frequently updated records
D. To manage large amounts of data in a single table
Correct Answer:
B
Chapter: 14
Q210:
A current indicator column in a denormalized table is used to:
A. Store historical data
B. Indicate whether a record is the most current
C. Keep track of changes in data structure
D. Calculate frequently used values
Correct Answer:
B
Chapter: 14
Q211:
Storing a calculated value in a table can:
A. Increase query processing time
B. Reduce the need for complex calculations during queries
C. Ensure data consistency across tables
D. Normalize the database schema
Correct Answer:
B
Chapter: 15
Q212:
What does Oracle Cloud service provide in terms of database management?
A. Full access to features and operations
B. Only hardware access
C. Manual database management
D. Physical server maintenance
Correct Answer:
A
Chapter: 15
Q213:
Which of the following is NOT required when using Oracle Cloud for database management?
A. Purchasing hardware
B. Performing database upgrades
C. Running backup and recovery commands
D. Handling database software patching
Correct Answer:
A
Chapter: 15
Q214:
To access Oracle 11g Cloud, which website address should be used?
A. https://cloud.oracle.com
B. https://apex.oracle.com/en/
C. https://oracle.com/database
D. https://sql.oracle.com
Correct Answer:
B
Chapter: 15
Q215:
Which tab should be clicked to enter SQL Statements/Commands in Oracle Cloud?
A. SQL Workshop
B. SQL Commands
C. Workspace
D. Name
Correct Answer:
C
Chapter: 15
Q216:
When logging into Oracle Cloud, which of the following credentials is NOT required?
A. Workspace Name
B. Username
C. Password
D. Database Name
Correct Answer:
D
Chapter: 15
Q217:
Which step involves entering credentials on the Oracle 11g Cloud login page?
A. Step 01
B. Step 02
C. Step 03
D. Step 04
Correct Answer:
B
Chapter: 15
Q218:
What is the purpose of the SQL Workshop tab in Oracle Cloud?
A. To run database backups
B. To access SQL Statements/Commands
C. To manage cloud storage
D. To update database software
Correct Answer:
B
Chapter: 15
Q219:
To view the results of SQL Statements/Commands in Oracle Cloud, you should:
A. Click Run
B. Click Save
C. Click Exit
D. Click Edit
Correct Answer:
A
Chapter: 15
Q220:
In which section can you find the option to run SQL Statements/Commands?
A. SQL Commands tab
B. Workspace tab
C. Sign In button
D. Database tab
Correct Answer:
A