May-2022 Oracle 1z0-071 Actual Questions and 100% Cover Real Exam Questions [Q100-Q118]

NEW QUESTION 100
Examine this query:

Which two methods should you use to prevent prompting for a hire date value when this query is executed?

NEW QUESTION 101
You execute this command:
TRUNCATE TABIE depts;
Which two are true?

NEW QUESTION 102
Examine the data in the CUST_NAMEcolumn of the CUSTOMERStable.

You want to extract only those customer names that have three names and display the * symbol in place of the first name as follows:

Which two queries give the required output?

NEW QUESTION 103
View the Exhibit and examine the structure of the ORDERS table. The columns ORDER_MODE and ORDER_TOTAL have the default values ‘direct’ and 0 respectively.

Which two INSERT statements are valid? (Choose two.)

NEW QUESTION 104
Which two statements are true about substitution variables? (Choose two.)

NEW QUESTION 105
Examine this SQL statement:

Which two are true?

NEW QUESTION 106
You and your colleague Andrew have these privileges on the EMPLOYEE_RECORDS table:
1. SELECT
2. INSERT
3. UPDATE
4. DELETE
You connect to the database instance an perform an update to some of the rows in
EMPLOYEE_RECORDS, but don’t commit yet.
Andrew connects to the database instance and queries the table
No othet user are accessing the table
Which two statements ate true at this point?

NEW QUESTION 107
View the Exhibit and examine the structure of the stores table.

You want to display the name of the store along with the address, START_DATE, PROPERTV_PRICE, and the projected property price, which is 115% of the property price. The stores displayed must have START_DATE in the range of 36 months starting from 01Jan-2000 and above.
Which SQL statement would get the desired output?
A)

B)

C)

D)

NEW QUESTION 108
Sales data of a company is stored in two tables, SALES1and SALES2, with some data being duplicated across the tables. You want to display the results from the SALES1table, which are not present in the SALES2table.

Which set operator generates the required output?
INTERSECT

NEW QUESTION 109
The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE NLS_DATE_FORMAT is set to DD-MON-RR.
Which two are true about data type conversions involving these columns in query expressions?

NEW QUESTION 110
View the Exhibit and examine the structure of the PRODUCTS table.

You must display the category with the maximum number of items.
You issue this query:

What is the result?

NEW QUESTION 111
Examine the description of the PRODUCT_DETAILS table:

Which two statements are true?

NEW QUESTION 112
Examine the description of the PRODUCT_DETAILStable:

Which two statements are true? (Choose two.)

NEW QUESTION 113
View the exhibit and examine the description of the DEPARTMENTSand EMPLOYEEStables.

You wrote this SQL statement to retrieve EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME, for all employees:
SELECT employee_id, first_name, department_name
FROM employees
NATURAL JOIN departments;
The desired output is not obtained after executing the above SQL statement. What could be the reason for this?

NEW QUESTION 114
Examine the structure of the EMPLOYEEStable.

There is a parent/child relationship between EMPLOYEE_IDand MANAGER_ID.
You want to display the last names and manager IDs of employees who work for the same manager as the employee whose EMPLOYEE_IDis 123.
Which query provides the correct output?

NEW QUESTION 115
Examine this SQL statement:
SELECT cust_id, cus_last_name “Last Name”
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses, any one of which can complete the query successfully.

NEW QUESTION 116
Which three arithmetic operations can be performed on a column by using a SQL function that is built into Oracle database? (Choose three.)

NEW QUESTION 117
Examine the description of the ORDERS table:
Which three statements execute successfully?

NEW QUESTION 118
Examine this incomplete query:
SELECT DATA’2019-01-01’+<INTERVAL CLAUSE>
FROM DUAL;
Which three clauses can replace<INTERVAL CLAUSE>ti add 22 hours to the date?