Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

examout.co

You unplugged a PDB to plug it into another CDB with the following command: SQL> ALTER PLUGGABLE DATABASE pdb1 UNPLUG INTO '/tmp/pdb1.pdb'; Which statement is true prior to plugging the PDB into the other CDB?

A.

The PDB archive file must be copied to the target CDB.

B.

The PDB manifest and all the datafiles must be copied to the target CDB.

C.

PDB archive file and only the user-defined tablespaces must be copied to the target CDB.

D.

The PDB manifest, the data files, and the PDB archive file must be copied to the target CDB.

Examine these commands:

[oracle@host01 ~]$ sqlplus u1/oracle

SQL> SELECT * FROM emp;

ENO ENAME DN

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

1 Alan 2

2 Ben 2

SQL> exit

[oracle@host01 ~]$ cat emp.dat

1, Alan, 2

3, Curl, 4

4, Bob, 4

[oracle@host01 ~]$ sqlldr u1/oracle TABLE=emp

Which two statements are true?

A.

It overwrites the data for Alan and adds data for Curl and Bob.

B.

It generates a log that contains control file entries, which can be used with normal SQL*Loader operations.

C.

It appends data from EMP.DAT to EMP.

D.

It generates a SQL script that it uses to load data from EMP.DAT to EMP.

E.

It overwrites all data in EMP with data from EMP.DAT.

You have connected to a PDB to perform the administration operations of changing and verifying a system parameter that is PDB_MODIFIABLE. What is the appropriate mode to open the PDB to achieve this?

A.

READ WRITE

B.

RESTRICTED READ ONLY

C.

READ ONLY

D.

RESTRICTED WRITE ONLY

In which two ways would you disable timing information collected for wait events and much of the performance monitoring capability of the database?

A.

By setting the TIMED_STATISTICS system parameter to FALSE.

B.

By executing the PL/SQL procedure DBMS_TIME_STATISTIC.DISABLE(TRUE).

C.

By setting the TIMED_STATISTICS_LEVEL system parameter to FALSE.

D.

By setting the STATISTICS_LEVEL parameter to BASIC.

E.

By executing the PL/SQL procedure DBMS_TIME_STATISTIC.LEVEL(BASIC).

In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION; Which three actions can HR perform?

A.

Execute DML statements in the HR schema.

B.

Log in to the database instance.

C.

Revoke the CREATE SESSION privilege from other users.

D.

Grant the CREATE SESSION privilege with ADMIN OPTION to other users.

E.

Revoke the CREATE SESSION privilege from user HR.

F.

Execute DDL statements in the HR schema.

As the DBA, you execute this command: GRANT CREATE VIEW TO usr1 WITH ADMIN OPTION; USR1 then executes: GRANT CREATE VIEW TO usr2 WITH ADMIN OPTION; USR2 then executes: GRANT CREATE VIEW TO usr3; Which statement is true?

A.

When the DBA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2 but not USR3.

B.

When the DBA revokes the CREATE VIEW privilege from USR2, it is revoked from USR3.

C.

The DBA can revoke only ADMIN OPTION from USR1.

D.

USR1 can revoke the CREATE VIEW privilege from USR3.

E.

When the DBA revokes the CREATE VIEW privilege from USR1, it is neither revoked from USR2 nor USR3.

Which three statements are true about Enterprise Manager Cloud Control?

A.

It is integrated with My Oracle Support.

B.

It provides management for Oracle-engineered systems.

C.

It provides management for Oracle middleware.

D.

It uses a web-based console built into the Oracle database using XML DB.

E.

It is available to manage a database only when that database is open.

Which two AWR-based tools listed below are part of Oracle Database self-tuning components?

A.

Automatic capture of statistical information from the SGA and storing it in the AWR using Automatic Database Diagnostic.

B.

ADDM, a server-based expert that reviews database performance statistics captured by Snapshots to identify potential problems before system performance degrades noticeably.

C.

Automatic Diagnostic Collector used to capture and store database errors and hung analysis.

D.

Automatic population of performance views (V$ views) from statistical data stored in AWR repository and using Automatic Database Diagnostic.

E.

Automatic Application Tracing used to collect High-Load SQL statements and statistics.

You execute this command: [oracle@host01 ~]$ expdp system/oracle FULL=Y DUMPFILE=exp_db_full.dmp PARALLEL=4 LOGFILE=exp_db_full.log JOB_NAME=exp_db_full. During the export operation, you detach from the job by using CTRL+C and then execute this command: Export> STOP_JOB=IMMEDIATE. Are you sure you wish to stop the job ([yes]/no): yes. Which two statements are true about the job?

A.

It continues to run in the background.

B.

You cannot monitor it.

C.

You can reattach to it and monitor it.

D.

It terminates.

Which two are benefits of external tables?

A.

They support DELETEs, which transparently deletes records in the file system as if they were table rows.

B.

They can be queried while the database is in the MOUNT state like dynamic performance views.

C.

They support UPDATEs, which transparently updates records in the file system as if they were table rows.

D.

They can be queried, transformed, and joined with other tables without having to load the data first.

E.

The results of a complex join or aggregating function or both can be unloaded to a file for transportation to other systems.