网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema. Which two statements are true regarding the outcome of this action？（）
A
All the related indexes and views are automatically dropped
B
The flashback drop feature can recover only the table structure
C
Only the related indexes are dropped whereas views are invalidated
D
The flashback drop feature can recover both the table structure and its data
参考答案
参考解析
解析：
暂无解析
更多 “多选题The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema. Which two statements are true regarding the outcome of this action？（）AAll the related indexes and views are automatically droppedBThe flashback drop feature can recover only the table structureCOnly the related indexes are dropped whereas views are invalidatedDThe flashback drop feature can recover both the table structure and its data” 相关考题
考题
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()
A. Set MEMORY_TARGET to zeroB. Set the STATISTICS_LEVEL parameter to BASICC. Set the WORKAREA_SIZE_POLICY parameter to MANUALD. Set the PGA_AGGREGATE_TARGET parameter to nonzero value
考题
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?()
A. All the related indexes and views are automatically droppedB. The flashback drop feature can recover only the table structureC. Only the related indexes are dropped whereas views are invalidatedD. The flashback drop feature can recover both the table structure and its data
考题
You have the following requirements in relation to the detection of block corruption for your database instance:1. Check for logical self-consistency of data blocks when modified in memory.2. Checksums are calculated before and after the block change.3. Checks are performed for the lost writes to the physical standby database.Which method would help you perform the above checks automatically? （）A. Set the DB_SECUREFILE parameter to PERMITTEDB. Set the DB_ULTRA_SAFE parameter to DATA_ONLYC. Set the DB_LOCK_CHECKSUM parameter to TYPICALD. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL
考题
Which statement about Automatic Memory Management with Oracle 11g is true?()
A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.B. Oracle can reallocate memory between the SGA and PGA automatically as needed.C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
考题
Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.)You restart the instance.To what value will the MEMORY_MAX_TARGET parameter be set by default?()
A.120MB.320MC.480MD.600M
考题
View the Exhibit to examine the parameter values.You are planning to set the value for the MEMORY_TARGET parameter of your database instance.What value would you recommend?()
A. 90 MBB. 272 MBC. 362 MBD. 1,440 MB
考题
You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this？（）A、Use the Database Resource Manager.B、Set the limits in the profiles used by users.C、Modify the SESSIONS initialization parameter.D、Set the warning threshold for the Current Logons Count metric.
考题
You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）A、 Open the database in read-only mode.B、 Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.C、 Enable the block change tracking feature.D、 Execute the ALTER DATABASE FLASHBACK ON statement.
考题
Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH; What would be the outcome of this command？（）A、The command would return an error because LOG_BUFFER is a static parameter.B、The parameter value would be changed and it would come into effect immediately.C、You need to restart the database so that parameter changes can come into effect.D、The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
考题
You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.D、 Increase the value of the SGA_TARGET initialization parameter.
考题
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）A、Restore and recover the datafile. B、Restore and recover the tablespace. C、Restore and recover the database. D、Restore and recover the control file. E、Restore and recover the parameter file.
考题
You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals： SQL EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’，’SALES’，GRANULARITY=’GLOBAL’）； You need statistics to be collected more quickly. What can you do to achieve this？（）A、 Set DYNAMIC_SAMPLING to level 4B、 Set the STATISTICS_LEVEL parameter to BASICC、 Set the INCREMENTAL value to TRUE for the partition tableD、 Increase the value of STALE_PERCENT for the partition table
考题
You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）A、Set the UNDO_RETENTION parameter to AUTO.B、Create an initial undo segment in undotablespace.C、Set the UNDO_RETENTION parameter to 900 or moreD、Set the initialization parameter UNDO_MANAGEMENT to AUTOE、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace
考题
The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema. Which two statements are true regarding the outcome of this action？（）A、 All the related indexes and views are automatically droppedB、 The flashback drop feature can recover only the table structureC、 Only the related indexes are dropped whereas views are invalidatedD、 The flashback drop feature can recover both the table structure and its data
考题
You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace， UNDO_TBS1， in your database. Which two additional steps would you perform to achieve this？（）A、Set the UNDO_RETENTION parameter to 900 or more.B、Create an initial undo segment in the undo tablespace.C、Enable the retention guarantee for the undo tablespace.D、Set the UNDO_TABLESPACE parameter to UNDO_TBS1.E、Set the UNDO_MANAGEMENT initialization parameter to AUTO.
考题
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this？（）A、 Set MEMORY_TARGET to zeroB、 Set the STATISTICS_LEVEL parameter to BASICC、 Set the WORKAREA_SIZE_POLICY parameter to MANUALD、 Set the PGA_AGGREGATE_TARGET parameter to nonzero value
考题
You configured automatic archive logging for the database. On the next startup the database runs for a while， but then hangs. After checking the alert log， you determine that all the online redo logs need archiving. Which step was skipped when you set up automatic archive log？（）A、LOG_ARCHIVE_DEST was not set in the parameter file.B、LOG_ARCHIVE_START was not set in the parameter file.C、alter database archivelog； was not executed in MOUNT mode.D、LOG_ARCHIVE_MAX processes were not set in the parameter file.
考题
单选题You configured automatic archive logging for the database. On the next startup the database runs for a while， but then hangs. After checking the alert log， you determine that all the online redo logs need archiving. Which step was skipped when you set up automatic archive log？（）A
LOG_ARCHIVE_DEST was not set in the parameter file.B
LOG_ARCHIVE_START was not set in the parameter file.C
alter database archivelog； was not executed in MOUNT mode.D
LOG_ARCHIVE_MAX processes were not set in the parameter file.
考题
单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）A
Set MEMORY_TARGET to zeroB
Set the STATISTICS_LEVEL parameter to BASICC
Set the WORKAREA_SIZE_POLICY parameter to MANUALD
Set the PGA_AGGREGATE_TARGET parameter to nonzero value
考题
单选题Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance. To what value will the MEMORY_MAX_TARGET parameter be set by default?（）A
120MB
320MC
480MD
600M
考题
单选题You want to drop the TBS1 tablespace from your database. You also want to delete the corresponding data files automatically， and not have to do it manually. What should you do？（）A
Use the DROP DATAFILE command.B
Use the DROP TABLESPACE command.C
Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.D
Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.
考题
单选题You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）A
Increase the value of the FAST_START_MTTR_TARGET initialization parameter.B
Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.C
Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.D
Increase the value of the SGA_TARGET initialization parameter.
考题
单选题In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB DB_CACHE_SIZE = 1GB SHARED_POOL_SIZE = 3GB STATISTICS_LEVEL = BASIC PGA_AGGREGATE_TARGET = 0 You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）A
The STATISTICS_LEVEL initialization parameter is set to BASICB
The PGA_AGGREGATE_TARGET initialization parameter is set to zero.C
The SGA_MAX_SIZE initialization parameter is set to less than 20 GBD
The DB_CACHE_SIZE initialization parameter is set to less than 5 GBE
The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.
考题
单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this？（）A
Set MEMORY_TARGET to zeroB
Set the STATISTICS_LEVEL parameter to BASICC
Set the WORKAREA_SIZE_POLICY parameter to MANUALD
Set the PGA_AGGREGATE_TARGET parameter to nonzero value
考题
单选题You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）A
Restore and recover the datafile. B
Restore and recover the tablespace. C
Restore and recover the database. D
Restore and recover the control file. E
Restore and recover the parameter file.
考题
单选题You have the following requirements in relation to the detection of block corruption for your database instance： Check for logical self-consistency of data blocks when modified in memory. Checksums are calculated before and after the block change. Checks are performed for the lost writes to the physical standby database. Which method would help you perform the above checks automatically？（）A
Set the DB_SECUREFILE parameter to PERMITTEDB
Set the DB_ULTRA_SAFE parameter to DATA_ONLYC
Set the DB_LOCK_CHECKSUM parameter to TYPICALD
Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL
考题
单选题Which statement about Automatic Memory Management with Oracle 11g is true？（）A
You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.B
Oracle can reallocate memory between the SGA and PGA automatically as needed.C
To use Automatic Memory Management， you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.D
You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
热门标签
最新试卷