网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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 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.


参考答案

参考解析
解析: 暂无解析
更多 “单选题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.” 相关考题
考题 View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:What is the multiplexing level in the preceding backup process() A. 4B. 8C. 7D. 0

考题 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 containerB. 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$SEEDD. Data files that belong to the root container and all the PDBs excluding PDB$SEED

考题 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-wayB. two-wayC. three-wayD. No handshakes required during authenticationE. None of the above

考题 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=300B、Add the following lines to /.profile  TMOUT=5  export TMOUTC、Execute the following command:  chuser -u ALL -a TIMEOUT=5MD、Execute the following command:  chsec -u ALL -a TIMEOUT=600

考题 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 filesB、 The database must be in the MOUNT state to execute the commandC、 The database must be in the NOMOUNT state to execute the commandD、 The database must be opened in RESTRICTED mode before this operationE、 The database must be opened with the RESETLOGS option after the flashback operation

考题 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.

考题 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 datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block

考题 You issued the following statement:   SQLALTER 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.

考题 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 openedC、The password file is opened.D、The parameter file is opened.E、All online data files are opened.

考题 You execute the following command to start an Automatic Storage Management (ASM) instance:   SQLSTARTUP;   In which of the following modes will the ASM instance start?()A、 OPENB、 MOUNTC、 NORMALD、 NOMOUNT

考题 One of the users in the PROD database,Adams,complains that his update on the table,TRANS, is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions,and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table, he should get the highest priority.  Which method would you use to overcome this problem?()A、execute the command, ALTER SESSION KILL .., to kill the blocking sessionB、execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking sessionC、execute the command, ALTER SYSTEM KILL SESSION .., to kill the blocking sessionD、execute the command, ALTER SESSION UNLOCK .., to release the lock for the blocking sessionE、execute the command, ALTER SYSTEM UNLOCK SESSION .., to release the lock for the blocking session

考题 You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery?()  A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command

考题 The corporate network of Certkiller consists of a Windows Server 2008 single Active Directory domain. The domain has two servers named Certkiller 1 and Certkiller 2.  To ensure central monitoring of events you decided to collect all the events on one server, Certkiller 1. To collect events from Certkiller  2. and transfer them to Certkiller 1, you configured the required event subscriptions.  You selected the Normal option for the Event delivery optimization setting by using the HTTP protocol. However, you discovered that none of the subscriptions work.  Which of the following actions would you perform to configure the event collection and event forwarding on the two servers()A、Through Run window execute the winrm quickconfig command on Certkiller 2.B、Through Run window execute the wecutil qc command on Certkiller 2.C、Add the Certkiller 1 account to the Administrators group on Certkiller 2.D、Through Run window execute the winrm quickconfig command on Certkiller 1.E、Add the Certkiller 2 account to the Administrators group on Certkiller 1.F、Through Run window execute the wecutil qc command on Certkiller 1.

考题 ertkiller .com has purchased laptop computers that will be used to connect to a wireless network. You create a laptop organizational unit and create a Group Policy Object (GPO) and configure user profiles by utilizing the names of approved wireless networks. You link the GPO to the laptop organizational unit. The new laptop users complain to you that they cannot connect to a wireless network.  What should you do to enforce the group policy wireless settings to the laptop computers()A、Execute gpupdate/target:computer command at the command prompt on laptop computersB、Execute Add a network command and leave the SSID (service set identifier) blankC、Execute gpupdate/boot command at the command prompt on laptops computersD、Connect each laptop computer to a wired network and log off the laptop computer and then login again.E、None of the above

考题 多选题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?()AAll control files are opened.BAll redo log files are openedCThe password file is opened.DThe parameter file is opened.EAll online data files are opened.

考题 多选题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?()AThe database must have multiplexed redo log filesBThe database must be in the MOUNT state to execute the commandCThe database must be in the NOMOUNT state to execute the commandDThe database must be opened in RESTRICTED mode before this operationEThe database must be opened with the RESETLOGS option after the flashback operation

考题 单选题Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?()A Start the server with the – innodb_recover_options option set to FORCEB Start the server with the – innodb_force_recovery option set to a non-zero valueC Start the server as usual, and then execute the REPAIR TABLE commandD Start the server as usual, and then execute the CHECK TABLE command

考题 单选题You issued the following statement:   SQLALTER 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.

考题 单选题You execute the following command to start an Automatic Storage Management (ASM) instance:   SQLSTARTUP;   In which of the following modes will the ASM instance start?()A  OPENB  MOUNTC  NORMALD  NOMOUNT

考题 单选题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.

考题 单选题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 containerB 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$SEEDD Data files that belong to the root container and all the PDBs excluding PDB$SEED

考题 单选题You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table: ALTER TABLE customers  MODIFY (cust_nameVARCHAR2 (40)) /  When you execute the command, it displays the following error message:  ERROR at line 1:  ORA-00054: resource busy and acquire with NOWAIT specified  What could be the reason for the error message?()A The database instance is not available.B The ALTER TABLE command does not have WAIT optionC The table or a row in the table is currently locked by another user session.D The database instance is busy processing other user sessions commands.E The CUSTOMERS table has no long running query active at the time when this request is made.F The server process executing the ALTER TABLE command is busy with another command execution

考题 单选题You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery?()A  You will need to open the database with the resetlogs command.B  All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C  You will use the resetlogs version of the create controlfile command.D  You will use the noresetlogs version of the create controlfile command.E  You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command

考题 单选题Consider the MySQL Enterprise Audit plugin. On attempting to start the MySQL service after a crash, notice the following error: [ERROR] Plugin ‘audit_log’ init function returned error. In the audit log file, you notice the final entry: … What action should you take to fix the error and allow the service to start?()A Re-install the audit pluginB Execute the command FLUSH LOGSC Execute the command SET GLOBAL audit_log_fiush= OND Move or rename the existing audit.log file

考题 多选题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? ()Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block

考题 多选题You work as a database administrator for Supportcenter.cn. Your 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?()AAll control files are openedBAll redo files are openedCThe password file is openedDThe parameter file is openedEAll online data files are opened

考题 单选题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.