Free Access Oracle.1Z0-082.v2022-07-18.q111 Practice Test (Page 8)

Question 31

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

A.The number, but not names, of columns must be identical for all SELECT statements in the query.

B.The names and number of columns must be identical for all SELECT statements in the query.

C.The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.

D.The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.

E.The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

Question 32

A script abc.sql must be executed to perform a job.
A database user HR, who is defined in this database, executes this command:
$ sqlplus hr/hr@orcl @abc.sql
What will happen upon execution?

A.The command succeeds and HR will be connected to the orcl and abc.sql databases

B.The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed

C.The command fails because the script must refer to the full path name

D.The command fails and reports an error because @ is used twice

Question 33

Which three statements are true about single-row functions? (Choose three.)

A.They can be used only in the WHERE clause of a SELECT statement

B.The argument can be a column name, variable, literal or an expression

C.The data type returned can be different from the data type of the argument

D.They can be nested to any level

E.They can accept only one argument

F.They return a single result row per table

Question 34

You need to calculate the number of days from 1st January 2019 until today.
Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output? (Choose two.)

A.SELECT ROUND(SYSDATE - '01-JAN-2019') FROM DUAL;

B.SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2019' FROM DUAL;

C.SELECT SYSDATE - TO_DATE('01-JANUARY-2019') FROM DUAL;

D.SELECT ROUND(SYSDATE - TO_DATE('01/JANUARY/2019')) FROM DUAL;

E.SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY') - '01-JAN-2019' FROM DUAL;

Question 35

You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command:
Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)

A.You can no longer monitor it

B.It is paused and can be resumed

C.It terminates

D.It continues to run in the background

E.You can reattach to it and monitor it

Other Version: 2581Oracle.1Z0-082.v2023-08-24.q111; 1620Oracle.1Z0-082.v2023-03-31.q49; 5316Oracle.1Z0-082.v2022-03-27.q110; 6221Oracle.1Z0-082.v2022-02-11.q110; 98Oracle.Prepawaytest.1Z0-082.v2021-09-10.by.ives.98q.pdf

Latest Upload: 119Microsoft.MS-700.v2025-12-27.q286; 110SAP.C-BCFIN-2502.v2025-12-27.q12; 113SAP.C-BCBTM-2502.v2025-12-26.q9; 122SAP.C_THR89_2505.v2025-12-26.q45; 114SAP.C-BCBTM-2509.v2025-12-26.q10; 164IAPP.AIGP.v2025-12-25.q64; 146CISI.UAE-Financial-Rules-and-Regulations.v2025-12-25.q35; 177SAP.C-S4TM-2023.v2025-12-25.q82; 128EMC.D-VXR-DS-00.v2025-12-24.q43; 183Splunk.SPLK-5001.v2025-12-24.q37

Question 31

Question 32

Question 33

Question 34

Question 35

Download PDF File