Oracle 1Z0-051 Online Practice Questions and Exam Preparation

Oracle 1Z0-051 Online Questions & Answers

• Question 291:

  Which statement is true regarding the UNION operator?

  A. The number of columns selected in all SELECT statements need to be the same
  B. Names of all columns must be identical across all SELECT statements
  C. By default, the output is not sorted
  D. NULL values are not ignored during duplicate checking
  A. The number of columns selected in all SELECT statements need to be the same

• Question 292:

  Examine the SQL statement that creates ORDERS table:

  CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS (PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date));

  For which columns would an index be automatically created when you execute the above SQL statement? (Choose two.)

  A. SER_NO
  B. ORDER_ID
  C. STATUS
  D. PROD_ID
  E. ORD_TOTAL
  F. composite index on ORDER_ID and ORDER_DATE
  A. SER_NO
  F. composite index on ORDER_ID and ORDER_DATE