多项选择题

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.


您可能感兴趣的试卷

你可能感兴趣的试题

2.多项选择题Which two statements are true regarding the use of UTF-16 encoding? ()

A.Enables easier loading of multinational data. 
B.Uses a fixed-width Multibyte encoding sequence.
C.Asian characters are represented in three characters. 
D.Used a variable-width Multibyte encoding sequence. 
E.European characters are represented on one or two bytes. 

3.单项选择题What is true regarding a shared, server-side parameter file for a Real Application Cluster database? ()

A.It can contain parameters with distinct values for each distance.
B.It can contain only parameters with identical values for each instance.
C.It must contain an IFILE parameter for each instance’s individual parameter file.
D.It must be located in the default location for the primary instance’s parameter file.

4.单项选择题Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance?()

A.Data blocks have to be written more frequently by DBWR. 
B.Redo blocks have to be written more frequently by LGWR. 
C.You need to substantially increase the size of your database buffer cache to hold the additional checkpoint records. 
D.You need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.

6.单项选择题What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED; command?()

A.The standby database is protected against write operations. 
B.The primary database is protected against write operations. 
C.The primary database is protected against data loss and data divergence. 
D.The standby database is protected against data loss and data divergence. 

7.单项选择题What is the new Oracle Shared Server?()

A.An improved version of multithreaded server configuration. 
B.A connection pooling configuration where several clients are connected to the same server process. 
C.Two more database servers, which share data by means of database links; the client software is unaware to which server it is connected. 
D.A configuration of Real Application Cluster where the client connection is routed to the least busy instance. 

8.多项选择题Which three statements are true about the privileged connection options available in Oracle9i?()

A.The CONNECT INTERNAL is disallowed. 
B.The Server Manager tool is no longer supplied. 
C.The listener must be running to make a connection. 
D.The use of remote password login file (orapw<sid>) is unchanged.

9.单项选择题You can control instance recover performance by setting parameters to define targets for()

A.The size of the redo buffer in SGA. 
B.The instance that will perform recovery in Real Application Cluster database. 
C.The number of blocks to be read during instance recovery, or the time needed to complete instance recovery. 
D.The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.

10.单项选择题The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan?()

A.ALTER TABLE employees monitor index employee_idx_fk; 
B.ALTER INDEX employee_idx_fk monitoring on; 
C.ALTER TABLE employees monitor all indexes; 
D.ALTER INDEX employee_idx_fk monitoring usage; 

最新试题

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

题型:单项选择题

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 SQL*Loader parameters enables you to load a specified number of records stored in the data file?()

题型:单项选择题

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

题型:单项选择题

Which one of the following RMAN commands is used to register the database files with repository that were backed up using O/S commands?()

题型:单项选择题

Which of the following commands must be issued to remove a stored script from the recovery catalog?()

题型:单项选择题

As A DBA, which of the following methods can you use to make a backup of your table?()

题型:单项选择题

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 options enables a user to get authenticated though a single password instead of using multiple passwords?()

题型:单项选择题

Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state, prior to the load operation?()

题型:单项选择题