Prepare with Oracle : 1Z1-051 exam braindumps as your best preparation materials

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:

and examine the structure of CUSTOMRS AND SALES tables:
Evaluate the following SQL statement:
Exhibit:

Which statement is true regarding the execution of the above UPDATE statement?

• A. It would not execute because the SELECT statement cannot be used in place of the table name
• B. It would not execute because a sub query cannot be used in the WHERE clause of an UPDATE statement
• C. It would execute and restrict modifications to only the column specified in the SELECT statement
• D. It would not execute because two tables cannot be used in a single UPDATE statement

Evaluate the following SQL statements:
Exhibit:

Which is the correct output of the above query?

• A. +25-00, +54-02, +00 11:12:10.123457
• B. +00-300,+00-650,+00 11:12:10.123457
• C. +25-00,+00-650,+00 11:12:10.123457
• D. +00-300, +54-02,+00 11:12:10.123457

Which two statements are true regarding indexes? (Choose two.)

• A. They can be created on tables and clusters.
• B. They can be created on tables and simple views.
• C. You can create more than one index by using the same columns if you specify distinctly different combinations of the columns.
• D. You can create only one index by using the same columns.

Examine the data in the PROMO_BEGIN_DATE column of the PROMOTIONS table:
PROMO_BEGIN _DATE 04-jan-00
10-jan-00
15-dec-99
18-oct-98
22-aug-99
You want to display the number of promotions started in 1999 and 2000.
Which query gives the correct output?

• A. SELECT SUM(DECODE(SUBSTR(promo_begin_date,8),'00',1,0)) "2000",
  SUM(DECODE(SUBSTR
  (promo_begin_date,8),'99',1,0)) "1999"
  FROM promotions;
• B. SELECT COUNT(CASE TO_CHAR(promo_begin_date,'yyyy') WHEN '99' THEN 1 ELSE 0 END) "1999", COUNT(CASE TO_CHAR(promo_begin_date,'yyyy') WHEN '00' THEN 1 ELSE 0 END) "2000" FROM promotions;
• C. SELECT SUM(CASE TO_CHAR(promo_begin_date,'yyyy') WHEN '99' THEN 1 ELSE 0 END)
  "1999",SUM(CASE TO_CHAR(promo_begin_date,'yyyy') WHEN '00' THEN 1 ELSE 0 END)
  "2000"
  FROM promotions;
• D. SELECT COUNT(DECODE(SUBSTR(TO_CHAR(promo_begin_date,'yyyy'), 8), '1999', 1, 0))
  "1999", COUNT(DECODE(SUBSTR(TO_CHAR(promo_begin_date,'yyyy'), 8),'2000', 1,
  0)) "2000"
  FROM promotions;

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. composite index on ORDER_ID and ORDER_DATE
• B. STATUS
• C. ORDER_ID
• D. PROD_ID
• E. SER_NO
• F. ORD_TOTAL