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.
 
Your Name Your Email-ID
Your Answer
87. What is direct apply?
  When the apply process applies the LCR directly at the target, it is called direct apply.
 
Your Name Your Email-ID
Your Answer
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.
 
Your Name Your Email-ID
Your Answer
89. Name two new features of Oracle 8?
  New features of Oracle 8 include partitioned tables, index only tables and improved parallelism.
 
Your Name Your Email-ID
Your Answer
90. What is a nested table?
  A nested table is a table that appears as a column in another table.
 
Your Name Your Email-ID
Your Answer
123456789101112131415


16171819202122 Page 18 of 22