Oracle Apps DBA MCQ Quiz – Part 3

Oracle Apps DBA MCQ

This Oracle Apps DBA MCQ Quiz contains few questions as a online practice test.

1. For a Middle-Tier installation on a host without any existing Oracle products installed, what functions does the orainstRoot.sh script perform?

a) Creates the scripts dbhome, oraenv and coraenv
b) Creates the /etc/oratab file
c) Grants permissions on the inventory directory to all users in the oinstall group and creates /etc/oraInst.loc to point to the inventory directory
d) Creates the /etc/oracle directory

2. Internally all applications connect to ————Schema for access

a) apps
b) sys
c) system
d) GL

3. As a part of cloning process, the Applications DBA needs to copy the Database Tier File system to
the target system. Which step is NOT a part of this cloning phase?

a) Log on to the source system application tier
b) Perform a normal shutdown of the source system
c) Copy the database files from the source to the destination
d) Copy the source <806 ORACLE_HOME> and <RDBMS ORACLE_HOME> directory to the target
system

4. APPLICATION_SERVER_ID is related to column value of which table

a) v$database
b) FND_CONCURRRENT_REQUESTS
c) FND_NODES
d) FND_PROFILES