多选题

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.

正确答案

来源:www.examk.com

答案解析

相似试题
  • You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario()

    多选题查看答案

  • You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario()

    多选题查看答案

  • Click the Exhibit button and examine the diagram.  You are running a database that takes advantage of features provided by Connection Manager, heterogeneous services, and external procedures. The diagram depicts the components used for the naming method you just configured. Which naming method are you using?()

    单选题查看答案

  • You are managing an Oracle Database 11g database. The database is open, and you plan to  performRecovery Manager (RMAN) backups.  Which three statements are true about these backups()

    多选题查看答案

  • You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.  Which three statements are true about these backups()

    多选题查看答案

  • You want to convert your existing non-ASM files to ASM files for the database PROD.  Which method or command would you use to accomplish this task?()  

    单选题查看答案

  • You receive complaints from users regarding the high waiting time for their transactions. Oninvestigation, you find that some users are not committing their transactions though they are  notperforming any activity for a long time. As a result, SQL statements need to wait for row-level locks.  Which two actions could you take to prevent this locking problem in the future()

    多选题查看答案

  • You are implementing a very simple TCP/IP network. It rarely changes and you would like to use Oracle Connection Manager to filter client requests.  Which naming method can you use?()

    单选题查看答案

  • You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task()

    单选题查看答案