Question 1

___________ is a database object that allows the creation of a customised slice of a table or a collection of tables

Options :

A : Views

B : Indexes

C : Synonyms

D : Aliases

Answer: A

Question 2

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

Question 3

The command "ls -l|tail +5" displays

Options :

A : The last five lines of the listing

B : From the fifth line to the end of the listing.

C : The first five lines of the listing.

D : None of the options are correct

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

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