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 . Event Viewer gives more details on the failure. B . The alert log file gives detailed information about the failure. C . PMON rolls back the transaction and releases the locks. D . SMON rolls back the transaction and releases the locks. E . The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction. F . Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.

A . The optimizer statistics are collected automatically. B . Only the timed operating system （OS） statistics and plan execution statistics are collected. C . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization. D . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.  E . Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

A . The buffer is currently being accessed. B . The buffer is empty and has not been used. C . The contents of the buffer have changed and must be flushed to the disk by the DBWn process.  D . The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk.

A . alert_ Certkiller .log B . alertlog_ Certkiller .log C . alert_log_ Certkiller .log D . Certkiller _alert_log.log E . log_alert_： Certkiller .log F . trace_alert_ Certkiller .log

A .  Enable flashback logging. B .  Start the database in the ARCHIVELOG mode. C .  Issue the ALTER DATABASE FLASHBACK ON； command. D .  Set the FAST_START_MTTR_TARGET initialization parameter.

A . SPFILE B . archive log C . control file D . system tablespace

A .  Archive log generation is suspended until the tablespaces are taken out of hot backup mode.  B .  Datafiles are not written to during hot backups. C .  Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered. D .  The datafile headers are not updated during the backup. E .  The way data is written to the online redo logs is unchanged during the backup.

A . One tablespace has only one datafile B . Many tablespaces can share one datafile C . One tablespace can have many datafiles D . One datafile can contain many tablespace

A .  The database does not record flashback logs for MY_TABLESPACE B .  The tables residing in MY_TABLESPACE are not protected by the Recycle Bin. C .  All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature. D .  None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

A .  alter database archivelog B .  alter system enable archivelog mode C .  alter database enable archive D .  alter database archivelog enable E .  None of the above

A . Oracle Net Manager B . Listener Control utility C . Database Configuration Assistant D . Oracle Net Configuration Assistant

A .  True B .  False

A . Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set B . The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set C . The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set D . Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startu

A . The optimizer statistics are collected automatically. B . Only the timed operating system （OS） statistics and plan execution statistics are collected. C . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization. D . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.  E . Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

A . shutdown abort  B . shutdown kill  C . Shutdown nowait  D . shutdown immediate E . shutdown halt

A . Optimizer statistics are collected automatically. B . Only timed operating system （OS） statistics and plan execution statistics are collected. C . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. D . Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package. E . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

A . SYS.SOURCE$  B . SYS.AUD$  C . DBA_SOURCE  D . DBA_AUDIT_TRAIL

A . V$DATABASE  B . DBA_TABLES  C . SYSAUD$  D . EMP

A．sublime B．erroneous C．plausible D．impeccable

A．a continuation of our present serious state B．worldwide resources exploitation and energy use C．a movement forward to a new norm to planet research work D．a state where long range planning is essential to us 此题为多项选择题。

In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:Which statement is true about the outcome？（） <img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/4f3f38f4fa50f6813beecdb37f5e123f.jpg' /> A. Only one channel is allocated and the backup is created in the flash recovery area B. Only one channel is allocated and the backup is created in the destination specified for channel C. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2 D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA