1z0-071 Exam Question 26
You issued this command:
SQL > DROP TABLE employees;
Which three statements are true? (Choose three.)
SQL > DROP TABLE employees;
Which three statements are true? (Choose three.)
1z0-071 Exam Question 27
Which three are true about granting object privileges on tables, views, and sequences?
1z0-071 Exam Question 28
The SALES table has columns PROD_IDand QUANTITY_SOLDof data type NUMBER.
Which two queries execute successfully?
Which two queries execute successfully?
1z0-071 Exam Question 29
Examine the structure of the MEMBERStable:
Name Null? Type
- --------------- ----------------- ---------------------------
MEMBER_ID NOT NULL VARCHAR2 (6)
FIRST_NAME VARCHAR2 (50)
LAST_NAME NOT NULL VARCHAR2 (50)
ADDRESS VARCHAR2 (50)
CITY VARCHAR2 (25)
STATE VARCHAR2 (3)
You want to display details of all members who reside in states starting with the letter A followed by exactly one character.
Which SQL statement must you execute?
Name Null? Type
- --------------- ----------------- ---------------------------
MEMBER_ID NOT NULL VARCHAR2 (6)
FIRST_NAME VARCHAR2 (50)
LAST_NAME NOT NULL VARCHAR2 (50)
ADDRESS VARCHAR2 (50)
CITY VARCHAR2 (25)
STATE VARCHAR2 (3)
You want to display details of all members who reside in states starting with the letter A followed by exactly one character.
Which SQL statement must you execute?
1z0-071 Exam Question 30
View the Exhibit and examine the description of the ORDERS table.

Which two WHERE clause conditions demonstrate the correct usage of conversion functions? (Choose two.) WHERE order_date_IN ( TO_DATE('OCT 21 2003','MON DD YYYY'), TO_CHAR('NOV 21

Which two WHERE clause conditions demonstrate the correct usage of conversion functions? (Choose two.) WHERE order_date_IN ( TO_DATE('OCT 21 2003','MON DD YYYY'), TO_CHAR('NOV 21
