Oracle Database SQL - 1z0-071 Exam Questions

QUESTION NO: 1
Examine this description of the PRODUCTS table:

Rows exist in this table with data in all the columns. You put the PRODUCTS table in read-only mode.
Which three commands execute successfully on PRODUCTS? (Choose three.)

QUESTION NO: 2
View the Exhibit and examine the structure of the PRODUCT_INFORMATION table.

You want to see the product names and the date of expiration of warranty for all the products, if the product is purchased today. The products that have no warranty should be displayed at the top and the products with maximum warranty period should be displayed at the bottom.
Which SQL statement would you execute to fulfill this requirement?

QUESTION NO: 3
Examine the commands used to create DEPARTMENT_DETAILSand COURSE_DETAILS tables:

You want to generate a list of all department IDs that do not exist in the COURSE_DETAILStable.
You execute the SQL statement:

What is the outcome?

QUESTION NO: 4
Examine this statement:

On which two columns of the table will an index be created automatically? (Choose two.)

QUESTION NO: 5
Which three statements are true about inner and outer joins? (Choose three.)

QUESTION NO: 6
Examine the structure and data in the PRICE_LIST table:

You plan to give a discount of 25% on the product price and need to display the discount amount in the same format as the PROD_PRICE.
Which SQL statement would give the required result?

QUESTION NO: 7
View the Exhibit and examine the structure of the CUSTOMERS table.

You want to generate a report showing the last names and credit limits of all customers whose last names start with A, B, or C, and credit limit is below 10,000.
Evaluate the following two queries:
SQL> SELECT cust_last_name, cust_credit_limit FROM customers
WHERE (UPPER(cust_last_name) LIKE 'A%' OR
UPPER (cust_last_name) LIKE 'B%' OR UPPER (cust_last_name) LIKE 'C%')
AND cust_credit_limit < 10000;
SQL>SELECT cust_last_name, cust_credit_limit FROM customers
WHERE UPPER (cust_last_name) BETWEEN 'A' AND 'C'
AND cust_credit_limit < 10000;
Which statement is true regarding the execution of the above queries?

QUESTION NO: 8
Examine the description of the EMPLOYEES table:

Which statement will fail?

QUESTION NO: 9
Examine this partial command:

Which two clauses are required for this command to execute successfully? (Choose two.)

QUESTION NO: 10
Which statement is true regarding the default behavior of the ORDER BY clause?

QUESTION NO: 11
Examine the data in the CUSTOMERStable:

You want to list all cities that have more than one customer along with the customer details.
Evaluate the following query:

Which two JOIN options can be used in the blank in the above query to give the correct output?
(Choose two.)

QUESTION NO: 12
Which statement will execute successfully?

QUESTION NO: 13
Examine the data in the NEW_EMPLOYEEStable:

Examine the data in the EMPLOYEEStable:

You want to:
1. Update existing employee details in the EMPLOYEEStable with data from the NEW_EMPLOYEES table.
2. Add new employee details from the NEW_EMPLOYEES table to the EMPLOYEEStable.
Which statement will do this?

QUESTION NO: 14
Examine the structure of the invoice table.

Which two SQL statements would execute successfully?

QUESTION NO: 15
Which two statements are true about Data Manipulation Language (DML) statements?