单项选择题

You perform a backup using the following BACKUP command:
RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE;
Which statement is true of this command?()

A. A different procedure is required to restore a database from compressed backups
B. The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.
C. Using this command to create backups minimizes the bandwidth consumed
D. Using this command to create backups improves the performance of the backup process


您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题

Evaluate the following block of code:  
BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL ( acl => 
’mycompany-com-permissions.xml’, principal => ’ACCT_MGR’, is_grant => TRUE, privilege => ’connect’); 
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL ( acl => ’mycompany-com-permissions.xml’,
host => ’*.mycompany.com’);
END;  
What is the outcome of the above code?()

A. It produces an error because a fully qualified host name needs to be specified.
B. It produces an error because the range of ports associated with the hosts has not been specified.
C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and  RESOLVE privileges.
D. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.

2.单项选择题

You issue the following command on the RMAN prompt.
REPORT NEED BACKUP DAYS 5;
Which statement is true about executing this command?()

A. It will display a list of files that need incremental backup
B. It will display a list of files that need backup after five days
C. It will display a list of files that were backed up in the last five days
D. It will display a list of files that have not been backed up in the last five days
E. It will apply the current retention policy to determine the files that need to be backed up


3.单项选择题

You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy:
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
Which statement is true?()

A. The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabled
B. Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed up
C. Backup optimization is permanently disabled
D. Backup optimization is temporarily disabled because a redundancy-based retention policy is specified

5.多项选择题Which two statements about workload capture and replay operations are true?()  

A. The clients must be created manually on the test machines to perform more realistic testing.
B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.
C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.
D. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

6.多项选择题Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.()

A. Cursor cache
B. Stored outline
C. SQL Tuning Set
D. Automatic Workload Repository (AWR) snapshots

7.单项选择题Which of the following is not a valid linguistic sort element?()

A. Accent expansion
B. Canonical equivalence
C. Reverse secondary sorting
D. Ignorable characters
E. Character rearrangement

8.单项选择题What is the name of the file that identifies the set of available locale definitions?()

A. locale.def
B. lxdef.ora
C. lx1boot.nlb
D. lx1boot.ora
E. lang.def

10.单项选择题Which NLS parameter directly governs linguistic searches?()

A. NLS_SEARCH_L
B. NLS_SORT
C. NLS_SEARCH
D. NLS_SORT_L
E. None of the above

最新试题

To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file?() 

题型:多项选择题

Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.()

题型:多项选择题

You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:  1) Restore an autobackup of the server parameter file.2) Restore the control file 3) Start the target database instance 4) Mount the database 5) Restore the data files 6) Open the database with RESETLOGS option 7) Recover the data files 8) Set DBID for the target database  Which option illustrates the correct sequence that you must use?()  

题型:单项选择题

Which two statements are true about a job chain?()

题型:多项选择题

Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database?()

题型:多项选择题

Examine the CREATE DISKGROUP command used to create a disk group:  SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK ’ORCL: FRA3’ NAME misc1, ’ORCL: FRA4’ NAME misc2;  In which situation would you use this method of disk group creation?()

题型:单项选择题

Examine the following RMAN script:  RMAN> run { debug on; allocate channel c1 type disk; backup datafile 5; }  Which statement describes the purpose of the script?()  

题型:单项选择题

Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough. What could be a solution to make tape streaming happen during the backup?()  

题型:单项选择题

You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this:  1. Set the retention target: SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320; 2. Enable Flashback Database: SQL> ALTER DATABASE FLASHBACK ON; 3. Mount the database: SQL> STARTUP MOUNT EXCLUSIVE 4. Shutdown the instance: SQL> SHUTDOWN IMMEDIATE 5. Open the database: SQL> ALTER DATABASE OPEN;  Choose the correct sequence.()

题型:单项选择题

Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener?()

题型:单项选择题