Oracle Dba Interview Question and Answers
86. |
What is an express configuration? |
|
Express configuration installs a fully configured single node system with either a fresh database or Vision Demo database. Only a few basic parameters such as database name, top level install directories and port settings needs to be specified in this and express configuring take care of installing Oracle Application without any user intervention. |
|
|
87. |
What is direct apply? |
|
When the apply process applies the LCR directly at the target, it is called direct apply. |
|
|
88. |
What is a listener process? |
|
- The listener or Transparent Network Substrate(TNS) listener is a server process that provides network connectivity to the Oracle database.
- The listener is configured to listen for connection requests on a specified port on the database server.
|
|
|
89. |
Name two new features of Oracle 8? |
|
New features of Oracle 8 include partitioned tables, index only tables and improved parallelism. |
|
|
90. |
What is a nested table? |
|
A nested table is a table that appears as a column in another table. |
|
|