itgle.com

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 ze

题目

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&e”相关问题
  • 第1题:

    AFTER DROPPING THE PILOT means ______.

    A.After boarding the pilot

    B.After the pilot leaving the ship

    C.After the pilot going on board

    D.After taking the pilot


    正确答案:B

  • 第2题:

    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 list
    • B、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

    正确答案:B,D

  • 第3题:

    Which of the following best describes Simultaneous Multi-threading (SMT)?()

    • A、A POWER5 microprocessor feature that allocates two processors to each application
    • B、A Workload Manager feature that allows two processing threads to be executing on a single processor
    • C、An AIX v5.2 feature that allows two processing threads to be executing on a single processor concurrently
    • D、A POWER5 microprocessor feature that allows two processing threads to be executing on a single processor concurrently

    正确答案:D

  • 第4题:

    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

    正确答案:D

  • 第5题:

    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.

    正确答案:D

  • 第6题:

    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 command
    • B、 executing the CHANGE_PASSWORD command and then the SAVE_CONFIG command
    • C、 executing the CHANGE_PASSWORD command and then the SET PASSWORD command
    • D、 executing the SET PASSWORD command, then the CHANGE_PASSWORD command and finally, the  SAVE_CONFIG command

    正确答案:D

  • 第7题:

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

    DBA_SCHEDULER_JOB_RUN_DETAILS

    B

    DBA_SCHEDULER_RUNNING_JOBS DBA

    C

    DBA_SCHEDULER_CURRENT_JOBS

    D

    DBA_SCHEDULER_JOBS DBA

    E

    DBA_SCHEDULER_EXECUTING_JOBS


    正确答案: C,D
    解析: 暂无解析

  • 第8题:

    单选题
    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 command

    B

     executing the CHANGE_PASSWORD command and then the SAVE_CONFIG command

    C

     executing the CHANGE_PASSWORD command and then the SET PASSWORD command

    D

     executing the SET PASSWORD command, then the CHANGE_PASSWORD command and finally, the  SAVE_CONFIG command


    正确答案: A
    解析: 暂无解析

  • 第9题:

    单选题
    Which of the following best describes Simultaneous Multi-threading (SMT)?()
    A

    A POWER5 microprocessor feature that allocates two processors to each application

    B

    A Workload Manager feature that allows two processing threads to be executing on a single processor

    C

    An AIX v5.2 feature that allows two processing threads to be executing on a single processor concurrently

    D

    A POWER5 microprocessor feature that allows two processing threads to be executing on a single processor concurrently


    正确答案: B
    解析: 暂无解析

  • 第10题:

    多选题
    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 finished executing.

    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.


    正确答案: A,D
    解析: 暂无解析

  • 第11题:

    单选题
    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()?
    A

    foo.notify();

    B

    bar.notify();

    C

    foo.notifyAll();

    D

    Thread.notify();

    E

    bar.notifyAll();


    正确答案: C
    解析: 暂无解析

  • 第12题:

    多选题
    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


    正确答案: C,B
    解析: 暂无解析

  • 第13题:

    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.

    正确答案:B

  • 第14题:

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


    正确答案:KILLALL-SUSR1APACHE2

  • 第15题:

    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 join
    • B、after start
    • C、after join after start
    • D、after start after join

    正确答案:D

  • 第16题:

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

    • A、 DBA_SCHEDULER_JOB_RUN_DETAILS
    • B、 DBA_SCHEDULER_RUNNING_JOBS
    • C、 DBA_SCHEDULER_CURRENT_JOBS
    • D、 DBA_SCHEDULER_JOBS
    • E、 DBA_SCHEDULER_EXECUTING_JOBS

    正确答案:B,D

  • 第17题:

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

    • A、DBA_SCHEDULER_JOB_RUN_DETAILS
    • B、DBA_SCHEDULER_RUNNING_JOBS DBA
    • C、DBA_SCHEDULER_CURRENT_JOBS
    • D、DBA_SCHEDULER_JOBS DBA
    • E、DBA_SCHEDULER_EXECUTING_JOBS

    正确答案:B,D

  • 第18题:

    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 finished executing.
    • 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.

    正确答案:A,C,F

  • 第19题:

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


    正确答案: A
    解析: 暂无解析

  • 第20题:

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

    DBA_SCHEDULER_JOB_RUN_DETAILS

    B

    DBA_SCHEDULER_RUNNING_JOBS

    C

    DBA_SCHEDULER_CURRENT_JOBS

    D

    DBA_SCHEDULER_JOBS

    E

    DBA_SCHEDULER_EXECUTING_JOBS


    正确答案: A,E
    解析: 暂无解析

  • 第21题:

    单选题
    You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; 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


    正确答案: C
    解析: 暂无解析

  • 第22题:

    单选题
    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?()
    A

    Modify the profile assigned to the user.

    B

    Modify the roles assigned to the users.

    C

    Modify the object privileges assigned to the user.

    D

    Modify the system privileges assigned to the users.

    E

    Modify the value for the RESOURCE_LIMIT parameter in the parameter file.


    正确答案: A
    解析: 暂无解析

  • 第23题:

    多选题
    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()
    A

    The session is terminated after receiving the error and JIM can continue with his transaction.

    B

    SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.

    C

    The session is rolled back after receiving the error and JIM can continue with his transaction.

    D

    SCOTT has to reexecute the last command in the transaction after he commits the transaction.


    正确答案: C,B
    解析: 暂无解析

  • 第24题:

    单选题
    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?()
    A

    The backup would be marked as invalid.

    B

    The backup would be marked as obsolete.

    C

    The backup would be removed from the media.

    D

    The backup would be removed from the RMAN repository.


    正确答案: D
    解析: 暂无解析