网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which statement is true about the Manageability Monitor （MMON） background proces（）
A
It transfers statistics from memory to disk at regular intervals.
B
It coordinates the rebalance activity for disk groups when ASM is used.
C
It communicates with the Automatic Storage Management （ASM） instance on behalf of the databaseinstance.
D
It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which statement is true about the Manageability Monitor （MMON） background proces（）A It transfers statistics from memory to disk at regular intervals.B It coordinates the rebalance activity for disk groups when ASM is used.C It communicates with the Automatic Storage Management （ASM） instance on behalf of the databaseinstance.D It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.” 相关考题
考题
单选题You execute the following command toauditdatabase activities： SQLAUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）A
Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.B
Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.C
One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.D
One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.E
One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.
考题
单选题The instance abnormally terminates because of a power outage. Which statement is true about redo log filesduring instance recovery（）A
Inactive and current redo log files are required to accomplish recovery.B
Online and archived redo log files are required to accomplish instance recovery.C
All redo log entries after the last checkpoint are applied from redo log files to data files.D
All redo log entries recorded in the current redo log file until the checkpoint position are applied to data files
考题
多选题You execute this command to drop the ITEM table， which has the primary key referred in the ORDERS table：SQL DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about theeffect of the command（）ANo flashback is possible to bring back the ITEM table.BThe ORDERS table is dropped along with the ITEM table.CThe dependent referential integrity constraints in the ORDERS table are disabled.DThe dependent referential integrity constraints in the ORDERS table are removed.EThe table definition of the ITEM table and associated indexes are placed in the recycle bin
考题
单选题Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled（）A
It is the time period after which the undo data becomes obsolete.B
It is the time period after which the committed undo data would be transferred to a temporary tablespace.C
It is the minimum time period up to which the committed undo data would be retained if free undo space isavailable.D
It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
考题
单选题You execute the following command toauditdatabase activities： SQLAUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）A
Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.B
Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.C
One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.D
One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.E
One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.
考题
多选题Which two statements are true regarding the usage of the SQL*Loader utility（）AYou can load data into multiple tables during the same load session.BYou can load data from multiple files to a table during the same load session.CYou cannot perform selective data loading based on the values available in the records.DYou can use an export file generated by the EXPDP utility as an input data file to load the data.EYou can load data only if the input file is available on the disk and tape but not in a named pipes.
考题
多选题You executed the following command to create a tablespace called SALES_DATA： CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace （）AThe database automatically determines the extent-sizing policy for the tablespace.BThe segments are automatically shrunk when the contents are removed from them.CThe allocation of extents within the tablespace is managed through the dictionary tables.DThe space utilization description of the data blocks in segments is recorded inbitmapblocks.EThe space utilization description of the data blocks in segments is managed through free lists.MANUAL
考题
单选题You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）A
The online redo log files and archived redo log files are required to accomplish the recovery.B
The uncommitted transaction will be committed at the next startup of the database instance.C
The uncommitted transaction is rolled back automatically at the next opening of the database.D
The DBA has to perform the recovery on the database to recover the uncommitted transaction
考题
多选题Which two statements are true about setting the FAST_START_MTTR_TARGET initializationparameter to a nonzero value（）AThe MTTR advisor will be disabled.BAutomatic checkpoint tuning will be enabled.CThe value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.DThe time taken to recover the instance after the crash is always exactly the same as the value given forthe FAST_START_MTTR_TARGET initialization parameter.
考题
多选题You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario（）AYou must shut down the database instance to perform the backups.BYou must configure the Flash Recovery Area （FRA） for the database.CYou can perform complete database backups without closing the database.DAll the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
考题
单选题In your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What isthe impact of this setting（）A
Optimizer statistics are collected automatically.B
Only timed operating system （OS） statistics and plan execution statistics are collected.C
The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.D
Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.E
The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
热门标签
最新试卷