Question 1

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 2

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 3

"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 4

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 5

Data Definition Language allows which of the following tasks

Options :

A : Creation of database objects

B : Dropping of database objects

C : Alteration of a database objects

D : All the options are correct

Answer: D

Free TFINTCBSCIXM1001 Mock Exam – Practice Online Confidently