View Exhibit1 and examine the structure of the EMP table.

View Exhibit2 and examine the code.

EKPNOS 7845 and 7900 exist in the EMP table.
Which two calls to the RAISE_SALABY procedure in the anonymous block execute successfully? (Choose two.)

View Exhibit1 and examine the structure of the employees table.

User SCOTT needs to generate a text report that contains the names of all employees and their salaries.
Examine the following commands issued by the DBA: SQL_CREATE DICTORY my_dir AS '/temp/my_files* ; SQL_GRANT WRITE ON DIRECTORY my_dir TO SCOTT;
View Exhibit2 and examine the procedure code. You issue the following command: You issue the following command:

SQL_EXEC sal_5tatus ('MY_DIR', 'EMPREPORT.TXT')
What is the outcome?

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?

You want to maintain an audit of the date and time when each user of the database logs off.
Examine the following code:

Which two clauses should be used to fill in the blanks and complete the above code?
(Choose two.)

You execute the following block of code:

Which statement is true about the outcome?