Free Access Oracle.1Z0-082.v2022-03-27.q110 Practice Test (Page 14)

Question 61

Which two statements are true about the rules of precedence for operators? (Choose two.)

A.NULLS influence the precedence of operators in an expression

B.The concatenation operator | | is always evaluated before addition and subtraction in an expression

C.The + binary operator has the highest precedence in an expression in a SQL statement

D.Multiple parentheses can be used to override the default precedence of operators in an expression

E.Arithmetic operators with equal precedence are evaluated from left to right within an expression

Question 62

In which three situations does a new transaction always start? (Choose three.)

A.when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session

B.when issuing a TRUNCATE statement after a SELECT statement was issued in the same session

C.when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session

D.when issuing a DML statement after a DML statement failed in the same session

E.when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session

F.when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session

Question 63

Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1.
Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table.
Which set operator generates the required output?

A.SUBTRACT

B.UNION

C.INTERSECT

D.UNION ALL

E.MINUS

Question 64

You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
1. Be stored in a format supporting date arithmetic without using
conversion functions
2. Store a loan period of up to 10 years
3. Be used for calculating interest for the number of days the loan
remains unpaid
Which data type should you use?

A.INTERVAL YEAR TO MONTH

B.TIMESTAMP

C.TIMESTAMP WITH LOCAL TIMEZONE

D.TIMESTAMP WITH TIMEZONE

E.INTERVAL DAY TO SECOND

Question 65

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)

A.SELECT NVL2(cust_credit_limit * .15, `Not Available') FROM customers;

B.SELECT NVL(cust_credit_limit * .15, `Not Available') FROM customers;

C.SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;

D.SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;

E.SELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available')) FROM customers;

Other Version: 3043Oracle.1Z0-082.v2023-08-24.q111; 1762Oracle.1Z0-082.v2023-03-31.q49; 4386Oracle.1Z0-082.v2022-07-18.q111; 6580Oracle.1Z0-082.v2022-02-11.q110; 98Oracle.Prepawaytest.1Z0-082.v2021-09-10.by.ives.98q.pdf

Latest Upload: 202PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 301Nokia.4A0-113.v2026-05-01.q69; 258EC-COUNCIL.312-49v11.v2026-04-30.q214; 229Microsoft.MB-820.v2026-04-30.q101; 212Salesforce.MC-202.v2026-04-30.q57; 206BICSI.INSTC_V8.v2026-04-29.q53; 336NMLS.MLO.v2026-04-28.q82; 244NCARB.Project-Management.v2026-04-28.q27; 465EMC.D-AV-DY-23.v2026-04-27.q184; 1121ServiceNow.CSA.v2026-04-27.q483

Question 61

Question 62

Question 63

Question 64

Question 65

Download PDF File