网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You execute the following command to audit the database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command？（）
A
One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
B
One audit record is created for every session when any user successfully drops a table owned by SCOTT.
C
One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
D
One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
E
One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.
参考答案
参考解析
解析：
暂无解析
更多 “单选题You execute the following command to audit the database activities： SQL AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command？（）A One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.B One audit record is created for every session when any user successfully drops a table owned by SCOTT.C One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.D One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.E One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.” 相关考题
考题
单选题You are working on the Certkiller database. What is the default name of the alert log file in this database？（）A
alert_ Certkiller .logB
alertlog_ Certkiller .logC
alert_log_ Certkiller .logD
Certkiller _alert_log.logE
log_alert_： Certkiller .logF
trace_alert_ Certkiller .log
考题
单选题You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）A
Configure Java Pool to cache the java objects.B
Configure Streams Pool to enable parallel processing.C
Increase Shared Pool size to cache more PL/SQL objects.D
Increase Database Buffer Cache size to increase cache hits.E
Configure Large Pool to be used by RMAN and shared server.F
Increase the total System Global Area （SGA） size to increase memory hits.
考题
多选题Data files of which three tablespaces can be recovered by performing an openrecovery？（）ATEMPBUNDOCINDEXDSYSAUXESYSTEM
考题
单选题You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）A
The backup status will be marked expired in RMAN recovery catalog.B
The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.C
The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery cataloglD
The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.E
The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.
考题
单选题You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）A
Configure Java Pool to cache the java objects.B
Configure Streams Pool to enable parallel processing.C
Increase Shared Pool size to cache more PL/SQL objects.D
Increase Database Buffer Cache size to increase cache hits.E
Configure Large Pool to be used by RMAN and shared server.F
Increase the total System Global Area （SGA） size to increase memory hits.
考题
单选题The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the year-ending task， SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How does this change to the table affect the index？（）A
An update in a leaf row takes place.B
The index becomes invalid after the update.C
The leaf block containing the row to be updated is marked as invalid.D
A row in the leaf block of the index for the key value is deleted and inserted.
考题
多选题Which three statements are correct about temporary tables？（）AIndexes and views can be created on temporary tables.BBoth the data and the structure of temporary tables can be exported.CTemporary tables are always created in a user’s temporary tablespace.DThe data inserted into a temporary table in a session is available to other sessions.EData manipulation language （DML） locks are never acquired on the data of temporary tables.
考题
单选题Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2， and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further？（）A
RECOVER LOGFILE BLOCK GROUP 2；B
ALTER DATABASE DROP LOGFILE GROUP 2；C
ALTER DATABASE CLEAR LOGFILE GROUP 2；D
ALTER DATABASE RECOVER LOGFILE GROUP 2；E
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2；
考题
多选题You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）AOn startup， SMON coordinates instance recovery.BOn startup， CKPT coordinates instance recovery.COn startup， use RMAN to perform instance recovery.DUncommitted changes will be rolled back after the database is opened.EOn startup， perform media recovery and then instance recovery.FOn startup， all the files will be synchronized and you get both committed and uncommitted data.
考题
多选题You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）AAverage row sizeBLast analyzed dateCSize of table in bytesDSize of table in database blocksENumber of free blocks in the free listFNumber of extents present in the table.
考题
多选题You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）AAverage row sizeBLast analyzed dateCSize of table in bytesDSize of table in database blocksENumber of free blocks in the free listFNumber of extents present in the table.
热门标签
最新试卷