Online Access Free 1z1-061 Exam Questions

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

• A.Rows cannot be deleted through a view if the view definition contains the DISTINCT keyword.
• B.Rows added through a view are deleted from the table automatically when the view is dropped.
• C.A simple view in which column aliases have been used cannot be updated.
• D.The WITH CHECK OPTION constraint can be used in a view definition to restrict the columns displayed through the view.
• E.The OR REPLACE option is used to change the definition of an existing view without dropping and recreating it.

View the Exhibit and examine the description for the PRODUCTS and SALES table.

PROD_ID is a primary key in the PRODUCTS table and foreign key in the SALES table.
You want to remove all the rows from the PRODUCTS table for which no sale was done for the last three years. Which is the valid DELETE statement?

• A.DELETEFROM productsWHERE prod_id IN (SELECT prod_idFROM salesWHERE
  SYSDATE - 3*365 >= time_id);
• B.DELETEFROM productsWHERE prod_id IN (SELECT prod_idFROM salesWHERE
  time_id >= SYSDATE - 3*365 );
• C.DELETEFROM productsWHERE prod_id = (SELECT prod_idFROM salesWHERE
  SYSDATE >= time_id - 3*365 );
• D.DELETEFROM productsWHERE prod_id = (SELECT prod_idFROM salesWHERE
  time_id - 3*365 = SYSDATE );

See the structure of the PROGRAMS table:

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

• A.SELECT TO_DATE(NVL(SYSDATE-END_DATE, SYSDATE))FROM programs;
• B.SELECT NVL(TO_CHAR(MONTHS_BETWEEN(start_date, end_date)), 'Ongoing') FROM programs;
• C.SELECT NVL(ADD_MONTHS(END_DATE, 1), SYSDATE)FROM programs;
• D.SELECT NVL(MONTHS_BETWEEN(start_date, end_date), 'Ongoing')FROM programs;

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:

Which DELETE statement is valid?

• A.DELETE * FROM employeesWHERE employee_id=(SELECT employee_id FROM
  new_employees);
• B.DELETE FROM employeesWHERE employee_id = (SELECT employee_id FROM
  employees);
• C.DELETE FROM employeesWHERE employee_id IN (SELECT employee_id . FROM new_employees . WHERE name = 'Carrey');
• D.DELETE * FROM employeesWHERE employee_id IN (SELECT employee_id . FROM new_employees . WHERE name = 'Carrey');

View the Exhibit and examine the structure of the PROMOTIONS table. Which SQL statements are valid? (Choose all that apply.)

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