1.
Your database is set in ARCHIVELOG mode. Which parameter must you configure if you want to define seven archive log destinations?
LOG_ARCHIVE_MAX_PROCESSES LOG _ARCHIVE_DEST_n LOG_ARCHIVE_FORMAT LOG_ARCHIVE_START
Answer : 2 2.
Which background process is usually sufficient to clean up after a user process failure?
PMON DBWn SMON LGWR
Answer : 1 3.
In Oracle9i, which are characteristics of Oracle Net Services? (Choose all that apply.)
Supports only TCP/IP Supports TCP/IP, IBM LU6.2, and DECnet Support for configuration and administrative methods that require a centralized configuration utility Supports IPX/SPX Transparent data conversion between diverse operating systems
Answer : 2,5 4.
You are considering using RMAN as part of your Oracle backup strategy. Which of the following does Oracle suggest that you resolve before making this decision? (Choose all that apply.)
Which users will be performing privileged operations. Which user will be granted the SYSOPER privilege to start up and shut down the database. Where the privileges will be granted. Whether the files will be backed up with operating system commands.
What privileges will be needed. How much shared memory will be required.
Answer : 1,3,5,6 5.
You are working in an Oracle Shared Server environment. You want to find out the maximum number of servers that have started. Which data dictionary view will provide you with this information?
V$SHARED_SERVER V$SHARED_SERVER_MONITOR V$QUEUE V$DISPATCHER
Answer : 2 6.
Which statements are true about a Web client connection when no mid-tier server is involved? (Choose all that apply.)
The Oracle Net Foundation layer is required on both the client and server. The server must support HTTP or IIOP. Neither the client or server requires the Oracle Net Foundation layer. The server requires the Oracle Net Foundation layer. A Web Application server is required.
Answer : 2,3 7.
Which Oracle background process is responsible for synchronizing the current Redo Log with the control files and data files headers?
DBWn PMON ARCn SMON CKPT LGWR
Answer : 5 8.
As part of your RMAN backup strategy, you want to backup your database to a tape storage device. Which RMAN component enables you to do this?
Server Sessions OEM Channel Repository MML
Answer : 5 9.
Which of the following is a requirement of the Oracle Shared Server architecture if the user process exists on the same computer as an Oracle instance?
The one-to-one ratio of server process to user process must be configured. Oracle Advanced Security must be configured. Multiple request queues need to be configured. Oracle Net Services must be configured. A common response queue must be configured for all dispatchers.
Answer : 4 10. Which command would an Oracle9i DBA execute at a Windows command prompt if she wanted to display the Listener trace level?
lsnrctl echo trc_level lsnrctl show trc_level lsnrctl set trc_level lsnrctl display trc_level
Answer : 2 11. Which background process is usually sufficient to clean up after a user process failure?
DBWn LGWR SMON PMON
Answer : 4 12. Which statements are true about a Web client connection when no mid-tier server is involved? (Choose all that apply.)
The server requires the Oracle Net Foundation layer. A Web Application server is required. The Oracle Net Foundation layer is required on both the client and server. Neither the client or server requires the Oracle Net Foundation layer. The server must support HTTP or IIOP.
Answer : 4,5 13. Which of the following is a requirement of the Oracle Shared Server architecture if the user process exists on the same computer as an Oracle instance?
Oracle Net Services must be configured. Multiple request queues need to be configured. The one-to-one ratio of server process to user process must be configured. Oracle Advanced Security must be configured. A common response queue must be configured for all dispatchers.
Answer : 1 14. Which command would an Oracle9i DBA execute at a Windows command prompt if she wanted to display the Listener trace level?
lsnrctl echo trc_level lsnrctl show trc_level lsnrctl display trc_level lsnrctl set trc_level
Answer : 2 15. Your database is set in ARCHIVELOG mode. Which parameter must you configure if you want to define seven archive log destinations?
LOG_ARCHIVE_MAX_PROCESSES LOG_ARCHIVE_START LOG _ARCHIVE_DEST_n LOG_ARCHIVE_FORMAT
Answer : 3 16. You are considering using RMAN as part of your Oracle backup strategy. Which of the following does Oracle suggest that you resolve before making this decision? (Choose all that apply.)
Which users will be performing privileged operations. Which user will be granted the SYSOPER privilege to start up and shut down the database. What privileges will be needed. How much shared memory will be required. Where the privileges will be granted. Whether the files will be backed up with operating system commands.
Answer : 1,3,4,5 17. As part of your RMAN backup strategy, you want to backup your database to a tape storage device. Which RMAN component enables you to do this?
MML OEM Channel Server Sessions Repository
Answer : 1 18. Which Oracle background process is responsible for synchronizing the current Redo Log with the control files and data files headers?
SMON CKPT ARCn LGWR DBWn PMON
Answer : 2 19. You are working in an Oracle Shared Server environment. You want to find out the maximum number of servers that have started. Which data dictionary view will provide you with this information?
V$DISPATCHER V$SHARED_SERVER_MONITOR V$QUEUE V$SHARED_SERVER
Answer : 2