11g Architecture Options(Engineering > Computer Science And Engineering > Oracle Database ) Questions and Answers
Explanation:-
Answer: Option B. -> Set the threshold for the Current Logons Count metricA 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.
Explanation:-
Answer: Option A. -> Diagnosing data failureThe 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).
Explanation:-
Answer: Option C. -> Oracle checks Uniqueness of User defined errorsThe 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.
Explanation:-
Answer: Option D. -> SequenceUse 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.