Free Oracle 1Z0-082 Exam Questions

Become Oracle Certified with updated 1Z0-082 exam questions and correct answers

Page: 1 / 29

Total 144 Questions | Updated On: Jun 14, 2020

Add To Cart

Question 1

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

A : : returns the quotient of a division operation

B : OOR : returns the smallest integer greater than or equal to a specified number

C : UNC : can be used with NUMBER and DATE values

D : NCAT : can be used to combine any number of values

E : IL : can be used for positive and negative numbers

Answer: A,C

Question 2

Examine the description of the BOOKS table:

Other-Image-23cf679d4-e595-43a2-9926-33e15cdf075b

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 : second ROLLBACK command does nothing

B : second ROLLBACK command replays the delete

C : first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed

D : second ROLLBACK command undoes the insert

E : first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

Answer: C,D

Question 3

Which statement is true about aggregate functions?

A : gregate functions can be nested to any number of levels

B : AVG function implicitly converts NULLS to zero

C : gregate functions can be used in any clause of a SELECT statement

D : MAX and MIN functions can be used on columns with character data types

Answer: D

Question 4

Examine the description of the employees table:

Other-Image-27be966aa-f1d1-485b-934c-16348004fe68

Which query requires explicit data type conversion?

A :

B :

C :

D :

Answer: A

Question 5

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

A : Oracle Managed Files (OMF)

B : Online table segment shrink

C : Online index segment shrink

D : Automatic data file extension (AUTOEXTEND)

E : Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

Answer: A,D,E

Page: 1 / 29

Total 144 Questions | Updated On: Jun 14, 2020

Add To Cart