Which type of subquery executes once for each row evaluated by the outer query, depending on values provided by the outer statement? MCQ with Answer and Explanation

Which type of subquery executes once for each row evaluated by the outer query, depending on values provided by the outer statement?
A. Correlated Subquery
B. Static Subquery
C. Independent Subquery
D. Scalar Subquery
Answer: Option A
Solution (By JKExamLibrary)
A Correlated Subquery is an inner query that references columns from the outer query, meaning it must be executed repeatedly for each row evaluated by the outer query.

This question belongs to: Computer Database Management System (DBMS)

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1 Report Error
Which of the following is a type of database backup?
A. Incremental backup
B. Full backup
C. Differential backup
D. All of the above

Correct Answer: Option D


Explanation:
Full, incremental, and differential backups are common backup strategies.

This question belongs to: Computer Database Management System (DBMS)
Question #2 Report Error
What is a data dictionary in a DBMS?
A. A log file
B. A table containing user data
C. A repository of metadata about the database
D. A backup of the database

Correct Answer: Option C


Explanation:
The data dictionary stores metadata such as table definitions, column types, constraints, and other database objects.

This question belongs to: Computer Database Management System (DBMS)
Question #3 Report Error
What is the purpose of a Foreign Key?
A. To uniquely identify records
B. To create indexes
C. To link two tables and enforce referential integrity
D. To sort data

Correct Answer: Option C


Explanation:
A foreign key establishes a relationship between tables and maintains referential integrity.

This question belongs to: Computer Database Management System (DBMS)