Oracle Interview Questions and Answers
Question - 61 : - Can one rename a database user (schema)?
Answer - 61 : - No, this is listed as Enhancement Request 158508. Workaround:
Do a user-level export of user A
create new user B
Import system/manager fromuser=A touser=B
Drop user A
Question - 62 : - Define Transaction ?
Answer - 62 : - A Transaction is a logical unit of work that comprises one or more SQL statements executed by a single user.
Question - 63 : - What is Read-Only Transaction ?
Answer - 63 : - A Read-Only transaction ensures that the results of each query executed in the transaction are consistant with respect to the same point in time.
Question - 64 : - What is a deadlock ? Explain .
Answer - 64 : - Two processes wating to update the rows of a table which are locked by the other process then deadlock arises. In a database environment this will often happen because of not issuing proper row lock commands. Poor design of front-end application may cause this situation and the performance of server will reduce drastically.
These locks will be released automatically when a commit/rollback operation performed or any one of this processes being killed externally.
Question - 65 : - What is a Schema ?
Answer - 65 : - The set of objects owned by user account is called the schema.
Question - 66 : - What is a cluster Key ?
Answer - 66 : - The related columns of the tables are called the cluster key. The cluster key is indexed using a cluster index and its value is stored only once for multiple tables in the cluster.
Question - 67 : - What is Parallel Server ?
Answer - 67 : - Multiple instances accessing the same database (Only In Multi-CPU environments)
Question - 68 : - What are the basic element of Base configuration of an oracle Database ?
Answer - 68 : - It consists of
one or more data files.
one or more control files.
two or more redo log files.
The Database contains
multiple users/schemas
one or more rollback segments
one or more tablespaces
Data dictionary tables
User objects (table,indexes,views etc.,)
The server that access the database consists of
SGA (Database buffer, Dictionary Cache Buffers, Redo log buffers, Shared SQL pool)
SMON (System MONito)
PMON (Process MONitor)
LGWR (LoG Write)
DBWR (Data Base Write)
ARCH (ARCHiver)
CKPT (Check Point)
RECO
Dispatcher
User Process with associated PGS
Question - 69 : - What is clusters ?
Answer - 69 : - Group of tables physically stored together because they share common columns and are often used together is called Cluster.
Question - 70 : - What is an Index ? How it is implemented in Oracle Database ?
Answer - 70 : - An index is a database structure used by the server to have direct access of a row in a table. An index is automatically created when a unique of primary key constraint clause is specified in create table comman (Ver 7.0)