先試後買

A. It is created for the SALES database in the network domain ACME on the SALESDATA server.

B. It generates an error because the server configuration mode (dedicated or shared) is not specified.

C. It generates an error because the connect identifier name cannot be a part of SERVICE_NAME.

D. It is created for the SALESDATA database on the SALES server in the network domain called ACME.

A. Oracle Enterprise Manager Cloud Control

B. Oracle Data Guard Broker Manager

C. Oracle Data Guard command-line interface (DGMGRL)

D. Oracle Data Guard monitor

A. maxdatafiles

B. control_files

C. instance_name

D. db_name

A. Rows with a NULL value in key columns also have entries in the Index.

B. The deletion of a row from the table causes a logical deletion in the index leaf block and the space becomes available for a new leaf entry.

C. The leaf blocks in the index are doubly linked.

D. The leaf node stores a bitmap for each key value.

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

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

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

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

A. There is a set of redo log files per PDB.

B. There is one SYSAUXtablespace per PDB.

C. There is only one SYSTEM tablespace per CDB.

D. There is only one instance per PD

E. There is only one UNDO tablespace per CDB.

A. It uses the random redaction method.

B. It replaces the first four digits of the value from the SALARY column with the number 9.

C. It replaces the first nine digits of the value from the COMMISSION_PCTcolumn with 1.

D. It replaces the first digit of the value from the SALARY column with the number 4.

E. It uses the full data redaction method.

F. It replaces the first digit of the value from the COMMISSION_PCTcolumn with 9.

A. FULL

B. REMAP_TABLESPACE

C. TRANSFORM

D. REMAP_SCHEMA

E. SCHEMAS

A. create role l_hr container=all;

B. create role c##_hr container=current;

C. create local role l_hr;

D. create role l_hr container=current;

A. clustered file system

B. OS file system

C. logical volume (LVM)

D. Automatic Storage Management (ASM)

E. RAW