6.
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?
MAX_DUMP_FILE_SIZE = 1000
What effect will this setting have on user session trace files?
- A.No effect. MAX_DUMP_FILE_SIZE affects only background process trace files.
- B.Trace files will be limited to 1000 bytes.
- C.Trace files will be limited to 1000 kilobytes.
- D.Trace files will be limited to 1000 megabytes.
- E.Trace files will be limited to 1000 blocks.
- Answer & Explanation
- Report
Answer : [E]
Explanation :
Explanation :
| The default unit type for the MAX_DUMP_FILE_SIZE parameter is blocks. |
7.
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.)
(Choose all that apply.)
- A.The automatically sized components will have 6.5GB allocated among them.
- B.The total SGA size will be 9GB.
- C.The total SGA size will be 8GB.
- D.The JAVA_POOL_SIZE will never shrink below 1GB.
- E.The STREAMS_POOL_SIZE will always stay at 500MB.
- Answer & Explanation
- Report
Answer : [C,D,E]
Explanation :
Explanation :
| The SGA_TARGET parameter specifies total memory available for sizing the SGA. This includes both automatically sized and manually sized components. The Java pool is an automatically sized component, so its size is unknown, but it will never shrink below the size specified in the JAVA_POOL_SIZE parameter. The streams pool is a manually sized component, so it receives a static allocation of 500MB. |
8.
ASMM cannot be started on your instance. What might be the reason?
- A.The shared pool is sized larger than the database buffer cache size.
- B.The DB_KEEP_CACHE_SIZE parameter is not expressed as a power of 2.
- C.The STATISTICS_LEVEL parameter is set to BASIC.
- D.An invalid sizing parameter is specified.
- E.The ASMM option is not installed.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| ASMM is dependent on Oracle statistics and requires a STATISTICS_LEVEL of either TYPICAL or ALL. If the STATISTICS_LEVEL parameter is set to BASIC, ASMM will not function. |
9.
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?
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?
- A.peabody
- B.159.162.210.22
- C.159.162.211.44
- D.159.163.212.6
- E.None. Valid node checking is defined in the tnsnames.ora file.
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| Only option A is correct. Wildcards are not allowed in the tcp.invited_nodes parameter, so only exact matches will be allowed. |
10.
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?
ENVS="EXTPROC_DLLS=/lib/javalib.so:/lib/tlib.so"
Which of the following statements is true regarding external procedure requests handled by this listener?
- A.They can access procedures only in the /lib/javalib.so and /lib/tlib.so shared library files.
- B.They can access procedures in the /lib/javalib.so and /lib/tlib.so shared libraries, as well as in any external libraries referenced by these procedures.
- C.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.
- D.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. They can also access any external libraries referenced by these procedures.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The EXTPROC_DLLS environment variable limits the available shared libraries that the agent can access. Since the ONLY option is not included in the example, the specified libraries are available in addition to the default libraries (those in the $ORACLE_HOME/lib directory). |
|
|
||||||||||||||||||||||||||||
