单项选择题The database is configured for automatic archive logging. Along with the other required parameters， this entry is in the initialization file：log_archive_dest2="SERVICE=standby_db1 MANDATORY REOPEN=600" From where does the database resolve standby_db1？（）

A.control file
B.tnsnames.ora
C.data dictionary
D.initialization parameter file

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题RMAN automatically propagate information about the database structure， archived redo logs， backup sets， and data file copies into the recovery catalog from the target database’s control file. This information can also be propagated to the catalog manually by using the （）command.

A.LIST
B.SWITCH
C.VALIDATE
D.CONFIGURE
E.RESYNC CATALOG
F.UPGRADE CATALOG

点击查看答案
2.多项选择题Which three features are provided by Recovery Manager and NOT provided by user-managed backup and recovery？（）

A.Online backups.
B.Skipping unused block. 
C.Partial database backups.
D.Incremental block-level backup.
E.Detection of corrupted blocks during backup.

点击查看答案
3.多项选择题Which two SQL*Loader instructions are used to assemble logical records？（）

A.WHEN
B.INFILE
C.CONTINUEIF
D.CONCATENATE
E.TRAILING NULLCOLS

点击查看答案
4.单项选择题

You have discovered that a disk failure occurred on DISK1 where the data files belonging to the SYSTEM and USER_DATA tablespaces is stored. The database is currently open and you need to recover the data files. You will restore the data files to DISK2. What is the correct sequence of RMAN commands to restore and recover the data files？（）

A.A
B.B
C.C
D.D

点击查看答案
5.单项选择题After the recovery is complete， which command should you execute？（）

A.ALTER DATABASE OPEN；
B.ALTER DATABASE CLEAR LOGFILE；
C.ALTER DATABASE OPEN RESETLOGS；
D.ALTER DATABASE OPEN NORESETLOGS；

点击查看答案
6.单项选择题While connected to the database，a user on a PC receives a fatal error and the machine reboots. Which background process cleans up the failed connection？（）

A.ARCn
B.CKPT
C.DBWn
D.LGWR
E.PMON
F.SMON

点击查看答案
7.多项选择题You notice that your RMAN script used to copy the datafiles， control files， and archived redo log files is performing very slowly. Which two changes might you want to include in your RMAN script to speed up the COPY commands？（）

A.NOCHECKSUM
B.MAXCORRUPT
C.CHECK LOGICAL
D.BACKUP INCREMENTAL
E.CONFIGURE DEVICE TYPE ... PARALLELISM

点击查看答案
8.单项选择题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.

点击查看答案
9.多项选择题

You issue this SQL command to perform an online backup of the USER_DATA tablespace：ALTER TABLESPACE user_data BEGIN BACKUP；Next， you issue an operating system command to back up user_data01.dbf， the file that belongs to the USER_DATA tablespace. You then experience an instance failure. 
Which three statements are true？（）

A.A
B.B
C.C
D.D
E.E

点击查看答案
10.单项选择题Which RMAN command is used to verify the status of a backup or copy， and also updates the repository when files have been deleted using operating system commands？（）

A.CHANGE
B.RESYNC
C.CATALOG
D.CROSSCHECK

点击查看答案

最新试题

Which one of the following parameters must be specified when exporting objects that has integrity constraints referencing objects that are currently being accessed by other users？（）

题型：单项选择题

If you CROSSCHECK the backup piece that was previously marked as EXPIRED but is now available， what would the status of this backup piece be in the RMAN repository？（）

题型：单项选择题

Which script must you to query to display the code associated with RMAN stored scripts？（）

题型：单项选择题

Which Oracle background process is responsible for providing information about the instance name associated with the service handlers and services to the listener？（）

题型：单项选择题

RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）

题型：单项选择题

Which one of the following statements about the TNSPING utility is correct？（）

题型：单项选择题

You are configuring the listener on your server. Which listener.ora parameter contains the information needed to detect session requests from different client types？（）

题型：单项选择题

Which of the following commands cannot be executed when the database open？（）

题型：单项选择题

As A DBA， which of the following methods can you use to make a backup of your table？（）

题型：单项选择题

Which server stack communication layer corresponds to the client application layer in a distributed environment？（）

题型：单项选择题