Online Access Free Oracle.1z1-071.v2022-04-29.q239 Practice Test (Page 6)

1z1-071 Exam Question 21

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS?

A.CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds.

B.SYSDATE can be queried only from the DUAL table.

C.CURRENT_DATE returns the current date and time as per the session time zone.

D.SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server.

E.SYSDATE can be used in expressions only if the default date format is DD-MON-RR.

F.CURRENT_TIMESTAMP returns the same date as CURRENT_DATE.

1z1-071 Exam Question 22

Examine the structure of the MEMBERS table:

Examine the SQL statement:
SQL > SELECT city, last_name LNAME FROM MEMBERS ORDER BY 1, LNAME DESC; What would be the result execution? (Choose the best answer.)

A.It displays all cities in descending order, within which the last names are further sorted in descending order.

B.It displays all cities in ascending order, within which the last names are further sorted in descending order.

C.It fails because a column alias cannot be used in the ORDER BY clause.

D.It fails because a column number and a column alias cannot be used together in the ORDER BY clause.

1z1-071 Exam Question 23

Which two statements are true regarding constraints?

A.Only the primary key can be defined at the column and table levels.

B.A table can have only one primary key but multiple foreign keys.

C.The foreign key and parent table primary key must have the same name.

D.A table can have only one primary key and one foreign key.

E.Both primary key and foreign key constraints can be defined at both column and table levels.

1z1-071 Exam Question 24

Examine the structure of the EMPLOYEES table. (Choose the best answer.)

You must display the details of employees who have manager with MANAGER_ID 100, who were hired in the past 6 months and who have salaries greater than 10000.

A.(SELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000UNION ALLSELECT last_name, hire_date, salaryFROM employeesWHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id = 100))UNIONSELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE -180;

B.SELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000UNION ALL SELECT last_name, hire_date, salaryFROM employeesWHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id = 100)INETRSECTSELECT last_name, hire_date, salaryFROM employees WHERE hire_date > SYSDATE- 180;

C.SELECT last_name, hire_date, salaryFROM employeesWHERE manager_id = (SELECT employee_id FROM employees WHERE employee_id = 100)UNION ALL(SELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE -180INTERSECTSELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000);

D.SELECT last_name, hire_date, salaryFROM employeesWHERE manager_id = (SELECT employee_id FROM employees WHERE employee_id = '100')UNIONSELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE -180INTERSECTSELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000;

1z1-071 Exam Question 25

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

Examine the following SQL statement:
SELECT order_id, product_id, unit_price
FROM order_items
WHERE unit_price
(SELECT MAX(unit_price)
FROM order_items
GROUP BY order_id);
You want to display the PRODUCT_ID of the product that has the highest
UNIT_PRICE per ORDER_ID. What correction should be made in the above SQL statement to achieve this?

A.Remove the GROUP BY clause from the subquery and place it in the main query

B.Replace = with the >ANY operator

C.Replace = with the >ALL operator

D.Replace = with the IN operator

Other Version: 113Oracle.Latestcram.1z1-071.v2022-05-31.by.martina.239q.pdf; 5724Oracle.1z1-071.v2021-12-09.q323; 115Oracle.Lead2passed.1z1-071.v2021-09-02.by.nelly.334q.pdf

Latest Upload: 167ACSM.020-222.v2025-09-11.q48; 156VMware.5V0-31.23.v2025-09-10.q73; 130Oracle.1z0-915-1.v2025-09-10.q24; 159Citrix.1Y0-231.v2025-09-10.q87; 134SAP.C-THR85-2505.v2025-09-09.q29; 166Adobe.AD0-E727.v2025-09-09.q76; 129Oracle.1Z0-1123-25.v2025-09-09.q20; 134SAP.C_SIGPM_2403.v2025-09-08.q20; 253EXIN.ITIL.v2025-09-08.q161; 169BCS.PC-BA-FBA-20.v2025-09-08.q45

1z1-071 Exam Question 21

1z1-071 Exam Question 22

1z1-071 Exam Question 23

1z1-071 Exam Question 24

1z1-071 Exam Question 25

Download PDF File