Oracle 1Z0-082 Exam Real Questions

Prepare and pass your Oracle Database Administration I with free 1Z0-082 exam questions.

Page: 1 / 29

Total 144 Questions | Updated On: Oct 09, 2024

Add To Cart

Question 1

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 2

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 3

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

A : RAC database can have one Instance.

B : RAC database can have instances on separate servers.

C : o RAC databases can share their instances.

D : RAC database must have three or more Instances.

E : RAC database must have two or more instances.

Answer: A,B

Question 4

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 5

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

Page: 1 / 29

Total 144 Questions | Updated On: Oct 09, 2024

Add To Cart