单选题

Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command:  LSNRCTL> STOP  What happens to the sessions that are presently connected to the database instance()

AThe sessions are able to perform only queries.

BThe sessions are not affected and continue to function normally.

CThe sessions are terminated and the active transactions are rolled back.

DThe sessions are not allowed to perform any operations till the listener is started.

正确答案

来源:www.examk.com

答案解析

相似试题
  • You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set.   How will you migrate your database from UTF8 to AL16UTF16?()  

    单选题查看答案

  • A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger,which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?()

    单选题查看答案

  • You want to perform in incomplete recovery of your database.  You plan to use these commands to recover your database:  SET UNTIL TIME = ’2000-12-09:11:44:00’;  RESTORE DATABASE; RECOVER DATABASE;  How should the commands be executed? ()

    单选题查看答案

  • You executed the following query in your database:  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output?()

    单选题查看答案

  • Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?()   a. restore controlfile  b. restore database  c. restore spfile  d. recover database  e. alter database open  f. alter database open resetlogs

    单选题查看答案

  • Given the following RMAN commands,choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.()   a. restore database  b. recover database  c. shutdown immediate  d. startup  e. restore archivelog all f. alter database open 

    单选题查看答案

  • 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?()

    多选题查看答案

  • Your database runs in ARCHIVELOG mode, and is backed up every Sunday night using RMAN scripts. On Friday your database crashes. Now you want to use the backups from last Sunday night to restore your database.  How can you do this?()

    单选题查看答案

  • Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups.  Which two backups would you be able to perform when the database is being accessed by users?()

    多选题查看答案

  • You issued the following statement in your SQL*Plus session:   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600;   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database?()

    单选题查看答案