Question 1

You issue this command which succeeds: SQL> DROP TABLE products;
Which three statements are true?

Accepted Answer

Correct answer: BCD

Question 2

Evaluate the following ALTER TABLE statement:
ALTER TABLE orders
SET UNUSED (order_date); Which statement is true?

Accepted Answer

Correct answer: A

Question 3

View the exhibit and examine the structure of the CUSTOMERS table.
Which two tasks would require subqueries or joins to be executed in a single statement?

Accepted Answer

Correct answer: AE

Question 4

You must create a SALES table with these column specifications and data types: (Choose the best answer.) SALESID: Number
STOREID: Number ITEMID: Number
QTY: Number, should be set to 1 when no value is specified
SLSDATE: Date, should be set to current date when no value is specified
PAYMENT: Characters up to 30 characters, should be set to CASH when no value is specified Which statement would create the table?

Accepted Answer

Correct answer: D

Question 5

Which statement is true regarding the UNION operator?

Accepted Answer

Correct answer: B

Question 6

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

Accepted Answer

Correct answer: C

Question 7

Which two tasks can be performed by using Oracle SQL statements?

Accepted Answer

References:
http://www.techonthenet.com/oracle/password.php
https://docs.oracle.com/cd/B28359_01/server.111/b28324/tdpii_distdbs.htm

Question 8

View the Exhibit and examine the structure of the ORDERS table.
Which UPDATE statement is valid?

Accepted Answer

Correct answer: C

Question 9

Examine the structure of the EMPLOYEES table. NameNull?Type
---------------------- ------------ EMPLOYEE_IDNOT NULLNUMBER(6) FIRST_NAMEVARCHAR2(20) LAST_NAMENOT NULLVARCHAR2(25) EMAILNOT
NULLVARCHAR2(25) PHONE NUMBERVARCHAR2(20) HIRE_DATENOT NULLDATE JOB_IDNOT NULLVARCHAR2(10) SALARYNUMBER(8,2)
COMMISSION_PCTNUMBER(2,2) MANAGER_IDNUMBER(6) DEPARTMENT_IDNUMBER(4)
There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID.
You want to display the last names and manager IDs of employees who work for the same manager as the employee whose EMPLOYEE_ID is 123.
Which query provides the correct output?

Accepted Answer

Correct answer: B

Question 10

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

Accepted Answer

Correct answer: A