The STUDENT_GRADES table contains the following columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4, 3) 

The registrar has requested a report that lists the students' grade point averages (GPA) sorted in descending order. 

Which statement would produce a report that satisfy the request?

The EMPLOYEES table contains the following columns: 

► EMPLOYEE_ID NUMBER(4) ENAME VARCHAR2 (25) JOB_ID VARCHAR2(10) Which of the following SQL statements would return, for those employees whose ENAME ends with a letter "n", their ENAME, length of the ENAME, and numeric position of the letter "a" in the ENAME column?

Examine the SQL statement below: 

► SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; 

Which values would be displayed?

Which statement is true regarding the WITH GRANT OPTION clause?

You own a table called EMPLOYEES with the following structure: 

► EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE The following statement is issued: 

► DELETE employees; 

What would result from the execution of this DELETE statement?

The following SQL statement is issued:

 ► SELECT cust_id, cust_last_name "Last Name" FROM customers WHERE country_id = 10 UNION SELECT cust_id CUST_NO, cust_last_name FROM customers WHERE country_id = 30; 

Which ORDER BY clauses would be valid for the issued query? (Select all applicable.)

Which of the following statemens is true regarding sequences?

Which of the following options is a valid CREATE TABLE statement?