1. What is the main advantage of using a data warehouse?
A. It stores transactional data
B. It helps with data analysis and reporting
C. It normalizes data automatically
D. It is used for live transaction processing
Answer: B) It helps with data analysis and reporting
Rationale: Data warehouses are used for analyzing large sets of data, aggregating
information, and supporting business intelligence and reporting.
2. Which SQL command is used to update existing records in a table?
A. MODIFY
B. UPDATE
C. ALTER
D. INSERT
Answer: B) UPDATE
,Rationale: The UPDATE command is used to modify existing records in a table
based on specified conditions.
3. Which of the following is an example of a data definition language (DDL)
command?
A. SELECT
B. INSERT
C. CREATE
D. UPDATE
Answer: C) CREATE
Rationale: DDL commands define or modify the structure of the database, such as
creating tables or altering schema. CREATE is an example of a DDL command.
4. Which of the following is the primary function of a Database Management
System (DBMS)?
A. To provide user interface
B. To store and manage data
C. To design user interfaces
, D. To handle server configurations
Answer: B) To store and manage data
Rationale: The main role of a DBMS is to store, manage, and organize data
efficiently, ensuring data integrity and security.
5. What is the purpose of the DISTINCT keyword in SQL?
A. To return only unique values in a result set
B. To order the result set by specific columns
C. To limit the number of records returned
D. To group records together
Answer: A) To return only unique values in a result set
Rationale: DISTINCT eliminates duplicate rows from the result set, returning only
unique values.
6. Which SQL clause is used to filter records based on specific conditions?
A. ORDER BY
B. SELECT
C. WHERE
A. It stores transactional data
B. It helps with data analysis and reporting
C. It normalizes data automatically
D. It is used for live transaction processing
Answer: B) It helps with data analysis and reporting
Rationale: Data warehouses are used for analyzing large sets of data, aggregating
information, and supporting business intelligence and reporting.
2. Which SQL command is used to update existing records in a table?
A. MODIFY
B. UPDATE
C. ALTER
D. INSERT
Answer: B) UPDATE
,Rationale: The UPDATE command is used to modify existing records in a table
based on specified conditions.
3. Which of the following is an example of a data definition language (DDL)
command?
A. SELECT
B. INSERT
C. CREATE
D. UPDATE
Answer: C) CREATE
Rationale: DDL commands define or modify the structure of the database, such as
creating tables or altering schema. CREATE is an example of a DDL command.
4. Which of the following is the primary function of a Database Management
System (DBMS)?
A. To provide user interface
B. To store and manage data
C. To design user interfaces
, D. To handle server configurations
Answer: B) To store and manage data
Rationale: The main role of a DBMS is to store, manage, and organize data
efficiently, ensuring data integrity and security.
5. What is the purpose of the DISTINCT keyword in SQL?
A. To return only unique values in a result set
B. To order the result set by specific columns
C. To limit the number of records returned
D. To group records together
Answer: A) To return only unique values in a result set
Rationale: DISTINCT eliminates duplicate rows from the result set, returning only
unique values.
6. Which SQL clause is used to filter records based on specific conditions?
A. ORDER BY
B. SELECT
C. WHERE
