The SQL statements executed in a user session are as follows:

Which two statements describe the consequences of issuing the ROLLBACK TO SAVE POINT a command in the session? (Choose two.)

• A.No SQL statements are rolled back.
• B.Only the second DELETE statement is rolled back.
• C.Both the DELETE statements and the UPDATE statement are rolled back.
• D.The rollback generates an error.
• E.Only the DELETE statements are rolled back.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the PROMOTIONS table.

Evaluate the following SQL statement:

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

• A.It produces an error because subqueries cannot be used with the CASE expression.
• B.It produces an error because the subquery gives an error.
• C.It shows COST_REMARK for all the promos in the promo category 'TV'.
• D.It shows COST_REMARK for all the promos in the table.

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following SQL statement:
SQL> 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
Identify three ORDER BY clauses either one of which can complete the query.

• A.ORDER BY "Last name"
• B.ORDER BY 2, cust_id
• C.ORDER BY CUST_NO
• D.ORDER BY 2, 1
• E.ORDER BY "CUST_NO"

Comment: *

Name: *

Email: *

Verification: *

Examine the data in the CUST_NAME column of the CUSTOMERS table:

You want to display the CUST_NAME values where the last name starts with Mc or MC.
Which two WHERE clauses give the required result?

• A.WHERE SUBSTR (cust_name, INSTR (cust_name, '') +1) LIKE 'Mc%'
• B.WHERE INITCAP (SUBSTR (cust_name, INSTR(cust_name, '')+1)) IN ('MC%', 'Mc%)
• C.WHERE INITCAP (SUBSTR (cust_name, INSTR(cust_name, '')+1)) LIKE 'Mc%'
• D.WHERE SUBSTR (cust_name, INSTR (cust_name, '') +1) LIKE 'Mc%' OR 'MC%'
• E.WHERE UPPER (SUBSTR (cust_name, INSTR(cust_name, '')+1)) LIKE UPPER ('MC%')

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the SALES table. (Choose two.)

Examine this statement:

Which two statements are true about the SALES1 table? (Choose two.)

• A.It will have NOT NULL constraints on the selected columns which had those constraints in the SALES table.
• B.It will not be created because the column-specified names in the SELECT and CREATE TABLE clauses do not match.
• C.It has PRIMARY KEY and UNIQUE constraints on the selected columns which had those constraints in the SALES table.
• D.It is created with no rows.
• E.It will not be created because of the invalid WHERE clause.

Comment: *

Name: *

Email: *

Verification: *