Question 1

Which three statements are true about roles?

Options :

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

View the Exhibit and examine the description of the tables.

You execute this SQL statement:

Other-Image-3de95013a-a7fc-4279-9a4b-7740f766c151

Which three statements are true?

Options :

A : The statement will fall if a row already exists in the sales table for product 23.

B : The sales table has five foreign keys.

C : A product can have a different unit price at different times.

D : A customer can exist in many countries.

E : The statement will execute successfully and a new row will be inserted into the sales table.

F : The statement will fail because a subquery may not be contained in a values clause.

Answer: A,B,C

Question 3

Which two statements are true about Database Instances and Real Application Clusters (RAC)?

Options :

A : A RAC database can have one Instance.

B : A RAC database can have instances on separate servers.

C : Two RAC databases can share their instances.

D : A RAC database must have three or more Instances.

E : A RAC database must have two or more instances.

Answer: A,B

Question 4

Which statement is true about aggregate functions?

Options :

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 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.)

Options :

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

Confidently Practice Online with Free 1Z0-082 Exam Cram

Buying Options: