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

Question 171

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(hire_date,6),1) FROM employees;

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

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

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

Question 172

Examine the data in the PRODUCTStable:

Examine these queries:

Which queries generate the same output?

A.1 and 2

B.1 and 3

C.1, 2, and 3

D.2 and 3

Question 173

Which three are true about multitable INSERTstatements? (Choose three.)

A.They can be performed on remote tables.

B.They can be performed on relational tables.

C.They can be performed on external tables using SQL* Loader.

D.They can be performed on views.

E.They can insert each computed row into more than one table.

F.They can be performed only by using a subquery.

Question 174

Which two statements are true about the DUAL table? (Choose two.)

A.It can be accessed by any user who has the SELECT privilege in any schema.

B.It can be used to display only constants or pseudo columns.

C.It consists of a single row and single column of VARCHAR2data type.

D.It can be accessed only by the SYS user.

E.It can display multiple rows and columns.

F.It can display multiple rows but only a single column.

Question 175

Which two statements are true regarding the WHERE and HAVING clauses in a SELECT statement? (Choose two.)

A.The WHERE clause can be used to exclude rows after dividing them into groups.

B.The aggregate functions and columns used in the HAVING clause must be specified in the SELECT list of the query.

C.The HAVING clause can be used with aggregate functions in subqueries.

D.The WHERE and HAVING clauses can be used in the same statement only if they are applied to different columns in the table.

E.The WHERE clause can be used to exclude rows before dividing them into groups.

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

Latest Upload: 105OCEG.GRCP.v2025-09-11.q211; 104HP.HPE0-V27.v2025-09-11.q78; 118Oracle.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; 223CFAInstitute.ESG-Investing.v2025-09-08.q173; 158PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 149Salesforce.Data-Architect.v2025-09-05.q216; 144Adobe.AD0-E605.v2025-09-05.q50

Question 171

Question 172

Question 173

Question 174

Question 175

Download PDF File