You&ensp;create&ensp;an&ensp;Oracle&en...

单项选择题 You create an Oracle 10g database and configure the SPFILE as follows：
SGA_TARGET=2G
DB_CACHE_SIZE=512M LOG_BUFFER=50M
DB_KEEP_CACHE_SIZE=128M
You modify the SGA_TARGET initialization parameter using the following statement：
SQL>ALTER SYSTEM SET SGA_TARGET = 1G SCOPE = BOTH；
Which entity does this statement affect？（）

A. only the auto-tuned memory components
B. only the memory components that are not auto-tuned
C. both the auto-tuned memory components and the non-auto-tuned memory components
D. neither the auto-tuned memory components nor the non-auto-tuned memory components

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题 The SPFILE for your database contains the following parameter settings：
SGA_TARGET = 1000M
DB_CACHE_SIZE = 512M
SHARED_POOL_SIZE = 128M
LOG_BUFFER = 10M
DB_8K_CACHE_SIZE = 50M
What is the total memory that can be distributed across the auto-tuned memory components？（）

A. 940M
B. 990M
C. 690M
D. 1000M

点击查看答案

2.多项选择题The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）

A. LOG_BUFFER
B. DB_CACHE_SIZE
C. JAVA_POOL_SIZE
D. LARGE_POOL_SIZE
E. SHARED_POOL_SIZE
F. STREAMS_POOL_SIZE

点击查看答案

3.单项选择题 The warning level threshold value for a tablespace， DATA1， is set to 60% and the critical level threshold value is set to 80%. The tablespace， DATA1， is infrequently used and is not a part of the production environment. You issued the following command：
SQL> EXECUTE
DBMS_SERVER_ALERT.SET_THRESHOLD
（dbms_server_alert.tablespace_pct_full，
dbms_server_alert.operator_ge，80，
dbms_server_alert.operator_ge，90，
1，1，NULL，
dbms_server_alert.object_type_tablespace，’DATA’）；
What will be the result of the command？（）

A. The command will be executed successfully only if the tablespace DATA1 is a dictionary-managed tablespace.
B. The total numbers of alerts that you receive every day will be reduced.
C. The total number of alerts that you receive every day will be increased.
D. No more data will be added to the DATA1 tablespace if 80% of the space allocated to the DATA1 tablespace is used.

点击查看答案

4.单项选择题A junior level Database Administrator erroneously deleted the database alert log while users were accessing the database. Which action should you take to recover the alert log？（）

A. Do nothing.
B. Restart the database.
C. Perform recovery on the database.
D. Restore the alert log from the last backup.

点击查看答案

5.单项选择题You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting？（）

A. The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory.
B. The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory.
C. The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory.
D. The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.

点击查看答案

6.单项选择题You are maintaining an OLTP database in Oracle10g. You set the value of the LOG_ARCHIVE_TRACE parameter to zero. What is the impact of this setting？（）

A. The trace files will be disabled only for a specific session.
B. Tracing will be disabled for a client identifier.
C. Tracing will be disabled only for the ARCn process.
D. The SQL Trace facility will be disabled for the instance.

点击查看答案

7.单项选择题You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process. Which action will enable you to disable the trace files generated by the ARCn background process？（）

A. Remove the LOG_ARCHIVE_DEST parameter from the init.ora file.
B. Set the value of the SQL_TRACE parameter to FALSE in the init.ora file.
C. Use the DBMS_MONITOR.SESSION_TRACE_DISABLE procedure.
D. Set the value of the LOG_ARCHIVE_TRACE initialization parameter to zero.

点击查看答案

8.单项选择题 You have created a locally managed tablespace by issuing the following command：
CREATE TABLESPACE data1
DATAFILE ’data1_file1.dbf’ SIZE 10M AUTOEXTEND ON MAXSIZE
UNLIMITED；
For the DATA1 tablespace， you have set the warning level alert limit to 70 percent. In which situation will a warning level alert be generated？（）

A. when 700 KB is used
B. when 700 KB is left as free space
C. when 7MB is used
D. when 7MB is left as free space
E. no alert will be generated because an autoextensible datafile is included in the tablespace

点击查看答案

9.单项选择题 Matthew has recently joined NetFx Corporation as a junior-level Database Administrator （DBA）. He is asked by his supervisor to verify the database for data block corruptions. He uses the DBVERIFY utility and finds that two data blocks are corrupted in the database.
What should Matthew use to identify the corrupted blocks as well as datafiles containing these blocks？（）

A. datafile
B. alert log
C. dynamic views
D. control file script

点击查看答案

10.单项选择题While performing monitoring and tuning the database， you want to view the summarized information about the warning level alerts and critical level alerts. Which section of the Oracle Enterprise manager displays the summarized information about the warning and critical level alerts？（）

A.General
B. High Availability
C. Space Usage
D. Diagnostic Summary

点击查看答案