Online 1Z0-082 Practice Test

Question 1

Which compression method is recommended for Direct-Path Insert operations?

Options :

A : COLUMN STORE COMPRESS BASIC

B : COLUMN STORE COMPRESS ADVANCED

C : RON STORE COMPRESS BASIC

D : ROW STORE COMPRESS ADVANCED

Answer: C

Question 2

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

Options :

A : All tablespaces may have one or more data files

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

C : A smallfile tablespace might be bigger than a bigfile tablespace

D : A segment can span multiple data files in some tablespaces

E : A segment-s blocks can be of different sizes

F : A segment might have only one extent

G : Segments can span multiple tablespaces

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

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.

You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.

Examine this SQL statement:

Other-Image-40a5dd6cd-84d9-4396-b8cc-2b23c0f0e79e

Exhibit 1.

Other-Image-60a5dd6cd-84d9-4396-b8cc-2b23c0f0e79e

Exhibit 2.

Other-Image-80a5dd6cd-84d9-4396-b8cc-2b23c0f0e79e

What will be the result?

Options :

A : It gives an error because the ALL keyword is not valid

B : It gives an error because the GROUP BY clause is not valid

C : It executes successfully but does not give the required result

D : It executes successfully and gives the required result

Answer: D

Question 5

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

EXPERTY DESIGNED 1Z0-082 PRACTICE TEST