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

The registrar needs a report on the average grade point average (GPA), sorted from the earliest date and the highest GPA to each semester. 

Which of the following statements would accomplish the task?

PROMOTIONS is the public synonym for the link to the PROMOTIONS table in the public database. 

From your current location in Singapore, you are connected to a remote database in Chicago, and issued the following command: 

> SELECT ROUND (SYSDATE-promo_begin_date, 0) FROM promotions WHERE (SYSDATE-promo_begin_date)/365 > 2; 

What would the outcome be?

Examine the description for the CUSTOMERS table in the following Exhibit. 

The CUST_INCOME_LEVEL and CUST_CREDIT_LIMIT columns need to be updated for the customer with the CUST_ID 2360. 

It is required that the CUST_INCOME_LEVEL value be the same as that of the customer with the CUST_ID 2560, as well as the CUST_CREDIT_LIMIT value be the same as that of the customer with CUST_ID 2566. 

Which of the following UPDATE statements would accomplish the task?

The following SQL statements are executed in a user session: 

SQL> CREATE TABLE product (pcode NUMBER(2), pname VARCHAR2(10)); 

SQL> INSERT INTO product VALUES (1, ‘pen’); 

SQL> INSERT INTO product VALUES (2, ‘pencil’); 

SQL> SAVEPOINT a; 

SQL> UPDATE product SET pcode = 10 WHERE pcode = 1; 

SQL> SAVEPOINT b; 

SQL> DELETE FROM product WHERE pcode = 2; SQL> COMMIT; 

SQL> DELETE FROM product WHERE pcode = 10; 

Which of the following statements better describe the result of issuing the ROLLBACK TO SAVE POINT command in the session? (Select two.)

Examine the structure of the PRODUCTS table in the following Exhibit. A report is needed with the following format: 

CATEGORIES - 5MP Digital Photo Camera's category is Photo Y Box's category is Electronics Envoy Ambassador's category is Hardware 

Which of the following queries would produce the required output? (Select two.)

Examine the following SQL statements: 

► CREATE TABLE employees (employee_id NUMBER(2) PRIMARY KEY, last_name VARCHAR(25) NOT NULL, department_id NUMBER(2) NOT NULL, job_id VARCHAR(8) salary NUMBER(10,2)); 

The following command is executed in order to create a view displaying the IDs and last names of the sales staff in the company. 

► CREATE OR REPLACE VIEW sales_staff_vu AS SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘SA_%’ WITH CHECK OPTION; 

Which of the following statements are true in regards of the above view? (Select two.)

Which of the following SQL statements would display the date March 19, 2001 in a format such as "Nineteenth of March 2001 12:00:00 AM"?

Examine the structure of the CUSTOMERS table in the Exhibit below. Analyze the following SQL statement: 

> SELECT cust_city, COUNT (cust_last_name) FROM customers WHERE cust_credit_limit 

> 1000 GROUP BY cust_city HAVING AVG (cust_credit_limit) BETWEEN 5000 AND 6000; 

Which of the following statements is true about executing the above query?