Free Access Oracle.1Z0-082.v2023-08-24.q111 Practice Test (Page 19)

Question 86

Which two statements are true about substitution variables?

A.A substitution variable used to prompt for a column name must be enclosed in double quotation marks.

B.A substitution variable prefixed with & always prompts only once for a value in a session.

C.A substitution variable can be used with any clause in a select statement.

D.A substitution variable used to prompt for a column name must be enclosed in single quotation marks.

E.A substitution variable prefixed with to prompts only once for a value in a session unless it is set to undefined in the session

F.A substitution variable can be used only in a select statement.

Question 87

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

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

B.Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query

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

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

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

Question 88

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 on the wee.
Which query can be used?

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

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

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

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

Question 89

Which is the default column or columns for sorting output from compound queries using SET operators such as intersect In a SQL statement?

A.the first varchab2 column in the first select of the compound query

B.the first column in the last select of the compound query

C.the first column in the first select of the compound query

D.the first number or varchar2 column in the last select of the compound query

E.the first number column in the first select of the compound query

Question 90

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

A.It can be accessed only by the SYS user

B.It consists of a single row and single column of VARCHAR2 data type

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

D.It can display multiple rows and columns

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

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

Other Version: 1762Oracle.1Z0-082.v2023-03-31.q49; 4384Oracle.1Z0-082.v2022-07-18.q111; 5759Oracle.1Z0-082.v2022-03-27.q110; 6577Oracle.1Z0-082.v2022-02-11.q110; 98Oracle.Prepawaytest.1Z0-082.v2021-09-10.by.ives.98q.pdf

Latest Upload: 201PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 298Nokia.4A0-113.v2026-05-01.q69; 253EC-COUNCIL.312-49v11.v2026-04-30.q214; 228Microsoft.MB-820.v2026-04-30.q101; 210Salesforce.MC-202.v2026-04-30.q57; 205BICSI.INSTC_V8.v2026-04-29.q53; 334NMLS.MLO.v2026-04-28.q82; 243NCARB.Project-Management.v2026-04-28.q27; 461EMC.D-AV-DY-23.v2026-04-27.q184; 1115ServiceNow.CSA.v2026-04-27.q483

Question 86

Question 87

Question 88

Question 89

Question 90

Download PDF File