Question 1

Oracle commits the current transaction after every DDL statement.

Options :

A : True

B : False

Answer: A

Question 2

Which of the following is not a component of System Global Area (SGA)?

Options :

A : Data Buffer Cache

B : Index Cache

C : Redo Log Buffer

D : Shared SQL Pool

Answer: B

Question 3

It is not possible to write our own Shell as it is not a program dedicated to a particular user.

Options :

A : True

B : False

Answer: B

Question 4

"Select sol_desc from SOL where city_code like '?D' " gives

Options :

A : A list of city code where the city code ends with BAD

B : A list of sol_desc where the city code ends with BAD

C : A list of sol_desc where the city code ends with BAD and only one letter before BAD

D : A list of city code where city code starts with BAD

Answer: B

Question 5

How do you create a new directory called "finacle"?

Options :

A : crdir finacle

B : mkdir finacle

C : newdir finacle

D : All the options are correc

Answer: B