After the recovery i...

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

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

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

点击查看答案

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

点击查看答案

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

点击查看答案

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

点击查看答案

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

点击查看答案

6.单项选择题Under the Oracle Shared Server architecture， client-user processes ultimately connect to a（）

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

点击查看答案

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

点击查看答案

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

点击查看答案

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

点击查看答案

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

点击查看答案