After executing the command alter diskgroup disk group2 drop disk dg2a; you issue the following command from the ASM instance:   Select group_number, count(*) from v$asm_operation;   What is the implication if the query against V$ASM_OPERATION returns zero rows?()  A、 The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.B、 The drop disk operation is complete and you can run the undrop disks command if needed.C、 The drop disk operation is complete and you cannot run the undrop disk command.D、 The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance. E、 None of the above is true.

After executing the command alter diskgroup disk group2 drop disk dg2a; you issue the following command from the ASM instance:   Select group_number, count(*) from v$asm_operation;   What is the implication if the query against V$ASM_OPERATION returns zero rows?()  

  • A、 The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.
  • B、 The drop disk operation is complete and you can run the undrop disks command if needed.
  • C、 The drop disk operation is complete and you cannot run the undrop disk command.
  • D、 The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance. 
  • E、 None of the above is true.

相关考题:

Which Scheduler view(s) can be queried to see which jobs are currently executing? () A. DBA_SCHEDULER_JOB_RUN_DETAILSB. DBA_SCHEDULER_RUNNING_JOBS DBAC. DBA_SCHEDULER_CURRENT_JOBSD. DBA_SCHEDULER_JOBS DBAE. DBA_SCHEDULER_EXECUTING_JOBS

试题(74)Changes often happen in(74).(74)A.Initiating ProcessB.Executing ProcessC.Planning ProcessD.Closing Process

Changes often happen in( ).A.Initiating ProcessB.Executing ProcessC.Planning ProcessD.Closing Process

After executing the "show host" command, which of the information below would you see?() A. The IP addresses of workstations allowed gain access to the router via an access listB. Permanent name-to-address mappings created using the ip host command.C. Temporary and permanent DNS entries.D. The names of the routers created using the hostname command.E. The length of time of users logged into the router, as well as the duration

AFTER DROPPING THE PILOT means ______.A.After boarding the pilotB.After the pilot leaving the shipC.After the pilot going on boardD.After taking the pilot

You decided to change the location of the flash recovery area. You executed the following command: Which statement is true?()A、The location can be changed only if the flash recovery area is empty.B、After executing the command, all new flash recovery area files will be created in the new location.C、The command will generate an error because you cannot change the flash recovery area while the database is open.D、All the existing files in the flash recovery area will be moved to the new location, and all new Flash Recovery Area files will be created in the new location.

After executing the "show host" command, which of the information below would you see?()A、The IP addresses of workstations allowed gain access to the router via an access listB、Permanent name-to-address mappings created using the ip host command.C、Temporary and permanent DNS entries.D、The names of the routers created using the hostname command.E、The length of time of users logged into the router, as well as the duration

What command with all options and/or parameter will send the signal USR1 to any executing process of  program apache2?()

Which of the following best describes Simultaneous Multi-threading (SMT)?()A、A POWER5 microprocessor feature that allocates two processors to each applicationB、A Workload Manager feature that allows two processing threads to be executing on a single processorC、An AIX v5.2 feature that allows two processing threads to be executing on a single processor concurrentlyD、A POWER5 microprocessor feature that allows two processing threads to be executing on a single processor concurrently

class Work implements Runnable {  Thread other;   Work(Thread other) { this.other = other; }  public void run() {  try { other.join(); } catch (Exception e) { }  System.out.print("after join ");  } }  class Launch {  public static void main(String [] args) {  new Thread(new Work(Thread.currentThread())).start();  System.out.print("after start ");  } }  结果为:()A、after joinB、after startC、after join after startD、after start after join

Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently, several users are executing long-running queries on the database. What will happen to the ongoing activity in the database?()A、 The queries that are currently executing will abort and an error message will be returned to the user.B、 The queries that are currently executing will execute normally but future queries will not executed.C、 Data Manipulation Language (DML) statements cannot be performed on the tables on which the indexes are based.D、 The currently executing and future queries will execute normally, but will be slower

Which Scheduler view(s) can be queried to see which jobs are currently executing?()A、 DBA_SCHEDULER_JOB_RUN_DETAILSB、 DBA_SCHEDULER_RUNNING_JOBSC、 DBA_SCHEDULER_CURRENT_JOBSD、 DBA_SCHEDULER_JOBSE、 DBA_SCHEDULER_EXECUTING_JOBS

You issue the following command on the RMAN prompt.   RMAN REPORT NEED BACKUP DAYS = 5 DATABASE;   Which statement is true about executing this command?()A、 It will display a list of files that need incremental backup.B、 It will display a list of files that need backup after five days.C、 It will display a list of files that were backed up in the last five days.D、 It will display a list of files that have not been backed up in the last five days.E、 It will apply the current retention policy to determine the files that need to be backed up.

Which Scheduler view(s) can be queried to see which jobs are currently executing? ()A、DBA_SCHEDULER_JOB_RUN_DETAILSB、DBA_SCHEDULER_RUNNING_JOBS DBAC、DBA_SCHEDULER_CURRENT_JOBSD、DBA_SCHEDULER_JOBS DBAE、DBA_SCHEDULER_EXECUTING_JOBS

You previously secured your listener with an encrypted password. However, you need to set a new password for security reasons. What is the correct method for setting a new encrypted password for the listener using the Listener Control utility?()A、 executing the SET PASSWORD command and then the SAVE_CONFIG commandB、 executing the CHANGE_PASSWORD command and then the SAVE_CONFIG commandC、 executing the CHANGE_PASSWORD command and then the SET PASSWORD commandD、 executing the SET PASSWORD command, then the CHANGE_PASSWORD command and finally, the SAVE_CONFIG command

You are developing an application that connects to a Microsoft SQL Server database using the SqlConnection object. Your connection objects are being pooled. As the pool fills up, connection requests are queued. Some connection requests are rejected. You need to ensure that the application releases connections back to the pool as soon as possible. Also, you need to decrease the likelihood that connection requests will be rejected. Which three actions should you perform?()A、Ensure that the Close method is called on each connection object after it has finishedexecuting.B、Ensure that each connection object is left open after it has finished executing.C、Increase the Max Pool Size value inside the connection string.D、Increase the Min Pool Size value inside the connection string.E、Increase the Connection Lifetime value inside the connection string.F、Increase the value of the ConnectionTimeout property of the SqlConnection object.

多选题Which Scheduler view(s) can be queried to see which jobs are currently executing? ()ADBA_SCHEDULER_JOB_RUN_DETAILSBDBA_SCHEDULER_RUNNING_JOBS DBACDBA_SCHEDULER_CURRENT_JOBSDDBA_SCHEDULER_JOBS DBAEDBA_SCHEDULER_EXECUTING_JOBS

单选题Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently, several users are executing long-running queries on the database. What will happen to the ongoing activity in the database?()A The queries that are currently executing will abort and an error message will be returned to the user.B The queries that are currently executing will execute normally but future queries will not executed.C Data Manipulation Language (DML) statements cannot be performed on the tables on which the indexes are based.D The currently executing and future queries will execute normally, but will be slower

单选题You previously secured your listener with an encrypted password. However, you need to set a new password for security reasons. What is the correct method for setting a new encrypted password for the listener using the Listener Control utility?()A executing the SET PASSWORD command and then the SAVE_CONFIG commandB executing the CHANGE_PASSWORD command and then the SAVE_CONFIG commandC executing the CHANGE_PASSWORD command and then the SET PASSWORD commandD executing the SET PASSWORD command, then the CHANGE_PASSWORD command and finally, the SAVE_CONFIG command

多选题Which Scheduler view(s) can be queried to see which jobs are currently executing?()ADBA_SCHEDULER_JOB_RUN_DETAILSBDBA_SCHEDULER_RUNNING_JOBSCDBA_SCHEDULER_CURRENT_JOBSDDBA_SCHEDULER_JOBSEDBA_SCHEDULER_EXECUTING_JOBS

单选题Which of the following best describes Simultaneous Multi-threading (SMT)?()AA POWER5 microprocessor feature that allocates two processors to each applicationBA Workload Manager feature that allows two processing threads to be executing on a single processorCAn AIX v5.2 feature that allows two processing threads to be executing on a single processor concurrentlyDA POWER5 microprocessor feature that allows two processing threads to be executing on a single processor concurrently

单选题You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?()AIt will display a list of files that need incremental backupBIt will display a list of files that need backup after five daysCIt will display a list of files that were backed up in the last five daysDIt will display a list of files that have not been backed up in the last five daysEIt will apply the current retention policy to determine the files that need to be backed up

多选题You are developing an application that connects to a Microsoft SQL Server database using the SqlConnection object. Your connection objects are being pooled. As the pool fills up, connection requests are queued. Some connection requests are rejected. You need to ensure that the application releases connections back to the pool as soon as possible. Also, you need to decrease the likelihood that connection requests will be rejected. Which three actions should you perform?()AEnsure that the Close method is called on each connection object after it has finished executing.BEnsure that each connection object is left open after it has finished executing.CIncrease the Max Pool Size value inside the connection string.DIncrease the Min Pool Size value inside the connection string.EIncrease the Connection Lifetime value inside the connection string.FIncrease the value of the ConnectionTimeout property of the SqlConnection object.

单选题A user complains that he gets the following error message repeatedly after executing some SQL statements. The error message forces the user to log off from and log on to the database to continue his work. ORA-02392: exceeded session limit on CPU usage, you are being logged off Which action would you take to increase the session limit on CPU usage?()AModify the profile assigned to the user.BModify the roles assigned to the users.CModify the object privileges assigned to the user.DModify the system privileges assigned to the users.EModify the value for the RESOURCE_LIMIT parameter in the parameter file.

单选题Given: foo and bar are public references available to many other threads. foo refers to a Thread and bar is anObject.  The thread foo is currently executing bar.wait().  From another thread,what provides the most reliable wayto ensure that foo will stop executing wait()?Afoo.notify();Bbar.notify();Cfoo.notifyAll();DThread.notify();Ebar.notifyAll();

多选题The session of user SCOTT receives the following error after executing an UPDATE command on the EMPtable: ERROR at line 1: ORA-00060: deadlock detected while waiting for resource On investigation, you find that a session opened byuser JIM has a transaction that caused the deadlock.  Which two statements are true regarding the session ofSCOTT in this scenario()AThe session is terminated after receiving the error and JIM can continue with his transaction.BSCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.CThe session is rolled back after receiving the error and JIM can continue with his transaction.DSCOTT has to reexecute the last command in the transaction after he commits the transaction.

多选题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 defined the Recovery Manager (RMAN) retention policy to recovery window of 7 days by executing the following command:  RMAN CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;  When a backup is performed, what would be the status of this backup after seven days?()AThe backup would be marked as invalid.BThe backup would be marked as obsolete.CThe backup would be removed from the media.DThe backup would be removed from the RMAN repository.