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