Oracle 1z0-071 Exam : Oracle Database SQL

Examine the data in the CUST_NAME column of the CUSTOMERS table.
CUST_NAME
------------------------
Renske Ladwig
Jason Mallin
Samuel McCain
Allan MCEwen
Irene Mikkilineni
Julia Nayer
You need to display customers' second names where the second name starts with "Mc" or "MC." Which query gives the required output?

• A. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) FROM customers
  WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1)) LIKE 'Mc%';
• B. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) FROM customers
  WHERE SUBSTR(cust_name, INSTR(cust_name,' ')+1) LIKE INITCAP('MC%');
• C. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) FROM customers
  WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1))='Mc';
• D. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) FROM customers
  WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1)) = INITCAP('MC%');

Which three privileges can be restricted to a subset of columns in a table? (Choose three.)

• A. SELECT
• B. INSERT
• C. INDEX
• D. DELETE
• E. REFERENCES
• F. UPDATE
• G. ALTER

Examine this description of the PRODUCTS table:

You successfully execute this command:

Which two statements execute without errors? (Choose two.)

• A.
  
• B.
  
• C.
  
• D.
  

Examine this partial statement:

Which is true?

• A. Both the query and the subquery can select only zero rows or one row.
• B. The query can select any number of rows, but the subquery can select only zero rows or one row.
• C. The query can select only zero rows or one row, but the subquery can select any number of rows.
• D. Both the query and the subquery can select any number of rows.

Which two statements are true about transactions in the Oracle Database server? (Choose two.)

• A. A session can always see uncommitted updates made by itself.
• B. Data Manipulation Language (DML) statements always start a new transaction.
• C. If a session has an uncommitted transaction, then a DDL statement issues a COMMIT before starting a new transaction.
• D. An uncommitted transaction commits automatically if the user exists SQL*Plus.
• E. A user can always see uncommitted updates made by the same user in a different session.
• F. A Data Definition Language (DDL) statement does a COMMIT automatically only for the data dictionary updates caused by the DDL.