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

题目内容 (请给出正确答案)
单选题
What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?()
A

 MMON

B

 LGWR

C

 ARCH

D

 ARWR

E

 COPY


参考答案

参考解析
解析: 暂无解析
更多 “单选题What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?()A  MMONB  LGWRC  ARCHD  ARWRE  COPY” 相关考题
考题 You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?() A. The source database backup must be copied over the net for test database.B. The source database must be run in ARCHIVELOG mode if the database is open.C. The source database must be shut down cleanly if the database is in mounted state.D. A net service name should be set up and a listener configured with the target as well as the source database.

考题 Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart.Examine the following command and its output:$ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled.What does this imply?()A. When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.B. When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.C. When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.D. When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

考题 Which three statements are true when the listener handles connection requests to an Oracle 12cdatabase instance with multithreaded architecture enabled In UNIX?() A. Thread creation must be routed through a dispatcher processB. The local listener may spawn a now process and have that new process create a threadC. Each Oracle process runs an SCMN thread.D. Each multithreaded Oracle process has an SCMN thread.E. The local listener may pass the request to an existing process which in turn will create a thread.

考题 During OSPF adjacency formation, in what state is a router when it is negotiating to be in charge of the database synchronization process?() A. InitB. 2WayC. ExStartD. Exchange

考题 You plan to use static database registration for a new listener when you create it.What could be the two reasons for this?()A、More than one database is to be registered with the listener.B、The users will connect the database by using the host naming method.C、The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.D、The database that is to be registered with the listener is configured in shared server mode.E、The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

考题 During OSPF adjacency formation, in what state is a router when it is negotiating to be in charge of the database synchronization process?()A、InitB、2WayC、ExStartD、Exchange

考题 What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?()A、 MMONB、 LGWRC、 ARCHD、 ARWRE、 COPY

考题 Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens? ()A、archivalB、log writerC、database writerD、system monitorE、process monitorF、change tracking writer

考题 Examine the following RMAN command:   RMAN CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN BACKUP DATABASE PLUS ARCHIVELOG;   Which prerequisite must be met before accomplishing the backup?()A、 Provide a password for the encryptionB、 Set up an Oracle wallet for the encryptionC、 No setup is required as it is a default encryption methodD、 Both Oracle wallet and password must be set up for the encryption

考题 In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?()A、Nothing happensB、Oracle will automatically switch redo logs when detected C、Oracle eventually won't allow new records to be added to the database D、The instance crashes

考题 You are managing a single instance Oracle 10g database that utilizes the following parameters:  Which of the following set of commands must you execute to enable Flashback Database?()A、  STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN;B、  STARTUP MOUNT  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN RESETLOGS;C、  STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG;  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN RESETLOGS;D、  STARTUP MOUNT  ALTER DATABASE ARCHIVELOG;  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN;

考题 What are the different logging modes available in Oracle Database 11g?() A、 NOLOG modeB、 NOARCHIVELOG modeC、 LOGGING modeD、 HOTDATABASE modeE、 ARCHIVELOG mode

考题 You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?()A、When the instance is started B、When the database is mounted C、When the database is opened D、When the database is closed

考题 多选题You plan to use static database registration for a new listener when you create it.What could be the two reasons for this?()AMore than one database is to be registered with the listener.BThe users will connect the database by using the host naming method.CThe Oracle Enterprise Manager is to be used to monitor an Oracle9i database.DThe database that is to be registered with the listener is configured in shared server mode.EThe listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

考题 单选题During OSPF adjacency formation, in what state is a router when it is negotiating to be in charge of the database synchronization process?()A InitB 2WayC ExStartD Exchange

考题 多选题Which three statements are true when the listener handles connection requests to an Oracle 12cdatabase instance with multithreaded architecture enabled In UNIX?()AThread creation must be routed through a dispatcher processBThe local listener may spawn a now process and have that new process create a threadCEach Oracle process runs an SCMN thread.DEach multithreaded Oracle process has an SCMN thread.EThe local listener may pass the request to an existing process which in turn will create a thread.

考题 单选题Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database?()A  Oracle will automatically take the datafile out of hot backup mode,generate a warning message,and then open the database.B  Oracle will automatically take the datafile out of hot backup mode and then open the database.C  Oracle will generate an error when trying to open the database,indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.D  The database will open with the file in hot backup mode. You can restart the backup at any time.E  The datafile in hot backup mode will be corrupted and you will have to recover it.

考题 单选题Examine the following RMAN command: RMAN CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?()A Provide a password for the encryptionB Set up an Oracle wallet for the encryptionC No setup is required as it is a default encryption methodD Both Oracle wallet and password must be set up for the encryption

考题 单选题While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective?()A configure the database to run in ARCHIVELOG modeB configure the Flash Recovery Area to enable automatic database backupC schedule the database backup using DBMS_JOB package after creating the databaseD schedule the database backup using Recovery Manager (RMAN)commands after creating the databaseE schedule the database backup using Database Configuration Assistant (DBCA)while creating the database

考题 单选题You want to make sure that your database backup does not exceed 10 hours in length. What command would you issue that would meet this condition?()A backup database plus archivelogB backup database plus archivlog until time ‘10:00‘C backup database plus archivelog timeout ‘10:00‘D backup database plus archivelog duration 10:00

考题 单选题You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?()A When the instance is started B When the database is mounted C When the database is opened D When the database is closed

考题 单选题Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?()A The database must be running in ARCHIVELOG mode.B No special setup is required, and the feature is enabled by default.C The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.D The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.E Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.

考题 多选题You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?()AThe source database backup must be copied over the net for test database.BThe source database must be run in ARCHIVELOG mode if the database is open.CThe source database must be shut down cleanly if the database is in mounted state.DA net service name should be set up and a listener configured with the target as well as the source database.

考题 多选题Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens? ()AarchivalBlog writerCdatabase writerDsystem monitorEprocess monitorFchange tracking writer

考题 单选题You are managing a single instance Oracle 10g database that utilizes the following parameters:  Which of the following set of commands must you execute to enable Flashback Database?()A   STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN;B   STARTUP MOUNT  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN RESETLOGS;C   STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG;  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN RESETLOGS;D   STARTUP MOUNT  ALTER DATABASE ARCHIVELOG;  ALTER DATABASE FLASHBACK ON;  ALTER DATABASE OPEN;

考题 单选题What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?()A  MMONB  LGWRC  ARCHD  ARWRE  COPY

考题 单选题In the instance of the PROD database, the checkpoint (CKPT) process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration, the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started?()A The modified blocks would be written to the data files.B The modified blocks would be written to the temp files.C The modified blocks would be written to the control file.D The modified blocks would be written to the redo log files.E The modified blocks would be written to the archived redo log files.F The modified blocks would be retained in the database buffer cache.

考题 单选题If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, what will be the result when you issue the command alter database archivelog?()A  The alter database archivelog command will failB  The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG modeC  The alter database archivelog command will succeedD  The alter database archivelog command will ask if you want to make the database consistent firstE  There is no alter database archivelog command. The correct command is alter database alterlogging