1z0-071 Exam Question 26

You issued this command:
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?
  • 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?
  • 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