Trend Nxt Oracle Apps DBA | Question and Answers

1. Who is responsible for managing concurrent programs
a) concurrent manager
b) Forms server
c) report server
d) application server
2. Which three statements are true about the Oracle Applications Context file?
a) It is written in XML format.
b) It describes the only database environment
c) It can be edited using Oracle Applications Manager
d) It can be used to synchronize multiple nodes”
3. Which ad utility is used to generate report files?
“a) adreport
b) adslice
c) adadmin
d) adimgr
4. Internally all applications connect to ————Schema for access
a) apps
b) sys
c) system
d) GL
5. 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
_______________________________________________________________________________________
1. The status code returned in the log files when the internal manager shuts down cleanly is
a) -1
b) 1
c) 131
d) 0
2. Which ad utility is used to generate report files?
“a) adreport
b) adslice
c) adadmin
d) adimgr
3. Internally all applications connect to ————Schema for access “a) apps
b) sys
c) system
d) GL
4. 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
5. Parallel workers in AD Administration,AutoPatch, and AutoUpgrade can be managed by using — utility
a) adpatch
b) adctrl
c) adadmin
d) adslice”
_________________________________________________________________________________________
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