Question 1

The sql statement "DESC emptable"

Options :

A : Is used to view the structure of the table emptable

B : Shows the user all the data in the table

C : Selects the number of rows in the table

D : None of the options are correct

Answer: A

Question 2

How do you rename file "new" as file "old"?

Options :

A : mv new old

B : rn new old

C : p new old

Answer: A

Question 3

The environment variable which is used to identify the oracle instance running in a UNIX machine is:

Options :

A : ORACLE_DB_NAME

B : ORACLE_HOME

C : ORACLE_SID

D : ORACLE_ID

Answer: C

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

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

Free TFINTCBSCIXM1001 Mock Exam – Practice Online Confidently