Question 1

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 2

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

Question 3

Examine the description of the employees table:

Which query requires explicit data type conversion?

Options :

A :

B :

C :

D :

Answer: A

Question 4

Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

Options :

A : If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS

B : Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ

C : Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO

D : Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

E : Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

Answer: 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