Practice 1Z0-082 Exam Online

Question 1

Which three statements are true about roles?

A : All roles granted to a user are set on by default when the user logs in,

B : Object privileges may not be granted to roles.

C : The SET ROLE statement can disable one or more roles for a session.

D : Roles must be password protected.

E : Roles may be granted to roles.

F : The SET ROLE statement can enable one or more roles for a session.

Answer: A,B,C

Question 2

Evaluate these commands which execute successfully:

Other-Image-28cf0cb7b-b11d-4b80-bafa-57b0fe4fad71

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

A : If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS

B : Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ

C : 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

D : Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

E : Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

Answer: B,C

Question 3

Which statement is true about aggregate functions?

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

B : The AVG function implicitly converts NULLS to zero

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

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

Answer: D

Question 4

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

Question 5

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

B : The second ROLLBACK command replays the delete

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

D : The second ROLLBACK command undoes the insert

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

Answer: C,D

Name:	Oracle Database Administration I
Exam Code:	1Z0-082
Certification:	Oracle Database
Vendor:	Oracle
Total Questions:	144
Last Updated:	Apr 22, 2024

Oracle 1Z0-082