You have implemented&#8194...

单项选择题You have implemented OMF for redo log management. Which of the following choices reflects a log filename that might be employed when OMF is enabled?（）

A.log01.log
B.logORCL01.log
C.1_2.logALTER ROLLBACK SEGMENT
D.ora_1_asdf1234.log

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?（）

A.INSERT
B.SELECT
C.UPDATE
D.DELETE

点击查看答案

2.单项选择题To allocate another role to a user, which command is most appropriate?（）

A.ALTER USER
B.ALTER DATABASE
C.ALTER SYSTEM
D.GRANT

点击查看答案

3.单项选择题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

点击查看答案

4.单项选择题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

点击查看答案

5.单项选择题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

点击查看答案

6.单项选择题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

点击查看答案

7.单项选择题In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）

A.Nothing happens
B.Oracle will automatically switch redo logs when detected
C.Oracle eventually won't allow new records to be added to the database
D.The instance crashes

点击查看答案

8.单项选择题You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）

A.Library cache
B.Row cache
C.Dictionary cache
D.Large area
E.Buffer cache

点击查看答案

9.单项选择题You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）

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 tablespaces

点击查看答案

10.单项选择题During regular database operation, which background process will take smaller blocks of free space in a dictionary-managed tablespace and move things around to make bigger pieces of free space?（）

A.DBW0
B.LGWR
C.ARCH
D.SMON
E.PMON

点击查看答案