You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance：   SQL> ALTER SYSTEM SWITCH LOGFILE；   Which two tasks are performed when the statement is executed？ （）

A

 The DBWn process writes to the datafile.

B

 Changes in the background process are recorded.

C

 The log file is updated with the current SCN number.

D

 The System Change Number （SCN） is recorded in the control file.

E

 The changes to the listener configuration in the listener.ora file are recorded.

相关问题推荐

• You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）;  Which two statements are true？ （）

  A

  SYSDATE should not be used with TIMESTAMP.

  B

  The database must have multiplexed redo log files.

  C

  The database must be in the MOUNT state to execute the command.

  D

  The database must be opened with the RESETLOGS option after the flashback operation.

  E

  The entire database needs to be restored from the most recent backup before the flashback operation.

  查看答案

• You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components？（）  

  A、 MMAN

  B、 PMON

  C、 MMON

  D、 MMNL

  查看答案

• In which of the following scenarios is a tablespace recovery required？（）

  A、 when recovering a lost read-only tablespace from a read-only tablespace backup

  B、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  ARCHIVELOG mode

  C、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  NOARCHIVELOG mode and the changes in the online redo log files have been overwritten

  D、 when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file， the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement， and this statement was issued when the tablespace was read-only

  查看答案

• In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries.  Which option would you use with the ALTER TABLE command to achieve this objective？（）

  A、REBUILD

  B、CASCADE

  C、TRUNCATE

  D、ROW MOVEMENT

  E、SHRINK SPACE COMPACT

  F、SHRINK SPACE CASCADE

  查看答案

• You are using the DBVERIFY utility to check the datafiles for any block corruption. You want to write the output of the dbv command to a file not to the screen.  Which parameter of the DBVERIFY utility will you use？（）

  A、 FILE

  B、 PARFILE

  C、 LOGFILE

  D、 FEEDBACK

  查看答案