Online 1Z0-082 Practice Test

Question 1

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 2

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 3

Which two actions can you perform using DBCA for an existing database?

Options :

A : Create a template that can be used to clone the database.

B : Change the server mode from dedicated to shared, and vice versa.

C : Change the character set.

D : Create an additional listener.

E : Create nonstandard block size tablespaces.

Answer: B,C

Question 4

Examine the description of the employees table:

Which query requires explicit data type conversion?

Options :

A :

B :

C :

D :

Answer: A

Question 5

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

EXPERTY DESIGNED 1Z0-082 PRACTICE TEST