Evaluate the SQL statement:
TRUNCATE TABLE DEPT;
Which three are true about the SQL statement? (Choose three.)

• A. It releases the storage space used by the table.
• B. You can NOT roll back the deletion of rows after the statement executes.
• C. It does not release the storage space used by the table.
• D. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table
• E. You can roll back the deletion of rows after the statement executes.
• F. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.

View the Exhibit and examine the structure of the CUSTOMERS table.
Exhibit: you issue the following SQL statement on the CUSTOMERS table to display the customers who are in the same country as customers with the last name 'king' and whose credit limit is less than the maximum credit limit in countries that have customers with the last name 'king'.


Which statement is true regarding the outcome of the above query?

• A. It produces an error and the IN operator should be replaced by = in the WHERE clause of the main query to get the required output
• B. It produces an error and the < operator should be replaced by < ALL to get the required output
• C. It executes and shows the required result
• D. It produces an error and the < operator should be replaced by < ANY to get the required output

User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would like to create a synonym for this view that can be used by all users of the database.
Which SQL statement can Mary use to accomplish that task?

• A. CREATE SYNONYM EDL_VU ON emp_dept_loc_vu FOR EACH USER;
• B. CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu;
• C. CREATE SYNONYM EDL_VU FOR EACH USER ON emp_dept_loc_vu;
• D. CREATE PUBLIC SYNONYM EDL:VU FOR mary (emp_dept_loc_vu);
• E. CREATE PUBLIC SYNONYM EDL_VU FOR emp_dept_loc_vu;
• F. CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;

Which two statements are true regarding the ORDER BY clause? (Choose two.)

• A. It is executed first in the query execution.
• B. You can specify a combination of numeric positions and column names in this clause.
• C. You cannot specify a column name followed by an expression in this clause.
• D. It cannot be used in a SELECT statement containing a HAVING clause.
• E. It must be the last clause in the SELECT statement.