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: Nov 13, 2024

Add To Cart

Question 1

Which three statements are true about roles?

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

B : ject privileges may not be granted to roles.

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

D : les must be password protected.

E : les may be granted to roles.

F : 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?

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

B : sales table has five foreign keys.

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

D : customer can exist in many countries.

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

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

Answer: A,B,C

Question 3

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 4

Which three statements are true concerning logical and physical database structures? (Choose three.)

A : l tablespaces may have one or more data files

B : extents of a segment must always reside in the same datafile

C : mallfile tablespace might be bigger than a bigfile tablespace

D : egment can span multiple data files in some tablespaces

E : egment's blocks can be of different sizes

F : egment might have only one extent

G : gments can span multiple tablespaces

Answer: A,B,C

Question 5

Examine this SQL statement:

SELECT cust_id, cust_last_name ''Last Name''

FROM customers

WHERE country_id = 10

UNION

SELECT cust_id CUST_NO, cust_last_name

FROM customers

WHERE country_id = 30

Identify three ORDER BY clauses, any one of which can complete the query successfully. (Choose three.)

A : DER BY ''Last Name''

B : DER BY 2, 1

C : DER BY 2, cust_id

D : DER BY CUST_NO

E : DER BY ''CUST_NO''

Answer: B,C,D

Page: 1 / 29

Total 144 Questions | Updated On: Nov 13, 2024

Add To Cart