Online Access Free 1Z1-082 Practice Test

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

• A.SELECT TO_CHAR(NVL(cust_credit_limit * .15, 'Not Available')) FROM customers;
• B.SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
• C.SELECT NVL(cust_credit_limit * .15, 'Not Available') FROM customers;
• D.SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
• E.SELECT NVL2(cust_credit_limit * .15, 'Not Available') FROM customers;

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

• A.when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session
• B.when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session
• C.when issuing a DML statement after a DML statement failed in the same session
• D.when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session
• E.when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session
• F.when issuing a TRUNCATE statement after a SELECT statement was issued in the same session

Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

• A.Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO
• B.Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
• C.Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
• D.Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
• E.If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS

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 - TO_DATE('01/JANUARY/2019')) FROM DUAL;
• B.SELECT ROUND(SYSDATE - '01-JAN-2019') FROM DUAL;
• C.SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2019' FROM DUAL;
• D.SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY') - '01-JAN-2019' FROM DUAL;
• E.SELECT SYSDATE - TO_DATE('01-JANUARY-2019') FROM DUAL;

The stores table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 25 months. Which where clause can be used?

• A.WHERE TO_XUMBER(start_date - SYSDATE) <= 25
• B.WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25
• C.WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25
• D.WHERE ADD_MONTHS<start_date, 25) <= SYSDATE