Online Access Free Oracle.1Z0-082.v2022-08-18.q109 Practice Test (Page 18)

1Z0-082 Exam Question 81

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 TIMEZONE

D.TIMESTAMP WITH LOCAL TIMEZONE

E.INTERVAL DAY TO SECOND

1Z0-082 Exam Question 82

Examine the description of the BOOKS table:

The table has 100 rows.
Examine this sequence of statements issued in a new session:
INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL, NULL); SAVEPOINT a; DELETE FROM books; ROLLBACK TO SAVEPOINT a; ROLLBACK; Which two statements are true? (Choose two.)

A.The second ROLLBACK command undoes the insert

B.The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed

C.The second ROLLBACK command replays the delete

D.The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

E.The second ROLLBACK command does nothing

1Z0-082 Exam Question 83

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

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

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

C.They return a single result row per table

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

E.They can accept only one argument

F.They can be nested to any level

1Z0-082 Exam Question 84

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement: