Midterm Review

Question 1

Which of the following is not a type of cursor in Oracle?

a) Implicit cursor
b) Explicit cursor
c) Static cursor
d) Dynamic cursor

Answer 1

c) Static cursor

Question 2

Static SQL is:

a) Resolved at runtime
b) Resolved at compile time
c) Not related to SQL
d) None of the above

Answer 2

b) Resolved at compile time

Question 3

Bulk operations in PL/SQL are typically used for:

a) Handling individual records
b) Handling multiple records at once
c) Selecting specific records
d) None of the above

Answer 3

b) Handling multiple records at once

Question 4

In PL/SQL, which keyword is used to declare a stored procedure?

a) FUNCTION
b) PROCEDURE
c) TRIGGER
d) DECLARE

Answer 4

b) PROCEDURE

Question 5

Triggers are:

a) Executed before or after a DML operation
b) Executed before or after a query
c) Not related to database operations
d) None of the above

Answer 5

a) Executed before or after a DML operation

Question 6

In PL/SQL, which construct is used to define exception handling?
a) TRY-CATCH
b) EXCEPTION
c) HANDLE
d) ERROR

Answer 6

b) EXCEPTION

Question 7

What is the purpose of a stored procedure?

a) To execute a single SQL statement
b) To execute a group of SQL statements
c) To retrieve data from a database
d) None of the above

Answer 7

b) To execute a group of SQL statements

Question 8

Which of the following is a characteristic of
a function in PL/SQL?
a) It must return a value
b) It cannot return a value
c) It can only be called from within a trigger
d) It can only be called from within a stored procedure

Answer 8

a) It must return a value

Question 9

What is the primary use of static SQL?

a) Dynamic execution of SQL statements b) Compile-time resolution of SQL statements
c) Runtime resolution of SQL statements
d) None of the above

Answer 9

b) Compile-time resolution of SQL statements

Question 10

What is the primary purpose of the Transform phase in ETL?

a) Extract data from source systems
b) Cleanse, validate, and transform data
c) Load data into the target system
d) Index data for faster retrieval

Answer 10

b) Cleanse, validate, and transform data

Question 11

A data warehouse stores historical data for:

a) Short-term operational use
b) Real-time decision-making
c) Long-term analytical purposes
d) Data archival purposes

Answer 11

c) Long-term analytical purposes

Question 12

What does ETL stand for in data warehousing?

a) Extract, Transfer, Load
b) Extract, Transform, Load
c) Extract, Translate, Load
d) Extract, Test, Load

Answer 12

b) Extract, Transform, Load

Question 13

Which of the following is typically used to store hierarchical data in a star schema?
a) Fact table
b) Dimension table
c) Staging table
d) Lookup table

Answer 13

b) Dimension table

Question 14

What is a data mart?
a) A large centralized data warehouse
b) A subset of a data warehouse designed for a specific business line or team
c) An operational database for day-to-day transactions
d) A tool for ETL processes

Answer 14

b) A subset of a data warehouse designed for a specific business line or team

Question 15

Which type of schema is characterized by one fact table surrounded by multiple dimension tables?

a) Star schema
b) Snowflake schema
c) Galaxy schema
d) Constellation schema

Answer 15

a) Star schema

Question 16

What is the primary key in a dimension table used for?

a) To store aggregated data
b) To uniquely identify each record in the table
c) To perform calculations
d) To link to other fact tables

Answer 16

b) To uniquely identify each record in the table