Latest [Apr 03, 2022] 1z0-071 Exam Dumps – Valid and Updated Dumps [Q63-Q85]

NEW QUESTION 63
Examine the command:

What does ON DELETE CASCADE imply?

NEW QUESTION 64
View the Exhibits and examine PRODUCTSand SALES tables.
Exhibit 1

Exhibit 2

You issue the following query to display product name the number of times the product has been sold:

What happens when the above statement is executed?

NEW QUESTION 65
View the Exhibit and examine the structure of the PROMOTIONS table.
Evaluate the following SQL statement:
Which statement is true regarding the outcome of the above query?

NEW QUESTION 66
Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

NEW QUESTION 67
View the Exhibit and examine the structure of the CUSTOMERStable.

CUSTOMER_VUis a view based on CUSTOMERS_BR1 table which has the same structure as CUSTOMERStable.
CUSTOMERSneed to be updated to reflect the latest information about the customers.
What is the error in the following MERGEstatement?

NEW QUESTION 68
Which two statements are true regarding the GROUP BY clause in a SQL statement?
(Choose two.)

NEW QUESTION 69
Which three are true about privileges and roles?

NEW QUESTION 70
You must create a table EMPLOYEES in which the values in the columns EMPLOYEES_ID and LOGIN_ID must be unique and not null.
Which two SQL statements would create the required table? (Choose two.)

NEW QUESTION 71
Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1,
Some sales data is duplicated In both tables.
You want to display the rows from the SALES1 table which are not present in the SALIES2 table.
Which set operator generates the required output?

NEW QUESTION 72
Examine the data in the CUST_NAME column of the CUSTOMERS table:

You want to display the CUST_NAME values where the last name starts with Mc or MC.
Which two WHERE clauses give the required result?

NEW QUESTION 73
Which statement falls to execute successfully?

NEW QUESTION 74
Which three are true about system and object privileges? (Choose three.)

NEW QUESTION 75
SCOTTis a user in the database.
Evaluate the commands issued by the DBA:

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

NEW QUESTION 76
Examine this SELECT statement and view the Exhibit to see its output:

SELECT constraints_name, constraints_type, search_condition, r_constraints_name, delete_rule, status, FROM user_constraints WHERE table_name = ‘ORDERS’; Which two statements are true about the output? (Choose two.)

NEW QUESTION 77
Examine the description of the BOOKS_TRANSACTIONStable:

Examine this partial SQL statement:
SELECT * FROM books_transactions
Which two WHEREconditions give the same result? (Choose two.)
WHERE borrowed_date = SYSDATE AND (transaction_type = ‘RM’ OR member_id IN

NEW QUESTION 78
Evaluate the following query:
SQL> SELECT TRUNC (ROUND (156.00, -1),-1)
FROM DUAL;
What would be the outcome?

NEW QUESTION 79
View the Exhibit and examine the structure in the EMPLOYEES tables.

Evaluate the following SQL statement:
SELECT employee_id, department_id
FROM employees
WHERE department_id= 50 ORDER BY department_id
UNION
SELECT employee_id, department_id
FROM employees
WHERE department_id= 90
UNION
SELECT employee_id, department_id
FROM employees
WHERE department_id= 10;
What would be the outcome of the above SQL statement?

NEW QUESTION 80
View the Exhibit and examine the structure of the ORDER_ITEMS table. (Choose the best answer.) You must select the ORDER_ID of the order that has the highest total value among all the orders in the ORDER_ITEMS table.
Which query would produce the desired result?

NEW QUESTION 81
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 82
View the Exhibit and examine the structure of the PRODUCT table.

Which two tasks would require subqueries? (Choose two.)

NEW QUESTION 83
Which two statements are true regarding a SAVEPOINT? (Choose two.)

NEW QUESTION 84
Examine the structure of the MARKS table:
Which two statements would execute successfully? (Choose two.)

NEW QUESTION 85
Which two are true about virtual columns?