Free Access Oracle.1Z0-082.v2023-03-31.q49 Practice Test (Page 11)

Question 46

Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

A.They can be written by server processes

B.Trace files are written to the Fast Recovery Area (FRA)

C.They can be written by background processes

D.All trace files contain error information that require contacting Oracle Support

E.Trace file names are based on the database name concatenated with a sequential number

Question 47

Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?

A.SELECT * FROM customers WHERE city LIKE 'D_';

B.SELECT * FROM customers WHERE city = 'D_%';

C.SELECT * FROM customers WHERE city = '%D_';

D.SELECT * FROM customers WHERE city LIKE 'D_%';

Question 48

Examine the description of the employees table:

Which query requires explicit data type conversion?

A.SELECT join_date + '20' FROM employees; SELECT salary * '120.50' FROM employees;

B.SELECT SUBSTR<join_date, 1, 2) - 10 FROM employees;

C.SELECT join_date FROM employees WHERE join_date > '10-02-2018';

D.SELECT join_date I I ' ' II salary FROM employees;

Question 49

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 SYSDATE - TO_DATE('01-JANUARY-2019') FROM DUAL;

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

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

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

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

Other Version: 2260Oracle.1Z0-082.v2023-08-24.q111; 3871Oracle.1Z0-082.v2022-07-18.q111; 4900Oracle.1Z0-082.v2022-03-27.q110; 5788Oracle.1Z0-082.v2022-02-11.q110; 97Oracle.Prepawaytest.1Z0-082.v2021-09-10.by.ives.98q.pdf

Latest Upload: 107Oracle.1Z0-1057-23.v2025-09-10.q47; 146Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 155TheSecOpsGroup.CNSP.v2025-09-08.q20; 204CFAInstitute.ESG-Investing.v2025-09-08.q173; 152PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 140Salesforce.Data-Architect.v2025-09-05.q216; 136Adobe.AD0-E605.v2025-09-05.q50; 176Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 46

Question 47

Question 48

Question 49

Download PDF File