Question 21 :
What are the factors causing the reparsing of SQL statements in SGA?
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?
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?
The related columns of the tables in a cluster are called the cluster key.
Question 24 :
Do a view contain data?
Views do not contain or store data.
Question 25 :
What is user Account in Oracle database?
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.