Choose the best answer. Examine this

单选题

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

查看答案

下载APP答题

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

相关试题

单选题 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

查看答案

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

查看答案

单选题 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 a container database running in ARCHIVELOG mode.

2. Multiple uncommitted transactions are running in CDB1 .

3. Redo log groups 1 and 2 are INACTIVE.

4. Redo log group 3 is the CURRENT group.

All members of redo log group 3 are lost before it is archived.

Examine these possible steps:

1. SHUTDOWN ABORT

2. STARTUP NOMOUNT

3.STARTUP MOUNT

4. ALTER DATABASE MOUNT

5. RESTORE DATABASE

6. RECOVER DATABASE NOREDO

7. RECOVER DATABASE UNTIL AVAILABLE redo

8. RESTORE ARCHIVELOG ALL

9. ALTER DATABASE OPEN

10. ALTER DATABASE OPEN RESETLOGS

Choose the minimum required steps in the correct order to recover the database.

A、

1,3,5, 6, 10

B、

1,3,5, 7, 10

C、

1,3,5, 6, 9

D、

1,3,5,8, 6, 10

E、

1,3, 5, 6, 10

F、

1,2, 5, 7,4, 10

查看答案

单选题 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

查看答案