[不定项选择题]Choose the best answer. You want to transport the UNIVERSITY

Tablespace from one database to another. The UNIVERSITY tablespace is

Currently open read/write. The source and destination platforms have the

Same endian Examine this list of steps:. 

1. Make the UNIVERSITY tablespace read-only on the source 

2. Export the UNIVERSITY tablespace metadata using EXPDP. 

3. Create a cross-platform backup set from the UNIVERSITY

Source system, using an RMAN command that includes the DATAPUMP clause. 

4. Copy the cross-platform backup sets to the destination system. 

5. Copy the Data Pump dump set from the source to the destination system. 

6. Restore the cross-platform backup set on the destination system using an

RMAN command that includes the DATAPUMP clause. 

7. Import the UNIVERSITY tablespace metadata using IMPDP. 

8. Make the UNIVERSITY Tablespace read/write on the destination system. 

Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY Tablespace?

A.

3,4,6

B.

2,3,4,5,6,7

C.

1,3,4,6,8

D.

1,2,3,4,5,6,7,8

[不定项选择题]Choose the best answer
You want to create a duplicate database
DUP_DB from your production database PROD on the same host. The PROD
Database uses Automatic Storage Management (ASM) for storage.
Regular backups are taken using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:
RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE
DATABASE;
What is a prerequisite for the successful execution of this command
A. RMAN must be connected to the target database instance and the auxiliary
Instance.
B. A most recent backup set of the PROD database must exist.
C. Flashback must be enabled for the PROD database.
D. The target database must be in MOUNT state.

[不定项选择题]Choose the best answer.

How do you configure a CDB for local undo mode?

A.

Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO

Tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then

Restart the CDB

Instance.

B.

Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER

DATABASE LOCAL UNDO ON, and then restart the CDB instance.

C.

Open the CDB instance in upgrade mode. In each PDB, execute ALTER

DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the

CDB instance.

D.

Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER

DATABASE LOCAL UNDO ON. create an UNDO tablespace in each PDB, and

Then restart the CDB instance.

E. Open the CDB in read-only mode. In CDB$ROOT, execute ALTER DATABASE
LOCAL UNDO ON, and then change the CDB to read/write mode.

[不定项选择题]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.

Use Database Configuration Assistant (DBCA) to create a template from the

Existing database to contain the database structure.

C.

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.

D.

Create the database by using the CREATE DATABASE . . . command and

Manually import data by using Data Pump.

[不定项选择题]Choose two.

You want to install Oracle Grid Infrastructure for a Standalone Server using

Oracle Universal Installer (OUI).

There is no existing Oracle installation on the server.

Which two are prerequisites?

A.

an operating system user to own this installation

B.

the Oracle Inventory group oinstall

C.

an operating system account called grid

D.

a group called dba

E.

the installation of Oracle ASMLIB

[不定项选择题]You notice performance degradation in your production Oracle 12c

Database. You want to know what caused this performance difference.

Which method or feature should you use?

A.

Database Replay

B.

Automatic Database Diagnostic Monitor (ADDM) Compare Period report

C.

Active Session History (ASH) report

D.

SQL Performance Analyzer

[不定项选择题]You are administering a multitenant container database (COB) that

Contains two pluggable databases (PDBs), pdb1 and pdb2. You are

Connected to pdb2 as a common user with DBA privileges. The

Statistics_level parameter is PDB modifiable.

As the user sys, execute the following command on pdb2:

SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;

Which statement is true about the result of this command?

A.

The statistics_level parameter is set to all when any of the PDBs is reopened.

B.

The statistics_level parameter is set to all only for PDB2 when it is reopened.

C.

The statistics_level parameter is set to all when the root database is restarted.

D.

The statement is ignored because there is no SPFILE for a PDB.

[不定项选择题]You must transport the UNIVERSITY tablespace from one database to

Another.

The UNIVERSITY tablespace is currently open read/write.

The source and destination platforms have different endian formats.

Examine this list of actions:

1-Make the UNIVERSITY tablespace read-only on the source system.

2-Export the UNIVERSITY tablespace metadata using EXPDP.

3-Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the source system.

4-Copy the UNIVERSITY tablespace data files to the destination system.

5-Copy the Data Pump dump set to the destination system.

6-Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.

7-Import the UNIVERSITY tablespace metadata using IMPDP.

8-Make the UNIVERSITY tablespace read/write on the destination system.

Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

A.

1, 2, 4, 5, 7, 8

B.

1, 2, 4, 6, 7, 8

C.

1, 2, 3, 4, 5, 7, 8

D.

1, 2, 3, 4, 5, 6, 7, 8

E. 2, 4, 5, 6, 7

[不定项选择题]You accidentally drop the CUSTOMERS table, and then recover it by using
The FLASHBACK TABLE command.
Which two statements are true about the dependent objects of the
CUSTOMERS table?
A. All the triggers associated with the table are flashed back but are disabled.
B. Materialized views that use the CUSTOMERS table are flashed back.
C. LOB segments associated with the CUSTOMERS table are flashed back.
D. All the constraints defined on the table, except the referential integrity
Constraints, are flashed back.
E. Only the primary key constraint created for the table is flashed back, whereas
All other indexes must be retrieved separately.

[不定项选择题]You plan to install Oracle Grid Infrastructure for a Standalone Server

And Oracle Database for the first time on a server.

Examine this command and its outcome:

Which two are true? (Choose two.)

A.

oracle will be an owner of the Oracle Inventory.

B.

oracle must be the owner of every Oracle Database installation.

C.

oracle can own an Oracle Database installation but not an Oracle Grid

Infrastructure installation.

D.

oracle will be granted the SYSASM privilege when installing the Oracle

Database software.

E. The user account, oracle, and group, oinstall, can be used for all Oracle
Software installations.

[不定项选择题]You notice a performance change in your production Oracle 12c

Database. You want to know which change caused this performance

Difference. Which method or feature should you use?

A.

Compare Period ADDM report

B.

AWR Compare Period report

C.

Active Session History (ASH) report

D.

Taking a new snapshot and comparing it with a preserved snapshot.

[不定项选择题]You execute this command successfully: 

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; 

What is the outcome?

A.

It creates a binary backup of the control file.

B.

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

C.

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

D.

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

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

[不定项选择题]You execute the following piece of code with appropriate privileges:

BEGIN DBMS_REDACT.ADD_POLICY ( END; object_schema object_name

Column_name policy_name function_type expression => 'SCOTT', => 'EMP',

=> 'SAL', => 'SCOTT_EMP', => DBMS_REDACT.FULL, => 'SYS_CONTEXT

(''SYS_SESSION_ROLES'',''MGR'') = ''FALSE'''); END; 

BEGIN DBMS_REDACT.ADD_POLICY ( object_schema object_name column_name

Policy_name function_type expression => 'SCOTT', => 'EMP_VW', => 'SAL',

=> 'SCOTT_EMP_VW', => DBMS_REDACT.NONE, => 'SYS_CONTEXT

(''SYS_SESSION_ROLES'',''MGR'') = ''FALSE'''); 

User SCOTT has been granted the CREATE SESSION privilege and the MGR role. 

Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?

A.

DataisredactedfortheEMP.SALcolumnonlyiftheSCOTTsessiondoesnothavetheM

GR role set.

B.

DataisredactedforEMP.SALcolumnonlyiftheSCOTTsessionhastheMGRroleset.

C.

Data is never redacted for the EMP_VW.SAL column.

D.

Data is redacted for the EMP_V.SAL column only if the SCOTT session has the

MGR role set.

E. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not
Have the MGR role set. Correct

[不定项选择题]You configured the Fast Recovery Area (FRA) for your database. The

Database instance is in ARCHIVELOG mode. The default location for the

Archived redo log files is the FRA.

Which two files are removed automatically if space is required in the FRA as

Per the retention policy? (choose two).

A. user-managed backups of data files and control files
B. flashback logs
C. RMAN backups that are obsolete
D. archived redo log files that have multiple copies in a different archive location

[不定项选择题]You notice that the performance of your production 24/7 Oracle 12c

Database has significantly degraded. Sometimes you are not able to connect

To the instance because it hangs. You do not want to restart the database

Instance. How can you detect the cause of the degraded performance?

A.

Enable Memory Access Mode, which reads performance data from SGA.

B.

Use emergency monitoring to fetch data directly from SGA for analysis.

C.

Run Automatic Database Diagnostic Monitor (ADDM) to fetch information

From the latest Automatic Workload Repository (AWR) snapshots.

D.

Use Active Session History (ASH) data and hang analysis in regular

Performance monitoring,

E. Run ADDM in diagnostic mode.

[不定项选择题]You issued this command: RMAN> BACKUP RECOVERY FILES;

Which two are true? (Choose two.)

A. All Oracle recovery files not in the current FRA that have not been backed up
Already, are backed up.
B. All non-Oracle files in the current FRA that have not been backed up already,
Are backed up.
C. All Oracle recovery files in the current FRA that have not been backed up
Already, are backed up.
D. All Oracle recovery files in the current fast recovery area (FRA) are backed up.
E. These backups can be written to disk or SBT.

[不定项选择题]You create a table with the PERIOD FOR clause to enable the use of the

Temporal Validity feature of Oracle Database 12c. Examine the table

Definition: create table employees (empno number, salary number, deptid

Number, name varchar2(100), period for employee_time); Which three

Statements are true concerning the use of the Valid Time Temporal feature

For the EMPLOYEES table?

A. The valid time columns employee_time_start and employee_time_end are
Automatically created.
B.Thesamestatementmayfilteronbothtransactiontimeandvalidtemporaltimebyusin
Gthe AS OF TIMESTAMP and PERIOD FOR clauses.
C. The valid time columns are not populated by the Oracle Server automatically.
D. The valid time columns are visible by default when the table is described.
E. Setting the session valid time using
DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data
Manipulation language (DML), data definition language (DDL), and queries
Performed by the session.

[不定项选择题]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 the

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 default memory allocation

B.

a Data Warehouse database template, with t he dedicated server mode option

And AMM enabled

C.

a General Purpose database template, with t he shared server mode option

And Automatic Memory Management (AMM) enabled

D.

a default database configuration

[不定项选择题]You are working on an Oracle Database 19c database. You enabled the

Flashback Database feature. Which two statements regarding flashback logs

Are true? (Choose two.)

A. Flashback logs are not archived.
B. Flashback logs are maintained in redo log files.
C. Flashback logs are maintained in the Flash Recovery Area.
D. Flashback logs are used to maintain Flashback Database related errors.
E. Flashback logs need to be cleared manually after you disable Flashback
Database.