单项选择题

You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?（）

A.ALTER DATABASE
B.ALTER SYSTEM
C.ALTER USER
D.ALTER REDO LOG

点击查看答案

上一题目录下一题

相关考题

单项选择题

You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）

A.Writes buffers to disk
B.Writes current redo log number to datafile headers
C.Writes redo log information to disk
D.Reads information into memory for users

单项选择题

The DBA is defining role for users. Which of the following is not an acceptable method for defining a default role?（）

A.ALTER USER DEFAULT ROLE ALL
B.ALTER USER DEFAULT ROLE ALL EXCEPT ROLE_1
C.ALTER USER DEFAULT ROLE NONE
D.ALTER USER DEFAULT ROLE NONE EXCEPT ROLE_1

单项选择题

You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）

A.LOGICAL_READS_PER_SESSION
B.CONNECT_TIME
C.COMPOSITE_LIMIT
D.CPU_PER_SESSION
E.PRIVATE_SGA