Explore topic-wise InterviewSolutions in .

Right choice is (b) SET the threshold for the Current Logons Count metric

Explanation: 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.

The correct OPTION is (a) Diagnosing data failure

Explanation: 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).

Right ANSWER is (a) The database can have more than one UNDO tablespaces

Explanation: ORACLE provides an automatic undo MANAGEMENT, for managing undo information and space. With automatic undo management, the database MANAGES undo segments in an undo table-space.

Right choice is (a) $$dbtime$$

The EXPLANATION is: The DB time Oracle METRIC is the amount of elapsed time (in microseconds) SPENT performing Database user-level CALLS.

Right OPTION is (c) One SERVER process – One user process

The best explanation: Single-process Oracle is a database system in which all Oracle code is EXECUTED by one process. Different processes are not used to separate execution of the parts of Oracle and the client APPLICATION program. Instead, all code of Oracle and the single user’s database application is executed by a single process.

The correct choice is (c) Oracle checks Uniqueness of User defined errors

To ELABORATE: 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.

The correct CHOICE is (a) SQL * FORMS is a 4GL tool for developing and executing Oracle based interactive based APPLICATION

For EXPLANATION I would say: SQL*Forms is a general-purpose tool for developing and executing forms-based interactive applications. The design component of this tool is specially designed for application developers and PROGRAMMERS.

The correct choice is (d) USER_EXIT

To explain I would say: A user exit is a C subroutine and called by ORACLE Forms to do special-purpose processing.It can DISPLAY messages on the Oracle Forms status line, GET and set field VALUES, do high-speed computations and table look-ups, and manipulate Oracle DATA.

The correct answer is (a) Navigational Trigger

The best I can explain: Pre- and POST- triggers FIRE as Form Builder navigates INTERNALLY through DIFFERENT levels of the object hierarchy.When-New-Instance triggers fire at the end of a navigational sequence that places the input focus in a different item.

Right CHOICE is (a) Dynamic Link Library

To elaborate: DLL, linking occurs at RUN TIME when the routine is actually used. This RESULTS in much smaller executable because routines are pulled in only as needed.

Right choice is (d) UNDO DATA

The best I can explain: Before transaction happen the ORACLE kept the files in Undo Data to overcome form any FAILURE.

Right answer is (a) PARAMETER FILE

To ELABORATE: A parameter file is a file that contains a list of initialization parameters and a VALUE for each parameter.

Right OPTION is (a) SELECT queries

The explanation is: An ORDER BY clause ALLOWS you to SPECIFY the order in which rows appear in the RESULT set.

Correct OPTION is (a) Performs crash recovery when a FAILED INSTANCE starts up again

The best explanation: SMON process of one instance can perform instance recovery for a failed CPU or instance.

Right ANSWER is (B) By using ALTER SYSTEM SWITCH LOGFILE

Explanation: To force a LOG switch, you must have the ALTER SYSTEM privilege. Use the ALTER SYSTEM statement with the SWITCH LOGFILE CLAUSE.

Correct option is (d) SEQUENCE

To elaborate: 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.

Right OPTION is (d) Cluster

The explanation is: Cluster is a schema object that CONTAINS DATA from one or more tables, all of which have one or more COLUMNS in COMMON.

Correct option is (b) Tablespace

Easy EXPLANATION: Oracle database consists of ONE or more logical STORAGE UNITS CALLED tablespaces.

Correct CHOICE is (c) Data Independence

Easiest explanation: Data Independence MEANS changing internal LEVEL does not AFFECT CONCEPTUAL level.

The correct OPTION is (b) Logical SCHEMA

To explain I WOULD say: Logical schema model may have many-to-many relationships and also have OBJECTS like table, view, procedure etc.

Right answer is (c) Logical and PHYSICAL SCHEMA

The BEST explanation: ORACLE DATABASES has two schema level logical and physical.

The correct option is (a) Instance of Database

The BEST I can explain: Oracle work on the instance BASIS, whatever the operation related to Oracle is only on instance LEVEL.

The CORRECT ANSWER is (c) Database Schema

Easiest explanation: Oracle database’s design is DONE on the schema LEVEL.

Right CHOICE is (c) DATA SEGMENT

For explanation I would say: Oracle has 4 type of data segment :1)data segments 2)index segments 3)ROLLBACK segments 4)temporary segments.

Correct answer is (c) Data DICTIONARY

To explain I would say: The data dictionary is structured in tables and VIEWS, just LIKE other DATABASE data. All the data dictionary tables and views for a given database are stored in that database’s SYSTEM tablespace.

The CORRECT answer is (d) All of the Mentioned

For EXPLANATION: Oracle ARCHITECTURE consists of DB process, Table space, Datafiles.

The correct answer is (a) RETRIEVE data more quickly and efficiently

To EXPLAIN I would say: Index is USED for to perform the QUICK operation on the data.

Right CHOICE is (c) TEMPORARY Segment

The explanation is: After each block is formatted/finished, the NEW INDEX keys are PUT in a sort (temporary) segment.

The CORRECT option is (a) Oracle background PROCESSES

To elaborate: Oracle creates a set of background processes for an instance to manage MEMORY structure, asynchronously PERFORM I/O to write data to DISK, and do general maintenance tasks.

Correct choice is (b) USED to store shared SQL

Best EXPLANATION: Oracle Library cache is like a DATA buffer cache, except that it is not for data, but a cache for SQL PL/SQL PROGRAMS and Java classes.