Free Oracle 1z0-061 Exam Dumps Questions & Answers

View the Exhibit and examine the structure of the PRODUCTS, SALES, and
SALE_SUMMARY tables.
SALE_VW is a view created using the following command:
SQL>CREATE VIEW sale_vw AS
SELECT prod_id, SUM(quantity_sold) QTY_SOLD
FROM sales GROUP BY prod_id;
You issue the following command to add a row to the SALE_SUMMARY table:
SQL>INSERT INTO sale_summary
SELECT prod_id, prod_name, qty_sold FROM sale_vw JOIN products
USING (prod_id) WHERE prod_id = 16;
What is the outcome?

• A.  It gives an error because a complex view cannot be used to add data into the SALE_SUMMARY table.
• B.  It gives an error because the column names in the subquery and the SALE_SUMMARY table do not match.
• C.  It gives an error because the number of columns to be inserted does not match with the number of columns in the SALE_SUMMARY table.
• D.  It executes successfully.

Study this view creation statement:
create view dept30 as select department_id,employee_id,last_name from employees where department_id=30 with check option; What might make the following statement fail? (Choose the best answer.) update dept30 set department_id=10 where employee_id=114;

• A.  The view is too complex to allow DML operations.
• B.  The WITH CHECK OPTION will reject any statement that changes the
  DEPARTMENT_ID.
• C.  The statement will succeed.
• D.  Unless specified otherwise, views will be created as WITH READ ONLY.

Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?

• A.  ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK
  customer_name IS NOT NULL;
• B.  ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;
• C.  ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;
• D.  ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;
• E.  ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn
  NOT NULL;
• F.  ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL;

What is true about the WITH GRANT OPTION clause?

• A.  It allows a grantee DBA privileges.
• B.  It is used to grant an object privilege on a foreign key column.
• C.  It is required syntax for object privileges.
• D.  It allows the grantee to grant object privileges to other users and roles.
• E.  It allows privileges on specified columns of tables.

Which statement adds a column called salary to the employees table having 100 rows, which cannot contain null?

• A.  Option D
• B.  Option A
• C.  Option C
• D.  Option B