CMS专题
单选题You execute the following command toauditdatabase activities： SQL>AUDITDROP 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 ses
题目
Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.
Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.
One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.
One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.
相似问题和答案
第1题：
You are troubleshooting a WAN connection for TestKing, and on the router you execute the, "debug ppp authentication" command, and view the following output:What kind of handshake was used for the PPP authentication?（）
A. one-way
B. two-way
C. three-way
D. No handshakes required during authentication
E. None of the above
第2题：
You plan to execute the following command to perform a Flashback Database operation in your database： SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）； Which two statements are true about this？（）
- A、 The database must have multiplexed redo log files
- B、 The database must be in the MOUNT state to execute the command
- C、 The database must be in the NOMOUNT state to execute the command
- D、 The database must be opened in RESTRICTED mode before this operation
- E、 The database must be opened with the RESETLOGS option after the flashback operation
正确答案:B,E
第3题：
A. 4
B. 8
C. 7
D. 0
第4题：
our database is in the MOUNT state and you execute the following command to open it： ALTER DATABASE OPEN What two actions are performed as a result of this command？（）
- A、All control files are opened.
- B、All redo log files are opened
- C、The password file is opened.
- D、The parameter file is opened.
- E、All online data files are opened.
正确答案:B,E
第5题：
Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）
- A、 when you change the name of a datafile
- B、 when you drop a table from the database
- C、 when you take an export of the database
- D、 when you back up the database using OS utilities
- E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
- F、 when you issue a BACKUP command from inside the RMAN run block
正确答案:A,E,F
第6题：
For security reasons， an administrator is asked to modify the system to prevent someone from leaving a terminal logged in. To enable a five minute timeout for all users， what would need to be done to accomplish this task？（）
- A、Add the following line to /etc/environment： TMOUT=300
- B、Add the following lines to /.profile TMOUT=5 export TMOUT
- C、Execute the following command： chuser -u ALL -a TIMEOUT=5M
- D、Execute the following command： chsec -u ALL -a TIMEOUT=600
正确答案:A
第7题：
Consider the following scenario： You have a directory， data， under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following command： ALTER DISKGROUP tdgroupA ADD ALIAS ’+tdgroupA/data/datafile.dbf’ FOR ’+tdgroupA.231.45678’； Which task would be accomplished by the command？（）
- A、The command drops the file +tdgroupA·231.45678.
- B、The command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.
- C、The command creates a copy of the +tdgroupA·231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.
- D、The command creates an alias， datafile.dbf， and places it in +tdgroupA/data and does not remove the +tdgroupA·231.45678 file.
- E、The command creates a file， datafile.dbf， in +tdgroupA/data and removes the references for +tdgroupA·231.45678 from the data dictionary views.
正确答案:D
第8题：
Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN > BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?（）
A. Data files that belong to only the root container
B. Data files that belong to the root container and all the pluggable databases (PDBs)
C. Data files that belong to only the root container and PDB$SEED
D. Data files that belong to the root container and all the PDBs excluding PDB$SEED
第9题：
You issued the following statement： SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n； What will be the result of issuing the above statement？（）
- A、The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.
- B、 The command will not execute successfully because resumable space allocation is enabled at the session level.
- C、 The command will execute successfully and resumable space will be allocated at the session level.
- D、 The command will execute successfully and resumable space will be allocated at the instance level.
正确答案:B
第10题：
You execute the following command to start an Automatic Storage Management （ASM） instance： SQL>STARTUP； In which of the following modes will the ASM instance start？（）
- A、 OPEN
- B、 MOUNT
- C、 NORMAL
- D、 NOMOUNT
正确答案:B