In a situation where...

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

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

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

点击查看答案

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

点击查看答案

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

点击查看答案

4.单项选择题You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?（）

A.OPTIMAL
B.INITIAL
C.PCTINCREASE
D.NEXT

点击查看答案

5.单项选择题ou are implementing control file multiplexing. Which of the following choices identifies the method you can use in order to generate the control file copies that Oracle will maintain?（）

A.Issue ALTER DATABASE BACKUP CONTROLFILE TO filename
B.Make a copy of the control file with the database shut down
C.Issue ALTER DATABASE BACKUP CONTROLFILE TO trace
D.Make a copy of the control file with the database still running

点击查看答案

6.单项选择题You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）

A.V$DATABASE
B.DBA_TABLES
C.SYSAUD$
D.EMP

点击查看答案

7.单项选择题You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）

A.SYSTEM
B.OUTLN
C.INTERNAL
D.SYS

点击查看答案

8.单项选择题You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? （）

A.Clone
B.Copy
C.Template
D.Terminal

点击查看答案

9.单项选择题You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）

A.DB_CREATE_FILE_DEST
B.DB_CREATE_ONLINE_LOG_1
C.DB_CREATE_ONLINE_LOG_2
D.The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed

点击查看答案

10.单项选择题You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）

A.When the instance is started
B.When the database is mounted
C.When the database is opened
D.When the database is closed

点击查看答案