单项选择题

The performance of your database is affected by the presence of two log members in each online redo log group and the placement of redo log members of a group on the same disk. You decide to place the redo log members of a group on separate disks. Which view will you query to find the name and location of all the online redo log members？（）

A. V$LOG
B. V$LOGFILE
C. DBA_LOG_GROUPS
D. V$LOG_HISTORY

点击查看答案&解析

上一题目录下一题

相关考题

单项选择题

You executed the following code：
SQL> CERATE TABLE COUNTRY
（COUNTRY_ID CHAR（2） CONSTRAINT COUNTRY_ID_nn NOT NULL，
COUNTRY_NAME VARCHAR2（20），
CURRENCY_NAME VARCHAR2（20），
CONSTRAINT COUNTRY_ID_PK PRIMARY KEY （COUNTRY_ID））
ORGANIZATION INDEX；
Which types of tables will be created automatically？（）

A. journal table
B. clustered table
C. mapping table
D. partitioned table

单项选择题

You are creating a job class. You want access to the detailed information for all the runs of each job in the class and every operation performed on every job in the class. Which setting will you use for the LOGGING_LEVEL parameter？（）

A. LOGGING_OFF
B. LOGGING_RUNS
C. LOGGING_FULL
D. LOGGING_NULL

单项选择题

You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）

A. DBA_SCHEDULER_JOB_RUN_DETAILS
B. DBA_SCHEDULER_RUNNING_JOBS
C. DBA_SCHEDULER_JOBS
D. DBA_SCHEDULER_JOB_LOG