多项选择题You plan to take a closed database backup using operating system commands. Which three SHUTDOWN options are appropriate for this type of backup?()

A.ABORT
B.NORMAL
C.IMMEDIATE
D.TRANSACTIONAL


您可能感兴趣的试卷

你可能感兴趣的试题

2.单项选择题Which phrase best describes RMAN multiplexed backup sets?()

A.Stripes a single backup set across multiple channels.
B.Identical copies of backup pieces within a backup set.
C.Multiple backup sets with multiple channels configured.
D.Simultaneous reads from multiple files and writes into the same backup piece.

3.多项选择题Which three features are provided by Oracle Net Services? ()

A.Data encryption.
B.User authentication.
C.Transparent data conversion
D.Configuration and administration mechanisms.
E.Support for multiple network transport protocols.

5.多项选择题Which two roles or privileges must you have to export tables owned by another user?()

A.CREATE USER
B.CREATE SESSION
C.CREATE ANY TABLE
D.IMP_FULL_DATABASE
E.EXP_FULL_DATABASE

6.多项选择题In which three cases does a checkpoint occur? ()

A.Every three minutes.
B.When a log switch occurs.
C.When forces by an administrator.
D.When a tablespace is taken offline normal.
E.When the redo buffer is one-third full.

7.单项选择题What is true regarding direct-load insert?()

A.A direct-load insert can be invoked by suing the APPEND hint.
B.Inserting using the NOLOGGING option is the default for direct-load inserts.
C.All data loaded using direct-load insert is loaded below the high-water mark.
D.An object that is modifies using parallel direct-load can be queried within the same Transaction.

8.多项选择题A web browser can connect directly to an Oracle server using which two?()

A.HTTP
B.IIOP
C.TCP/IP
D.Named Pipes
E.TCP/IP with SSL

10.多项选择题

You issue this RMAN command:  
RMAN> create script Level0Backup {  
backup
  incremental level 0  
format ‘/u01/db01/backup/%d_%_Sp’  
fileperset 5
  (database include current controlfile);
  sql ‘alter database archive log current’;  
} 
Which three statements are true about the Level0Backup script you just created?()

A.The script is stored only in the control file.
B.The script is stored only in the recover catalog.
C.The script can be executed only by using the RMAN RUN command.
D.The commands of the script can be displayed with the LIST command.
E.The commands of the script can be displayed with the PRINT command.
F.The commands of the script can be displayed with the REPORT command.

最新试题

Which one of the following statements about the TNSPING utility is correct?()

题型:单项选择题

SQL*Loader reads a set of records from a file, generates INSERT commands, and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in this scenario?()

题型:单项选择题

Which server stack communication layer corresponds to the client application layer in a distributed environment?()

题型:单项选择题

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 Oracle background process is responsible for providing information about the instance name associated with the service handlers and services to the listener?()

题型:单项选择题

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

题型:单项选择题

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

题型:单项选择题

Which script must you to query to display the code associated with RMAN stored scripts?()

题型:单项选择题