Questions and answers for exam Preparation

MCQs

Total Questions : 10

Question 1. What do the schema objects comprise of?

Table
Index
Cluster
All of the Mentioned

Discuss Question

Answer: Option D. -> All of the Mentioned

Question 2. You want to be warned automatically when more than 100 sessions are opened with your database instance.Identify the action that would help you achieve this.

Set the TRACE_ENABLED parameter to TRUE
Set the threshold for the Current Logons Count metric
Set the LOG_CHECKPOINT_TO_ALERT parameter to TRUE
Set the SESSIONS_PER_USER limit in the profiles used by users

Discuss Question

Answer: Option B. -> Set the threshold for the Current Logons Count metric

A metric is defined as the rate of change in some cumulative statistic. This rate can be measured against a variety of units, including time, transactions, or database calls. For example, the number database calls per second is a metric.

Question 3. Modification schema of oracle database in one level without affecting the schema in high level is called as _______

Data Migration
Data Isolation
Data Independence
Data Abstraction

Discuss Question

Answer: Option C. -> Data Independence

Data Independence means changing internal level does not affect conceptual level.

Question 4. Which operations can be performed using the Data Recovery Ad-visor?

Diagnosing data failure
It is a percentage of rows in which the statistics are collected incrementally for partitions
Presenting appropriate repair options
Generating reports for possible causes of failure

Discuss Question

Answer: Option A. -> Diagnosing data failure

The Data Recovery Ad-visor automatically diagnoses corruption or loss of persistent data on disk, determines the appropriate repair options, and executes repairs at the user's request. This reduces the complexity of recovery process, thereby reducing the Mean Time To Recover (MTTR).

Question 5. Which of the following segment is destroyed when the SQL statement is finished?

Data Segment
Object Segment
Temporary Segment
All of the Mentioned

Discuss Question

Answer: Option C. -> Temporary Segment

After each block is formatted/finished, the new index keys are put in a sort (temporary) segment.

Question 6. Which of the following statement is false ?

Any procedure can raise a error and return an user message and error number
Error number is ranging from 20000 to 20999 are reserved for user defined messages
Oracle checks Uniqueness of User defined errors
Raise_Application_error is used for raising an user defined error

Discuss Question

Answer: Option C. -> Oracle checks Uniqueness of User defined errors

The UNIQUE constraint uniquely identifies each record in a database table.The UNIQUE and PRIMARY KEY constraints both provide a guarantee for uniqueness for a column or set of columns.

Question 7. What is the use of an index?

Retrieve data more quickly and efficiently
Related data requires much less I/O overhead if accessed simultaneously
Simplify the user's perception of data access
All of the Mentioned

Discuss Question

Answer: Option A. -> Retrieve data more quickly and efficiently

Index is used for to perform the quick operation on the data.

Question 8. The ORDER BY clause can only be used in ___________

SELECT queries
INSERT queries
GROUP BY queries
HAVING queries

Discuss Question

Answer: Option A. -> SELECT queries

An ORDER BY clause allows you to specify the order in which rows appear in the result set.

Question 9. Which of the following object types below cannot be replicated?

Data
Trigger
View
Sequence

Discuss Question

Answer: Option D. -> Sequence

Use the CREATE SEQUENCE statement to create a sequence, which is a database object from which multiple users may generate unique integers. You can use sequences to automatically generate primary key values.

Question 10. What is the result of the following 'PAN'NULL'KAJ'?