单项选择题The Log Writer (LGWR) process reads information from the ()and writes it to the online logs.

A.large pool
B.shared pool
C.data buffer cache
D.redo log buffer
E.data dictionary cache


您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题When you are allowing RMAN to backup your archived redo log files,how does RMAN know which archived redo logs to back up from your archive log destination?()

A.RMAN keeps a list of archive logs in a text file.
B.The DBA must manually tell RMAN which archive logs to backup.
C.RMAN has access to target control file and/or catalog information.
D.RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.

2.单项选择题What is the purpose of importing from an export,and specifying that no rows be imported and that the output goes to a log file?()

A.To verify space requirements in the target database before importing.
B.To generate the SQL for the DDL operations that would occur during import.
C.To check character set compatibility between the export file and the target database.
D.To check for integrity constraint violations that would occur in the target database.

3.多项选择题The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files? ()

A.data files
B.backup sets
C.control files
D.archived redo log files

4.单项选择题Which statement is true regarding the Archiver (ARCn) process,archived log files,and recovery? ()

A.A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. 
B.During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. 
C.After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. 
D.At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.

8.单项选择题Management has decided that the database must be available 24 hours a day, 7 days a week. Given this requirement, which type of backup is required?()

A.user-managed backups.
B.partial database backups.
C.consistent database backups.
D.inconsistent database backups.

9.多项选择题Oracle Net Configuration Assistant is a post-installation tool that configures basic network components after installation. Which four components are included in the configuration?()

A.Directory server
B.Hostname adaptor
C.TCP/IP host file
D.Connection Manager
E.connecting pooling
F.external procedures
G.listener names and protocol addresses
H.Net Service names in a tnsnames.ora file
I.naming methods the client uses to resolve connect identifiers

10.多项选择题Which two file types must be included in a closed database backup taken with operating system commands?()

A.data files
B.control file
C.password file
D.online redo log files
E.initialization parameter file

最新试题

The three tasks shown have been completed in order to configure a naming method: Task 1: Installed on server and client: Oracle Net Services, TCP/IP, TCP/IP protocol adaptor Task 2: Started default listener on port 1521 Task 3: Added global database name to the listener.ora file. Which naming method was configured?()

题型:单项选择题

Where can you obtain information about full database backup set created using RMAN, if the control file was used as the repository?()

题型:单项选择题

The database is being restored from a closed backup. The data files, control files, password file, and parameter file are available, but the online redo logs are not. Because the online redo logs are not available, you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation?()

题型:单项选择题

Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation?()

题型:单项选择题

Which of the following roles must be granted to a user to perform a full database import?()

题型:单项选择题

As a result of a media failure, the current online redo log group is corrupted. The database crashes, as the current online group is inaccessible. Which type of incomplete recovery are you most likely to perform? ()

题型:单项选择题

Which Oracle background process frees SGA resources that were allocated to a user process that failed?()

题型:单项选择题

After a number of days set by the parameter CONTROL_FILE_RECORD_KEEP_TIME, the information in the control file is overwritten by RMAN. What is this parameter’s default value?()

题型:单项选择题

Which of the following parameters must be specified to define the number of dispatchers that need to be started?()

题型:单项选择题

What is the maximum database block size supported for the Oracle9i database?()

题型:单项选择题