Set - 2

Question 21 :

What are the factors causing the reparsing of SQL statements in SGA?

Answer :

Due to insufficient shared pool size.
Monitor the ratio of the reloads takes place while executing SQL statements. If the ratio is greater than 1 then increase the SHARED_POOL_SIZE.

Question 22 :

What are clusters?

Answer :

Clusters are groups of one or more tables physically stores together to share common columns and are often used together.

Question 23 :

What is cluster key?

Answer :

The related columns of the tables in a cluster are called the cluster key.

Question 24 :

Do a view contain data?

Answer :

Views do not contain or store data.

Question 25 :

What is user Account in Oracle database?

Answer :

A user account is not a physical structure in database but it is having important relationship to the objects in the database and will be having certain privileges.