14.7. Review Questions

  1. 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?

    1. No effect. MAX_DUMP_FILE_SIZE affects only background process trace files.

    2. Trace files will be limited to 1000 bytes.

    3. Trace files will be limited to 1000 kilobytes.

    4. Trace files will be limited to 1000 megabytes.

    5. Trace files will be limited to 1000 blocks.

  2. 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.)

    1. The automatically sized components will have 6.5GB allocated among them.

    2. The total SGA size will be 9GB.

    3. The total SGA size will be 8GB.

    4. The JAVA_POOL_SIZE will never shrink below 1GB.

    5. The STREAMS_POOL_SIZE will always stay at 500MB.

  3. ASMM cannot be started on your instance. What might be the reason?

    1. The shared pool is sized larger than the database buffer cache size.

    2. The DB_KEEP_CACHE_SIZE parameter is not expressed as a power of 2.

    3. The STATISTICS_LEVEL parameter is set to BASIC.

    4. An invalid sizing parameter is specified.

    5. The ASMM option is not installed.

  4. 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?

    1. peabody

    2. 159.162.210.22

    3. 159.162.211.44

    4. 159.163.212.6

    5. None. Valid node checking is defined in the tnsnames.ora file.

  5. 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?

    1. They can access procedures only in the /lib/javalib.so and /lib/tlib.so shared library files.

    2. 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.

    3. 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.

    4. 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.

  6. 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?

    1. Alert log

    2. Trace files from the USER_DUMP_DEST directory

    3. Trace files from the BACKGROUND_DUMP_DEST directory

    4. Files from both the USER_DUMP_DEST directory and the BACKGROUND_DUMP_DEST directory

    5. External procedure files

  7. 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.

    1. User process trace file

    2. Alert log

    3. System log

    4. Background process trace file

    5. init.ora file

  8. 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?

    1. It will not be enabled.

    2. It will use the default size of 10MB.

    3. It will always use the *_AREA_SIZE parameters.

    4. It will use the default size of 800MB.

    5. It will dynamically allocate unused SGA memory.

  9. Your junior DBA accidentally deleted the alert log file. How do you ensure that Oracle will continue to function? Choose the best answer.

    1. Restore the most recent backup.

    2. Shut down the instance. A new file will be created on startup.

    3. Create a new alert log file using EM Database Control.

    4. Create a new alert log file using the ALTER SYSTEM statement.

    5. Do nothing.

  10. 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?

    1. Shared pool

    2. Java pool

    3. SQL work area

    4. Private SQL area

    5. Shared SQL area

  11. 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?

    1. The trace file /data1/admin/lnx1/bdump/lnx1_arch_32123.trc will be created.

    2. The trace file /data1/admin/lnx1/bdump/arch_lnx1_32123_prod.trc will be created.

    3. The trace file /data1/admin/lnx1/udump/arch_lnx1_32123.trc will be created.

    4. The trace file /data1/admin/lnx1/bdump/lnx1_arch_32123_prod.trc will be created.

    5. No trace file will be created.

  12. Which of the following could be found in the alert log? (Choose all that apply.)

    1. Evidence of a brute force attack against the listener

    2. External procedure executions

    3. Tablespace creation events

    4. Evidence of recovery operations

    5. Initialization parameter values

  13. You need to secure your listener. Which of the following is not a recommended security measure? (Choose the best answer.)

    1. Enable Listener logging.

    2. Remove unnecessary external procedure services.

    3. Configure listener on a non-standard port.

    4. Apply patches.

    5. Block SQL*NET traffic on firewalls.

  14. 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.)

    1. It is easier.

    2. It will encrypt the password in the listener.ora file.

    3. You don't have access to the operating system.

    4. lsnrctl will log the event to the alert log.

    5. The listener.ora file is stored in binary format.

  15. Which of the following are not automatically sized components of ASMM?

    1. Streams pool

    2. Keep buffer cache

    3. SQL work area

    4. Recycle buffer cache

    5. All of the above

  16. Which of the following operations is not impacted by the size of the SQL work area? (Select the best answer.)

    1. Index lookups

    2. Sort operations

    3. Bitmap merges

    4. Bitmap creation

    5. Bulk load operations

  17. 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?

    1. lsnrctl

    2. EM Database Control

    3. Manually editing the listener.ora file

    4. netmgr

    5. netca

  18. Dirty blocks in the database buffer cache are tracked by which component?

    1. Dirty block list

    2. Block list

    3. LRU list

    4. Write list

    5. Dirty list

  19. 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?

    1. Invalid setting in the sqlnet.ora file.

    2. Mismatched parentheses in the listener.ora file.

    3. Valid node checking has denied connection requests based on their host addresses.

    4. A brute force password attack has been attempted.

    5. The database is down.

  20. 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.)

    1. The operation will be allocated 100MB.

    2. The operation will be allocated a minimum of 100MB.

    3. The *_AREA_SIZE parameters will be ignored.

    4. The *_AREA_SIZE parameters will not be ignored.

    5. The amount of memory allocated is not known.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset