Free Oracle 1Z0-051 Exam Dumps Questions & Answers

Examine the statement:
Create synonym emp for hr.employees;
What happens when you issue the statement?

• A.  You create a table called employees in the HR schema based on you EMP table.
• B.  You will have two identical tables in the HR schema with different names.
• C.  An error is generated.
• D.  You create an alternative name for the employees table in the HR schema in your own
  schema.

See the Exhibit and examine the structure of the PROMOSTIONS table: Exhibit:

Which SQL statements are valid? (Choose all that apply.)

• A.  SELECT promo_id, DECODE(promo_cost, >10000, 'High',
  <10000, 'Low') "Range"
  FROM promotions;
• B.  SELECT promo_id, DECODE(NVL(promo_cost,0), promo_cost,
  promo_cost * 0.25, 100) "Discount"
  FROM promotions;
• C.  SELECT promo_id, DECODE(promo_cost, 10000,
  DECODE(promo_category, 'G1', promo_cost *.25, NULL),
  NULL) "Catcost"
  FROM promotions;
• D.  SELECT promo_id, DECODE(NULLIF(promo_cost, 10000),
  NULL, promo_cost*.25, 'N/A') "Catcost"
  FROM promotions;

View the Exhibit and examine the data in the PROMOTIONS table.
PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr.
You need to produce a report that provides the name, cost, and start date of all promos in the POST category that were launched before January 1, 2000.
Which SQL statement would you use?

• A.  SELECT promo_name, promo_cost, promo_begin_date FROM promotions WHERE promo_category = 'post' AND promo_begin_date < '01-01-00';
• B.  SELECT promo_name, promo_cost, promo_begin_date FROM promotions WHERE promo_category LIKE 'P%' AND promo_begin_date < '1-JANUARY-00';
• C.  SELECT promo_name, promo_cost, promo_begin_date FROM promotions WHERE promo_category LIKE '%post%' AND promo_begin_date < '1-JAN-00';
• D.  SELECT promo_name, promo_cost, promo_begin_date FROM promotions WHERE promo_cost LIKE 'post%' AND promo_begin_date < '01-01-2000';

Evaluate the following SQL statement:
SQL> SELECT cust_id, cust_last_name "Last Name" FROM customers WHERE country_id = 10 UNION SELECT cust_id CUST_NO, cust_last_name FROM customers
WHERE country_id = 30;
Which ORDER BY clause are valid for the above query? (Choose all that apply.)

• A.  ORDER BY "CUST_NO"
• B.  ORDER BY CUST_NO
• C.  ORDER BY 2,1
• D.  ORDER BY 2,cust_id
• E.  ORDER BY "Last Name"

Evaluate the following SQL query;

What would be the outcome?

• A.  160
• B.  100
• C.  16
• D.  200
• E.  150