Free Access Oracle.1z1-071.v2022-04-30.q200 Practice Test (Page 12)

Question 51

View the Exhibit and examine the structure of the CUSTOMERS table.

Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two.)

A.listing of customers who do not have a credit limit and were born before 1980

B.finding the number of customers, in each city, whose marital status is 'married'

C.finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'

D.listing of those customers whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'

E.finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers

Question 52

Examine the data in the CUST_NAMEcolumn of the CUSTOMERStable.
CUST_NAME
-------------------
Renske Ladwig
Jason Mallin
Samuel McCain
Allan MCEwen
Irene Mikilineni
Julia Nayer
You need to display customers' second names where the second name starts with "Mc" or "MC".
Which query gives the required output?

A.SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)
FROM customers
WHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ' ')+1))
LIKE 'Mc%';

B.SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)
FROM customers
WHERE SUBSTR (cust_name, INSTR (cust_name, ' ')+1)
LIKE INITCAP ('MC%');

C.SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)
FROM customers
WHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ' ')+1))
INITCAP 'MC%';

D.SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)
FROM customers
WHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ' ')+1))
'Mc';

Question 53

Examine the description of the EMPLOYEES table:

Which two queries return the highest salary in the table?

A.SELECT department_id, MAX(salary)
FROM employees
GROUP BY department_id;

B.SELECT MAX (salary)
FROM employees
GROUP BY department_id
HAVING MAX (salary) = MAX (MAX (salary));

C.SELECT MAX (salary)
FROM employees;

D.SELECT MAX (MAX (salary))
FROM employees
GROUP BY department_id;

E.SELECT MAX (salary)
FROM employees
GROUP BY department_id;

Question 54

Which three statements are true regarding single row subqueries?

A.They must return a row to prevent errors in the SQL statement.

B.They must be placed on the left side of the comparison operator or condition.

C.A SQL statement may have multiple single row subquery blocks.

D.They can be used in the HAVING clause.

E.They must be placed on the right side of the comparison operator or condition.

F.They can be used in the clause.

Question 55

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.)

A.The DELETE_RULE column indicates the desired state of related rows in the child table when the corresponding row is deleted from the parent table.

B.In the second column, 'c' indicates a check constraint.

C.The STATUS column indicates whether the table is currently in use.

D.The R_CONSTRAINT_NAME column contains an alternative name for the constraint.

Other Version: 1038Oracle.1z1-071.v2025-05-13.q352; 36Oracle.Prepawayete.1z1-071.v2022-01-25.by.lauren.209q.pdf

Latest Upload: 103OCEG.GRCP.v2025-09-11.q211; 102HP.HPE0-V27.v2025-09-11.q78; 117Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 164TheSecOpsGroup.CNSP.v2025-09-08.q20; 222CFAInstitute.ESG-Investing.v2025-09-08.q173; 157PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 147Salesforce.Data-Architect.v2025-09-05.q216; 141Adobe.AD0-E605.v2025-09-05.q50

Question 51

Question 52

Question 53

Question 54

Question 55

Download PDF File