Your database instance has the following initialization parameter set:
MAX_DUMP_FILE_SIZE = 1000
What effect will this setting have on user session trace files?
No effect. MAX_DUMP_FILE_SIZE affects only background process trace files.
Trace files will be limited to 1000 bytes.
Trace files will be limited to 1000 kilobytes.
Trace files will be limited to 1000 megabytes.
Trace files will be limited to 1000 blocks.
The following initialization parameters reside in your initialization file:
SGA_TARGET=8G STREAMS_POOL_SIZE=500M JAVA_POOL_SIZE=1G SHARED_POOL_SIZE=3G
Which of the following statements will be true when your instance is started? (Choose all that apply.)
The automatically sized components will have 6.5GB allocated among them.
The total SGA size will be 9GB.
The total SGA size will be 8GB.
The JAVA_POOL_SIZE will never shrink below 1GB.
The STREAMS_POOL_SIZE will always stay at 500MB.
ASMM cannot be started on your instance. What might be the reason?
The shared pool is sized larger than the database buffer cache size.
The DB_KEEP_CACHE_SIZE parameter is not expressed as a power of 2.
The STATISTICS_LEVEL parameter is set to BASIC.
An invalid sizing parameter is specified.
The ASMM option is not installed.
You wish to limit database access to a select group of hosts. The following lines have been added to your sqlnet.ora file:
tcp.validnode_checking = yes tcp.invited_nodes = (peabody, 159.162.210.24, 159.162.211.*, 159.163.*.*)
From which of the following hosts will database requests be allowed?
peabody
159.162.210.22
159.162.211.44
159.163.212.6
None. Valid node checking is defined in the tnsnames.ora file.
Your external procedure agent is governed by the following listener setting:
ENVS="EXTPROC_DLLS=/lib/javalib.so:/lib/tlib.so"
Which of the following statements is true regarding external procedure requests handled by this listener?
They can access procedures only in the /lib/javalib.so and /lib/tlib.so shared library files.
They can access procedures in the /lib/javalib.so or /lib/tlib.so shared libraries, as well as in any libraries in the $ORACLE_HOME/lib directory.
You are working with Oracle Support to resolve a database issue. The support technician asks you to forward any diagnostic files that might help them resolve the issue. Which two of the following choices represent the best files to send?
Alert log
Trace files from the USER_DUMP_DEST directory
Trace files from the BACKGROUND_DUMP_DEST directory
Files from both the USER_DUMP_DEST directory and the BACKGROUND_DUMP_DEST directory
External procedure files
You notice that a lot of disk space is being used up on one of your mount points. Upon investigating, you find that SQL tracing is turned on for the instance. You issue an ALTER SYSTEM statement to turn it off. In an SPFILE environment, how can you determine if it was turned on at startup or if it was turned on using an ALTER SYSTEM statement? Select the best answer.
User process trace file
Alert log
System log
Background process trace file
init.ora file
Your instance does not have a value set for the PGA_AGGREGATE_TARGET initialization parameter. The server has 8GB of memory and the SGA is using 4GB. Which of the following statements is true regarding APMM for this instance?
It will not be enabled.
It will use the default size of 10MB.
It will always use the *_AREA_SIZE parameters.
It will use the default size of 800MB.
It will dynamically allocate unused SGA memory.
Your junior DBA accidentally deleted the alert log file. How do you ensure that Oracle will continue to function? Choose the best answer.
Restore the most recent backup.
Shut down the instance. A new file will be created on startup.
Create a new alert log file using EM Database Control.
Create a new alert log file using the ALTER SYSTEM statement.
Do nothing.
You execute a Java stored procedure consisting of a single SQL statement using a large hash-join operation and a large sort operation. Which memory structure will have the most impact on your performance?
Shared pool
Java pool
SQL work area
Private SQL area
Shared SQL area
The following initialization parameters are set on your database instance:
DB_NAME=LNX1 SQL_TRACE=FALSE BACKGROUND_DUMP_DEST=/data1/admin/lnx1/bdump USER_DUMP_DEST=/data1/admin/lnx1/udump TRACEFILE_IDENTIFIER='prod'
An archiver (ARCH) process encounters an error situation. Its process ID is 32123. Which of the following is true?
The trace file /data1/admin/lnx1/bdump/lnx1_arch_32123.trc will be created.
The trace file /data1/admin/lnx1/bdump/arch_lnx1_32123_prod.trc will be created.
The trace file /data1/admin/lnx1/udump/arch_lnx1_32123.trc will be created.
The trace file /data1/admin/lnx1/bdump/lnx1_arch_32123_prod.trc will be created.
No trace file will be created.
Which of the following could be found in the alert log? (Choose all that apply.)
Evidence of a brute force attack against the listener
External procedure executions
Tablespace creation events
Evidence of recovery operations
Initialization parameter values
You need to secure your listener. Which of the following is not a recommended security measure? (Choose the best answer.)
Enable Listener logging.
Remove unnecessary external procedure services.
Configure listener on a non-standard port.
Apply patches.
Block SQL*NET traffic on firewalls.
You want to set a password on the listener. Why might you want to use lsnrctl rather than manually editing the listener.ora file? (Select the best two answers.)
It is easier.
It will encrypt the password in the listener.ora file.
You don't have access to the operating system.
lsnrctl will log the event to the alert log.
The listener.ora file is stored in binary format.
Which of the following are not automatically sized components of ASMM?
Streams pool
Keep buffer cache
SQL work area
Recycle buffer cache
All of the above
Which of the following operations is not impacted by the size of the SQL work area? (Select the best answer.)
Index lookups
Sort operations
Bitmap merges
Bitmap creation
Bulk load operations
You want to change the password for your listener. The listener.ora file contains the following entries:
PASSWORDS_LISTENER=64F4692D9E6443F LOGGING_LISTENER=ON ADMIN_RESTRICTIONS=ON
Which of the following methods can you use to change the password?
lsnrctl
EM Database Control
Manually editing the listener.ora file
netmgr
netca
Dirty blocks in the database buffer cache are tracked by which component?
Dirty block list
Block list
LRU list
Write list
Dirty list
While performing routine management tasks on your database, you discover a high concentration of ORA-01169 messages in the listener log. What might be the cause?
Invalid setting in the sqlnet.ora file.
Mismatched parentheses in the listener.ora file.
Valid node checking has denied connection requests based on their host addresses.
A brute force password attack has been attempted.
The database is down.
The following parameters are set in your instance:
SGA_TARGET=3G HASH_AREA_SIZE=100M SORT_AREA_SIZE=100M WORKAREA_SIZE_POLICY=AUTO PGA_AGGREGATE_TARGET=600M
A user session executes a SQL statement that performs a large sort operation. What can be determined from these settings? (Select the best two answers.)
The operation will be allocated 100MB.
The operation will be allocated a minimum of 100MB.
The *_AREA_SIZE parameters will be ignored.
The *_AREA_SIZE parameters will not be ignored.
The amount of memory allocated is not known.