PL/SQL Questions Exam Quiz!

The statement "SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;" is returning the date of the next Monday after the current date. Since today is Monday, 21 NOV 2000, the next Monday after this date would be 28 NOV 2000. Therefore, the correct answer is 28-NOV-00.

A join operation combines rows from two or more tables based on a related column between them. In this case, the question is asking how many tables can be included in a join. The correct answer is "all the above" because a join can involve one table, two tables, or even three tables depending on the specific query and the relationships between the tables. Therefore, the answer encompasses all the possible scenarios for joining tables.

The functions for error trapping are contained in the Exception section of a PL/SQL block. This section is used to handle any exceptions or errors that may occur during the execution of the block. It allows the programmer to specify what actions should be taken when a specific error occurs, such as logging the error, displaying a message, or rolling back a transaction. By including error trapping functions in the Exception section, the programmer can ensure that their code handles errors gracefully and continues to execute without crashing.

Triggers are database objects that are created with SQL and are used to automatically execute a set of actions when a specific event occurs in a database. These events can include insertions, updates, or deletions of data. Triggers also have conditions, which determine when the trigger should be executed, and actions, which specify what actions should be performed when the trigger is fired. Therefore, the statement "They have an event, condition, and action" is true concerning triggers.

When a variable is declared as NUMBER without an initial value in a PL/SQL block, its value will be NULL when it is first used in the executable section of the block.

The correct answer is "limits the row data that are returned." The SQL WHERE clause is used to filter the rows in a table based on a specified condition. It allows you to specify a condition that must be met for a row to be included in the result set. By using the WHERE clause, you can limit the rows that are returned from a query based on specific criteria, such as filtering rows with a certain value in a particular column. Therefore, the WHERE clause limits the row data that are returned.

When two NULL values are compared to each other, the result is NULL. This is because NULL represents an unknown or missing value, so the comparison cannot determine a definite result. Therefore, the answer is Null.

The line "into my_city, my_state" will produce an error because the INTO clause is used to fetch data from the cursor into variables, but the variables my_city and my_state have not been declared or defined in this PL/SQL statement.

PL/SQL raises an exception when a SELECT statement returns no rows because it is expecting at least one row to be returned. This can occur when the conditions in the WHERE clause are not met or when the table being queried is empty. PL/SQL also raises an exception when a SELECT statement returns more than one row because it is expecting only a single row to be returned. This can occur when the conditions in the WHERE clause are not specific enough or when there are duplicate records in the table.

The CEIL function in SQL is used to round a number up to the nearest integer. It can operate on any data type, whether it is a numeric or non-numeric data type. This makes it a versatile function that can be used in various scenarios regardless of the data type being used.