최신Oracle Database 12c Essentials - 1z1-497무료샘플문제

A. It can perform actions outside the database.

B. It is not supported on Standard Edition (SE) and Express Edition (XE).

C. It has two new features: Performance Hub and Composite Active Reports.

D. It uses internal infrastructure components, such as XDB and SQL*Net.

E. It has background tasks and processes that periodically collect information via FTP.

A. It uses the PREPROCESSOR feature, which allows users to preprocess input data before it is sent to the access drivers.

B. It works in an Oracle database instance that is mounted. Therefore, it works in ASM instances and DG instances.

C. DBMS_QOPATCH provides a PL/SQL or SQL interface to view the database patches installed.

D. It is used to retrieve installed patch information from a SQL prompt.

A. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

B. DBMS_DATAPUMP PL/SQL packages can be used independently of Data Pump clients.

C. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

D. EXPDP and IMPDP are the client components of Oracle Data Pump.

E. Oracle Data Pump imports can be done from the export files generated in Original Export Release 9.x.

A. Real-Time ADDM uses AWR snapshots of the last 10 minutes.

B. Real-Time ADDM uses ASH recent activity from SGA data.

C. Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.

D. Regular ADDM uses AWR snapshots that are not yet purged.

A. Oracle Real Application Clusters

B. Oracle GoldenGate

C. Oracle Transportable Tablespaces

D. Oracle Cloud Platform as a Service

E. Active Data Guard

A. rewrite its SQL queries

B. recompile it

C. rework the applications schema

D. relink

E. nothing; it is transparent

A. SQL> conn c##usr/pwd@pdb2
You are connected to PDB2 successfully.

B. SQL> conn c##usr/pwd@pdb1
You are connected to PDB1 successfully.

C. SQL> conn c##usr/pwd@pdb2
You are unable to create a connection. You first need to sync PDB2 by executing:
SQL> conn / as sysdba
SQL>exec DBMS_PDB.SYNC_PDB;

D. SQL> conn c##usr/pwd@pdb2
You are unable to create a connection. You need to create the common user c# #usr explicitly in
PDB2 by executing:
SQL>conn system/pwd@pdb2
SQL> CREATE USER c##usrIDENTIFIED BYpwd CONTAINER=CURRENT;
Now you are able to connect as common user c##usr to PDB2.