网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which is the correct description of a pinned buffer in the database buffer cache（）
A
The buffer is currently being accessed.
B
The buffer is empty and has not been used.
C
The contents of the buffer have changed and must be flushed to the disk by the DBWn process.
D
The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk.
参考答案
参考解析
解析：
Every buffer has an access mode:pinnedorfree(unpinned). A buffer is "pinned" in the cache so that it does not age out of memory while a user session accesses it. Multiple sessions cannot modify a pinned buffer at the same time.
更多 “单选题Which is the correct description of a pinned buffer in the database buffer cache（）A The buffer is currently being accessed.B The buffer is empty and has not been used.C The contents of the buffer have changed and must be flushed to the disk by the DBWn process. D The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk.” 相关考题
考题
An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache.How would you guarantee that the blocks for the table never age out?（）A. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.B. Increase the database buffer cache size.C. Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.D. Configure Automata Shared Memory Management.E. Configure Automatic Memory Management
考题
In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments.On further investigation, you find that buffer busy waits is caused by contention on data blocks.Which option would you consider first to decrease the wait event immediately?（）A. Decreasing PCTUSEDB. Decreasing PCTFREEC. Increasing the number of DBWN processD. Using Automatic Segment Space Management (ASSM)E. Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation
考题
Which statement describes queue and buffer managment in the E－series router?()
A. Buffer memory is managed dynamically in the I/O module.B. Buffer memory is managed dynamically in the switch fabric.C. Buffer memory is managed dynamically on egress line modules.D. Buffer memory is managed dynamically on ingress line modules
考题
Which item is the great majority of software vulnerabilities that have been discovered？（）A、Stack vulnerabilitiesB、Heap overflowsC、Software overflowsD、Buffer overflows
考题
Which of the following provides a logical grouping of database objects?（）A、ViewB、TableC、SchemaD、Buffer pool
考题
Which statement describes queue and buffer managment in the E-series router?（）A、Buffer memory is managed dynamically in the I/O module.B、Buffer memory is managed dynamically in the switch fabric.C、Buffer memory is managed dynamically on egress line modules.D、Buffer memory is managed dynamically on ingress line modules
考题
Which is the correct description of a pinned buffer in the database buffer cache（）A、The buffer is currently being accessed.B、The buffer is empty and has not been used.C、The contents of the buffer have changed and must be flushed to the disk by the DBWn process. D、The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk.
考题
You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（） A、Memory AdvisorB、Segment AdvisorC、SQL Tuning AdvisorD、SQL Access AdvisorE、Automatic Database Diagnostic Monitor （ADDM）
考题
You configured the large pool for Oracle backup and restore operations. As a result， which component would require less memory？（）A、 streams poolB、 shared poolC、 log bufferD、 keep buffer cacheE、 recycle buffer cache
考题
Automatic Shared Memory Management （ASMM） has been enabled for your database instance. Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL ALTER SYSTEM SET DB_CACHE_SIZE = 100M； Which statement is true in this scenario（）A、The minimum memory size for the database buffer cache is set to 100 mb.B、The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mbC、The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.D、The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb
考题
You work as a database administrator for Certkiller .com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated. What could be the reason for this problem？（）A、The advisory memory has been turned off.B、The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.C、The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.D、The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.E、The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.
考题
You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned？ （）A、 log bufferB、 Java poolC、 Large poolD、 Fixed SGAE、 Shared poolF、 Streams poolG、 Keep buffer cacheH、 Database buffer cache
考题
Records from the data dictionary information are stored in which of the following database memory areas?（）A、Library cache B、Row cache C、Session UGA D、Buffer cache
考题
In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?（）A、Decreasing PCTUSEDB、Decreasing PCTFREEC、Increasing the number of DBWN processD、Using Automatic Segment Space Management (ASSM)E、Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation
考题
Your database is using shared server configuration. Which optional memory structure would you configure to store the User Global Area （UGA） information and improve the shared pool performance？（）A、large poolB、streams poolC、keep buffer cacheD、recycle buffer cache
考题
Which one of the following parameters must be specified when exporting objects that has integrity constraints referencing objects that are currently being accessed by other users？（）A、IGNORE=YB、DIRECT=YC、CONSISTENT=YD、BUFFER=Y
考题
Which component of the SGA stores parsed SQL statements is used for process sharing?（）A、Buffer cache B、Redo log buffer C、Private SQL area D、Library cache E、Row cache
考题
单选题Your database is using shared server configuration. Which optional memory structure would you configure to store the User Global Area （UGA） information and improve the shared pool performance？（）A
large poolB
streams poolC
keep buffer cacheD
recycle buffer cache
考题
单选题You observe that a database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine that required size of the database buffer cache？ （）A
Memory AdvisorB
Segment AdvisorC
SQL Tuning AdvisorD
SQL Access AdvisorE
Automatic Database Diagnostic Monitor （ADDM）
考题
单选题You work as a database administrator for Supportcenter.cn. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated. What could be the reason for this problem？（）A
The advisory memory has been turned off.B
The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.C
The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.D
The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.E
The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.
考题
单选题You configured the large pool for Oracle backup and restore operations. As a result， which component would require less memory？（）A
streams poolB
shared poolC
log bufferD
keep buffer cacheE
recycle buffer cache
考题
单选题In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?（）A
Decreasing PCTUSEDB
Decreasing PCTFREEC
Increasing the number of DBWN processD
Using Automatic Segment Space Management (ASSM)E
Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation
考题
单选题Which is the correct description of a pinned buffer in the database buffer cache（）A
The buffer is currently being accessed.B
The buffer is empty and has not been used.C
The contents of the buffer have changed and must be flushed to the disk by the DBWn process. D
The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk.
考题
单选题Automatic Shared Memory Management （ASMM） has been enabled for your database instance. Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL ALTER SYSTEM SET DB_CACHE_SIZE = 100M； Which statement is true in this scenario（）A
The minimum memory size for the database buffer cache is set to 100 mb.B
The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mbC
The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.D
The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb
考题
单选题You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（）A
Memory AdvisorB
Segment AdvisorC
SQL Tuning AdvisorD
SQL Access AdvisorE
Automatic Database Diagnostic Monitor （ADDM）
考题
多选题You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned？ （）Alog bufferBJava poolCLarge poolDFixed SGAEShared poolFStreams poolGKeep buffer cacheHDatabase buffer cache
考题
单选题An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?（）A
Configure the KEEP buffer pool and alter the table with the corresponding storage clause.B
Increase the database buffer cache size.C
Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.D
Configure Automata Shared Memory Management.E
Configure Automatic Memory Management
热门标签
最新试卷