Free Oracle 1z0-061 Exam Dumps Questions & Answers

Which are iSQL*Plus commands? (Choose all that apply.)

• A.  UPDATE
• B.  INSERT
• C.  DELETE
• D.  RENAME
• E.  DESCRIBE
• F.  SELECT

Examine the structure of the INVOICE table:
Exhibit:

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

• A.  SELECT inv_no, NVL2(inv_date, sysdate-inv_date, sysdate)FROM invoice;
• B.  SELECT inv_no, NVL2(inv_amt, inv_amt*.25, 'Not Available')FROM invoice;
• C.  SELECT inv_no, NVL2(inv_date, 'Pending', 'Incomplete')FROM invoice;
• D.  SELECT inv_no, NVL2(inv_amt, inv_date, 'Not Available')FROM invoice;

What does the FORCE option for creating a view do?

• A.  creates a view with constraints
• B.  creates a view in another schema even if you don't have privileges
• C.  creates a view regardless of whether or not the base tables exist
• D.  creates a view even if the underlying parent table has constraints

View the Exhibit and examine the structure of the ORDERS and CUSTOMERS tables.

Evaluate the following SQL command:
SQL> SELECT o.order_id, c.cust_name, o.order_total, c.credit_limit
FROM orders o JOIN customers c
USING (customer_id)
WHERE o.order_total > c.credit_limit
FOR UPDATE
ORDER BY o.order_id;
Which two statements are true regarding the outcome of the above query? (Choose two.)

• A.  The locks are released only when a COMMIT or ROLLBACK is issued.
• B.  The locks are released after a DML statement is executed on the locked rows.
• C.  It locks all the rows that satisfy the condition in the statement.
• D.  It locks only the columns that satisfy the condition in both the tables.

You need to perform these tasks:
Which set of SQL statements achieves the desired results?

• A.  CREATE ROLE manager;GRANT create table, create viewTO manager;GRANT
  manager TO BLAKE, CLARK;
• B.  GRANT manager ROLE TO BLAKE, CLARK;GRANT create table, create voewTO BLAKE CLARK;***MISSING***
• C.  CREATE ROLE manager;GRANT create table, create voewTO manager;GRANT
  manager ROLE TO BLAKE, CLARK;