Free Oracle 1Z1-051 Exam Dumps Questions & Answers

Which two statements are true about WHERE and HAVING clauses? (Choose two)

• A.  A WHERE clause can be used to restrict both rows and groups.
• B.  A HAVING clause CANNOT be used in sub queries.
• C.  A HAVING clause can be used to restrict groups only.
• D.  A WHERE clause can be used to restrict rows only.
• E.  A HAVING clause can be used to restrict both rows and groups.
• F.  A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.

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 after a DML statement is executed on the locked rows.
• B.  It locks only the columns that satisfy the condition in both the tables.
• C.  The locks are released only when a COMMIT or ROLLBACK is issued.
• D.  It locks all the rows that satisfy the condition in the statement.

You work as a database administrator at ABC.com. You study the exhibit carefully and examine the structure of CUSTOMRS AND SALES tables.

Evaluate the following SQL statement:
Exhibit:

Which statement is true regarding the execution of the above UPDATE statement?

• A.  It would execute and restrict modifications to only the column specified in the SELECT statement
• B.  It would not execute because two tables cannot be used in a single UPDATE statement
• C.  It would not execute because a sub query cannot be used in the WHERE clause of an UPDATE statement
• D.  It would not execute because the SELECT statement cannot be used in place of the table name

The PART_CODE column in the SPARES table contains the following list of values:

Which statement is true regarding the outcome of the above query?

• A.  It displays all values.
• B.  It produces an error.
• C.  It displays only the values A%BWQ123 and AB_WQ123.
• D.  It displays only the values A%_WQ123 and AB_WQ123 .
• E.  It displays only the values A%_WQ123 and A%BWQ123 .

Which three are true? (Choose three.)

• A.  A MERGE statement is used to merge the data of one table with data from another.
• B.  A MERGE statement can be used to update existing rows in a table.
• C.  A MERGE statement replaces the data of one table with that of another.
• D.  A MERGE statement can be used to insert new rows into a table.