Oracle Apps DBA Upgrade and Migration MCQ
This Oracle Apps DBA Upgrade and Migration MCQ Quiz contains few questions as a free online practice test.
1. Installation of database software/Oracle Applications software during a version upgrade (like 10.7 to 11i or 11i to R12) can be
a) Installed well in advance
b) Need not be installed
c) Will get created while applying the maintenance pack
d) Copied from the existing instance
2. How to apply patch in Shared APPL_TOP
a) Apply all the node
b) Apply only primary node
c) Apply only secondary node
d) Apply NFS server
3. What is the significance of tums patch ?
a) Gives the list of interoperability patches that needs to be applied for upgrade
b) gives the confirmation about compatibility settings
c) examines your current configuration and creates a report detailing which of the tasks in these instructions you must complete and which ones you can ignore.
d) Signifies which application patches to be applied post go-live
4. How do you add a data file to a tablespace?
a) alter database add datafile
b) alter system add datafile
c) alter session add datafile
d) alter tablespace add datafile
