ORDER_TOTAL is a column in the orders table with the data type and size as number (8, 2) Examine the following code: Which statement is correct about the above code? A. It gives an error in line 3 B. It…

View the Exhibit and examine the structure of the EMP table. You want to create two procedures using the overloading feature to search for employee details based on either the employee name or employee number. Which two rules should you…

Which two statements are true about the instead of triggers? (Choose two.) A. Delete operations cannot be performed using the instead of triggers. B. The instead or triggers must be created to add or modify data through any view. C.…

Which two statements are correct about the usage of parameters in functions? (Choose two.) A. Functions can have only in mode parameters. B. Functions called in SQL statements cannot have out or in out mode parameters. C. Functions having in,…

View the Exhibit and examine the structure of the employees table. Examine the following block of code: What is the outcome when the above code is executed? A. It executes successfully. B. It gives an error because decode cannot be…

Examine the following code: Which two statements are true about the above function? (Choose two.) A. It can be used only in a parallelized query. B. It can be used in both a parallelized query and a parallelized DML statement.…

/temp/my_files is an existing folder in the server, facultylist.txt is an existing text file in this folder Examine the following commands that are executed by the DBA: SQL>CREATE DIRECTION my_dir AS ‘ /temp/my_files’: SQL>GRANT READ ON DIRECTORY my_dir To pubiic:…

View the Exhibit to examine the PL/SQL block. Which statement is true about the execution of the PL/SQL block? A. It executes successfully and gives the desired output. B. It does not execute because the definition of type population is…

User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA. HR is an existing schema in the database. SCOTT creates the following trigger: CREATE OR REPLACE TRIGGER drop_trigger BEFORE DROP ON hr.SCHEMA BEGIN RAISE_APPLICATION_ERROR (-20000,…

Which two statements are true about the continue statement? (Choose two.) A. The PL/SQL block execution terminates immediately. B. The CONTINUE statement cannot appear outside a loop. C. The loop completes immediately and control passes to the statement after end…