单项选择题Which statement is true regarding remote archive log file destinations?()

A.Only two destinations per remote database can be specified.
B.Destination is an Oracle Net alias specified by using the SERVICE keyword.
C.The REOPEN attribute must be used when using remote archive log file destinations.
D.The service name is resolved by searching sqlnet.ora file for the remote database name.


您可能感兴趣的试卷

你可能感兴趣的试题

3.单项选择题Under the Oracle Shared Server architecture, client-user processes ultimately connect to a()

A.service
B.listener
C.dispatcher
D.shared server process

4.多项选择题Which two are true regarding direct-path exports?()

A.Direct-path export is typically faster.
B.Direct-path export can be invoked interactively.
C.Direct-path export is character set independent.
D.Direct-path export bypasses the SQL-command processing layer.
E.Direct-path export can be used to export rows containing LOBs and BFILEs.

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

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

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

8.多项选择题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

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

最新试题

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

题型:单项选择题

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 data dictionary views displays the error information related to a data file, when an internal read fails on that file?()

题型:单项选择题

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

题型:单项选择题

Which one of the following files contains records that do not meet the specified load criteria in the SQL*Loader control file?()

题型:单项选择题

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 dynamic performance view displays the information about the files associated with the locally managed temporary tablespaces in Oracle9i?()

题型:单项选择题

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?()

题型:单项选择题

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

题型:单项选择题

Which of the following options would you choose to implement controlled access using remote authentication for your networks?()

题型:单项选择题