Question 1

Examine the description of the employees table:

Other-Image-27be966aa-f1d1-485b-934c-16348004fe68

Which query requires explicit data type conversion?

Options :

A :

B :

C :

D :

Answer: A

Question 2

Which two statements are true about single row functions? (Choose two.)

Options :

A : MOD : returns the quotient of a division operation

B : FLOOR : returns the smallest integer greater than or equal to a specified number

C : TRUNC : can be used with NUMBER and DATE values

D : CONCAT : can be used to combine any number of values

E : CEIL : can be used for positive and negative numbers

Answer: A,C

Question 3

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 4

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 5

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

Free 1Z0-082 Mock Exam – Practice Online Confidently

Buying Options: