Question 1

A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.

Accepted Answer

Triggers are used to automatically execute a set of SQL statements in response to certain database events, such as INSERT, UPDATE, or DELETE operations on a table. They are essentially a type of stored program that is executed by the database management system (DBMS) in response to a specific trigger condition.

Question 2

A persistent stored module is stored and executed on the database client machine.

Accepted Answer

A persistent stored module is stored and executed on the database server machine, not the client machine.

Question 3

The most useful feature of PL/SQL blocks is that they let a designer create code that can be named,stored,and executed by the DBMS.

Accepted Answer

PL/SQL blocks allow for the creation of named, stored, and executable code within the DBMS. This provides a significant amount of flexibility and functionality for database developers and administrators.

Question 4

String manipulation functions are rarely used in programming.

Accepted Answer

String manipulation functions are often used in programming, especially in tasks related to data processing and manipulation. These functions include concatenation, splitting, matching, replacing, and other operations that allow for manipulating strings and extracting meaningful information from them.

Question 5

Numeric functions take one numeric parameter and return one value.

Accepted Answer

Numeric functions require a numeric parameter and return a single value. Examples include ABS(), ROUND(), and RAND().

Question 6

A sequence is not associated with a table and can be dropped from a database with a DROP SEQUENCE command.

Accepted Answer

A sequence in a database is an independent object that can be dropped using the DROP SEQUENCE command without affecting any table or other object in the database.

Question 7

Triggers can only be used to update table values.

Accepted Answer

Triggers can be used for a variety of purposes beyond updating table values, including enforcing business rules, auditing changes, and maintaining complex integrity constraints. They can execute a specified action before or after a data modification or retrieval operation, such as INSERT, UPDATE, DELETE, or SELECT.

Question 8

In Oracle,you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

Accepted Answer

SQL*Plus command SHOW ERRORS displays the compilation errors for the most recently executed PL/SQL block.

Question 9

A statement-level trigger is assumed if a designer omits the FOR EACH ROW keywords.

Accepted Answer

In MySQL, if the FOR EACH ROW keywords are omitted in a trigger definition, it is assumed to be a statement-level trigger instead of a row-level trigger.

Question 10

To remedy the lack of procedural functionality in SQL,and to provide some standardization within the many vendor offerings,the SQL-99 standard defined the use of persistent stored modules.

Accepted Answer

SQL-99 standard did define the use of persistent stored modules to provide procedural functionality and standardization within vendor offerings.

Question 11

An inequality condition is also known as a natural join and an equality condition is also called a theta join.

Accepted Answer

An inequality condition is known as a theta join and an equality condition is known as an equijoin.

Question 12

Subqueries cannot be used in combinations with joins.

Accepted Answer

Subqueries can be used in combinations with joins, allowing for more complex and specific queries to be made.

Question 13

PL/SQL blocks have a section used to declare variables.

Accepted Answer

PL/SQL blocks have a DECLARE section where variables and other program objects can be declared.

Question 14

A view is a virtual table based on a SELECT query.

Accepted Answer

A view is a virtual table created based on a SELECT query. It does not exist as a physical table but can be referenced like one in SQL queries.

Question 15

UNION,INTERSECT,and MINUS work properly only if relations are intersect-compatible,which means that the names of the relation attributes and their data types must be different.

Accepted Answer

UNION, INTERSECT, and MINUS can work properly even if the relations are not intersect-compatible as long as the number and order of the attributes match. The names and data types can be the same in such cases.

Question 16

A relational join operation merges rows from two tables.

Accepted Answer

A relational join operation combines rows from two tables based on a related column or key, resulting in a new table that includes attributes from both tables.

Question 17

The SELECT statement uses the attribute list to indicate what columns to project in the resulting set.

Accepted Answer

The SELECT statement is used to project columns from a table or view, and the attribute list is used to specify which columns should be included in the query's result set.

Question 18

Every PL/SQL block must be given a name.

Accepted Answer

PL/SQL blocks can be anonymous i.e. they do not require a name to be given.

Question 19

Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.

Accepted Answer

Automating business procedures and maintaining data integrity and consistency are complex tasks that require careful planning, implementation, and ongoing management to ensure they meet the needs of a modern business environment effectively.

Question 20

SQL supports the conditional execution of procedures (IF-THEN-ELSE statements)that are typically supported by a programming language.

Accepted Answer

The answer of SQL supports the conditional execution of procedures...

Quiz 8: Advanced SQL