Free Access Oracle.1z1-071.v2025-05-13.q352 Practice Test (Page 34)

Question 161

Which two queries will result in an error?

A.SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
FROM EMPLOYEES
WHERE ANNUAL_SALARY > 100000
ORDER BY 12 * SALARY ;

B.SELECT FIRST_NAME,LAST_NAME FROM EMPLOYEES;

C.SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
FROM EMPLOYEES
WHERE 12 * SALARY > 100000
ORDER BY 12 * SALARY;

D.SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
FROM EMPLOYEES
WHERE ANNUAL_SALARY > 100000
ORDER BY ANNUAL_SALARY;

E.SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
FROM EMPLOYEES
WHERE 12 * SALARY > 100000
ORDER BY ANNUAL_SALARY;

F.SELECT FIRST_NAME LAST_NAME FROM EMPLOYEES;

Question 162

Examine the structure of the ORDERS table: (Choose the best answer.)

You want to find the total value of all the orders for each year and issue this command:
SQL> SELECT TO_CHAR(order_date,'rr'), SUM(order_total) FROM orders
GROUP BY TO_CHAR(order_date, 'yyyy');
Which statement is true regarding the result?

A.It returns an error because the TO_CHAR function is not valid.

B.It executes successfully but gives the correct output.

C.It executes successfully but does not give the correct output.

D.It return an error because the datatype conversion in the SELECT list does not match the data type conversion in the GROUP BY clause.

Question 163

Which three actions can you perform by using the ORACLE_DATAPUMP access driver? (Choose three.)

A.Read data from a table in the database and insert it into an external table

B.Query data from an external table

C.Read data from an external table and load it into a table in the database

D.Create a directory object for an external table

E.Create a directory object for a flat file

F.Execute DML statements on an external table

Question 164

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE
You want to display the date of the first Monday after the completion of six months since hiring.
The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day of the week Which query can be used?

A.SELECT emp_id,NEXT_DAY(ADD_MONTHS(hite_date,6),'MONDAY') FROM employees;

B.SELECT emp_id,NEXT_DAY(ADD_MONTHS(hire_date,6),1) FROM employees;

C.SELECT emp_id,ADD_MONTHS(hire_date,6), NEXT_DAY('MONDAY') FROM employees;

D.SELECT emp_id,NEXT_DAY(MONTHS_BETWEEN(hire_date,SYSDATE),6) FROM employees;

Question 165

Which two are true about constraints?

A.Constraints are enforced only during INSERT operations.

B.A column with a foreign key constraint can never contain a null value.

C.All constraints can be defined at the table or column level.

D.A constraint can be disabled even if the constrained column contains data.

E.A column with a UNIQUE constraint can contain a NULL value.

Other Version: 4657Oracle.1z1-071.v2022-04-30.q200; 36Oracle.Prepawayete.1z1-071.v2022-01-25.by.lauren.209q.pdf

Latest Upload: 282PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 412Nokia.4A0-113.v2026-05-01.q69; 440EC-COUNCIL.312-49v11.v2026-04-30.q214; 403Microsoft.MB-820.v2026-04-30.q101; 274Salesforce.MC-202.v2026-04-30.q57; 322BICSI.INSTC_V8.v2026-04-29.q53; 457NMLS.MLO.v2026-04-28.q82; 299NCARB.Project-Management.v2026-04-28.q27; 547EMC.D-AV-DY-23.v2026-04-27.q184; 1388ServiceNow.CSA.v2026-04-27.q483

Question 161

Question 162

Question 163

Question 164

Question 165

Download PDF File