Free Oracle 1z0-061 Exam Dumps Questions & Answers

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

• A.  A constraint is enforced only for an INSERT operation on a table.
• B.  A foreign key cannot contain NULL values.
• C.  The column with a UNIQUE constraint can store NULLS.
• D.  You can have more than one column in a table as part of a primary key.

Which one is a system privilege?

• A.  CREATE TABLE
• B.  ALTER TABLE
• C.  EXECUTE
• D.  DELETE
• E.  SELECT

View the Exhibit and examine the structure of the PRODUCTS table.
You want to display only those product names with their list prices where the list price is at least double the minimum price.
The report should start with the product name having the maximum list price satisfying this condition.
Evaluate the following SQL statement:
SQL>SELECT prod_name, prod_list_price
FROM products
WHERE prod_list_price >= 2 * prod_min_price
Which ORDER BY clauses can be added to the above SQL statement to get the correct output?
(Choose all that apply.)

• A.  ORDER BY (2*prod_min_price)DESC, prod_name;
• B.  ORDER BY prod_name, (2*prod_min_price)DESC;
• C.  ORDER BY prod_list_price DESC, prod_name;
• D.  ORDER BY prod_list_price DESC, prod_name DESC;
• E.  ORDER BY prod_name DESC, prod_list_price DESC;

The customers table has the following structure:

You need to write a query that does the following tasks:
1. Display the first name and tax amount of the customers. Tax is 5% of their credit limit.
2. Only those customers whose income level has a value should be considered.
3. Customers whose tax amount is null should not be considered.
Which statement accomplishes all the required tasks?

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

Which SQL statement returns a numeric value?

• A.  SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;
• B.  SELECT ROUND(hire_date) FROM EMP;
• C.  SELECT sysdate-hire_date FROM EMP;
• D.  SELECT TO_NUMBER(hire_date + 7) FROM EMP;