Choose two. Which two are true about

多选题 Choose two.

Which two are true about backup set compression using RMAN default compression?

A、 Binary compression adds CPU overhead to backup operations.

B、 Compressed backups can be written only to media.

C、 Compression can be done only for locally managed tablespaces.

D、 Unused blocks below the high water mark are backed up.

E、 Compressed backups cannot have a section size defined.

查看答案

下载APP答题

由4l***b4提供分享举报纠错

相关试题

单选题 You execute this command successfully: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What is the outcome?

A、It creates a copy of the control file in the fast recovery area (FRA).

B、It creates a file that contains SQL statements to re-create the control file.

C、It creates a binary backup of the control file.

D、It creates a file that contains RMAN scripts to create a duplicate database.

E、It updates the alert log with the location and contents of the control file

查看答案

单选题 You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications: Applications will connect to the database via a middle tier. The number of concurrent user connections will be high. The database will have mixed workload, with t he execution of complex BI queries scheduled at night. Which DBCA option must you choose to create the database?

A、a General Purpose database template, with t he shared server mode option and Automatic Memory Management (AMM) enabled

B、a Data Warehouse database template, with t he dedicated server mode option and AMM enabled

C、a default database configuration

D、a General Purpose database template with default memory allocation

查看答案

单选题 Choose the best answer. Examine this configuration:

1. CDB1 is an Oracle container database from an older release.

2. PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1.

A priority list UpgrdList has these entries:

1, pdb2 2, pdb1, pdb3

You execute this command:

$ /u01/app/oracle/product/18.1.0/ db_1/rdbms/admin/dbupgrade -L UpgrdList

In which order will the upgrade occur?

A、CDB$$ROOT, PDB$$SEED, PDB1, PDB3, PDB2, and PDB4

B、CDB$ROOT, PDB1, PDB2, PDB3, and PDB4

C、CDB$$ROOT, PDB$$SEED, PDB2, PDB1, PDB3, and PDB4

D、CDB$$ROOT, PDB$$SEED, PDB2, PDB1, and PDB3

E、CDB$ROOT, PDB2, PDB1, and PDB3

查看答案

单选题 choose one You want to create a test database as a replica of your production database with minimum intervention from a DBA. Which method would you use?

A、Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location.

B、Create the database by using the CREATE DATABASE . . . command and manually import data by using Data Pump.

C、Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.

D、Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.

查看答案

单选题 Choose the best answer. On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days. Level 0 backups are taken on the 10th, 17th, and 24th of August. Differential level 1 incremental backups are taken daily between the level 0 backups. Today is the 26th of August. Which backups will be obsolete?

A、all backups prior to 10th of August

B、all backups prior to 17th of August

C、all backups prior to 24th of August

D、all backups prior to 22nd of August

E、all backups prior to 20th of August

查看答案

单选题 Choose the best answer. Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 container database (CDB). 2. 2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1. After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment: $$ export ORACLE_SID=cdb1 $$ sqlplus / as sysdba SQL> STARTUP UPGRADE;

SQL> SHOW pdbs CON_ID CON_NAME OPEN MODE RESTRICTED

---------------------------------------------------------------

2 PDB$$SEED

3 PDB1

4 PDB2

SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN UPGRADE;

Pluggable database altered.

SQL> exit

$$$ORACLE_HOME/perl/bin/perl catctl.pl -C 'PDB2'

What is the outcome?

A、Only CDB$$ROOT and PDB$$SEED are upgraded.

B、Only CDB$$ROOT, PDB$$SEED, and PDB1 are upgraded.

C、CDB$$ROOT, PDB$$SEED, PDB1, and PDB2 are upgraded.

D、Only CDB$$ROOT, PDB$$SEED, and PDB2 are upgraded.

E、It fails because PDB2 is not in UPGRADE state.

F、It fails because PDB$SEED is in MIGRATE state.

查看答案

单选题 Choose one. Which is true about various Oracle security and auditing capabilities?

A、Application-common OLS policies can be created only if all the PDBs in the application container are closed.

B、Application-common TSDP policies are always container specific.

C、Unified auditing can be automatically synchronized to all application PDBs in an application container.

D、Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container when they are updated.

E、Application-common Transparent Security Data Protection (TSDP) policies can be created only if all the PDBs in the application container are closed.

查看答案

单选题 choose one You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles?

A、The target database control file is synchronized from the recovery catalog with a full resync at the next backup.

B、The target database control file is synchronized from the recovery catalog with a partial resync at the next backup.

C、The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.

D、The recovery catalog is synchronized from the target database control file with a full resync at the next backup.

查看答案