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
您可能感兴趣的试卷
你可能感兴趣的试题
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
A.LOGICAL_READS_PER_SESSION
B.CONNECT_TIME
C.COMPOSITE_LIMIT
D.CPU_PER_SESSION
E.PRIVATE_SGA
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
A.Library cache
B.Row cache
C.Dictionary cache
D.Large area
E.Buffer cache
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
A.DBW0
B.LGWR
C.ARCH
D.SMON
E.PMON
A.OPTIMAL
B.INITIAL
C.PCTINCREASE
D.NEXT
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
A.V$DATABASE
B.DBA_TABLES
C.SYSAUD$
D.EMP
A.SYSTEM
B.OUTLN
C.INTERNAL
D.SYS
最新试题
You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?()
You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?()
You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?()
In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?()
You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? ()
You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?()
In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? ()
You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one. Which is it?()
The rows inside three Oracle tables supporting a customer order entry system are frequently accessed together by means of a table join. Because data is always being added to the tables, you leave a lot of extra space inside each block to accommodate growth. Which of the following types of tables would be useful for storing the data in this context?()
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?()