Advance Database Management Systems MCQs

This statement is correct because trigger means that a database program that automatically executes in response to specified events.

selection operation is used in Advanced DBMS because a relational operation that filters rows based on a condition.

This statement is correct because cardinality estimation means that the optimizer estimates how many rows an operation will produce.

The correct answer explains cursor in the context of Database Programming.

This statement is correct because selection operation means that a relational operation that filters rows based on a condition.

The correct answer explains query execution plan in the context of Query Processing.

cursor is used in Advanced DBMS because a database object used to process query results row by row.

The correct answer explains projection operation in the context of Query Processing.

query execution plan is used in Advanced DBMS because a plan showing physical operations chosen to execute a query.

This statement is correct because cursor means that a database object used to process query results row by row.

projection operation is used in Advanced DBMS because a relational operation that selects specific columns.

This statement is correct because query execution plan means that a plan showing physical operations chosen to execute a query.