Free Oracle 1Z1-051 Exam Dumps Questions & Answers

You issue the following command to drop the PRODUCTS table:
SQL>DROP TABLE products;
What is the implication of this command? (Choose all that apply.)

• A.The pending transaction in the session is committed
• B.All viewsand synonyms will remain but they are invalidated
• C.All indexes on the table will remain but they are invalidated
• D.All data along with the table structure is deleted
• E.All data in the table are deleted but the table structure will remain

View the Exhibit and examine the structure of the SALES table.
The following query is written to retrieve all those product IDs from the SALES table that have more than 55000 sold and have been ordered more than 10 times.

Which statement is true regarding this SQL statement?

• A.It executes successfully but produces no result because COUNT(prod_id) should be usedinstead of COUNT(*).
• B.It produces an error because COUNT(*) should be only in the HAVING clause and not in the WHERE clause.
• C.It produces an error because COUNT(*) should be specified in the SELECT clause also.
• D.It executes successfully and generates the required result.

View the Exhibit and examine the structure of the PRODUCTS table.
All products have a list price.
You issue the following command to display the total price of each product after a discount of 25% and a tax of 15% are applied on it. Freight charges of S100 have to be applied to all the products.

What would be the outcome if all the parentheses are removed from the above statement?

• A.The total price value would be higher than the correct value.
• B.The result remains unchanged.
• C.It produces a syntax error.
• D.The total price value would be lower than the correct value.

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

Which two SQL statements would execute successfully? (Choose two.)

• A.UPDATE promotions SET promo_cost = promo_cost+ 100 WHERE TO_CHAR(promo_end_date, 'yyyy') > '2000';
• B.SELECT TO_CHAR(promo_begin_date,'dd/month')
  FROM promotions
  WHERE promo_begin_date IN (TO_DATE('JUN 01 98'), TO_DATE('JUL 01 98'));
• C.SELECT promo_begin_date
  FROM promotions
  WHERE TO_CHAR(promo_begin_date,'mon dd yy')='jul 01 98';
• D.UPDATE promotions SET promo_cost = promo_cost+ 100 WHERE promo_end_date > TO_DATE(SUBSTR('01-JAN-2000',8));

View the Exhibit and examine the structure of CUSTOMERS table.
Evaluate the following query:

Which statement is true regarding the above query?

• A.It produces an error because the condition on the CUST_CITY column is not valid.
• B.It produces an error because conditions on the CUST_CREDIT_LIMIT column are not valid.
• C.It executes successfully.
• D.It produces an error because the condition on the CUST_FIRST_NAME column is not valid.