先試後買

A. It is held inside an Oracle database schema

B. It supports diagnostics for Oracle Clusterware

C. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set

D. It supports diagnostics for Automatic Storage Management (ASM)

E. The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set

A. analysis of privileges that a user has on their own schema objects that they did not use

B. analysis of all privileges used by all users including administrative users in the database

C. analysis of privileges granted directly to a role that are then used by a user who has been granted that role

D. analysis of all privileges used by all users but excluding administrative users in the database

E. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

F. analysis of privileges that a user has on their own schema objects that they did use

A. A full outer join must use Oracle syntax

B. A left or right outer join returns only unmatched rows

C. An inner join returns matched rows

D. Outer joins can be used when there are multiple join conditions on two tables

E. Outer joins can only be used between two tables per query

F. A full outer join returns matched and unmatched rows

A. temporary tables

B. clustered tables

C. heap organized tables

D. index organized tables

E. external tables

F. partitioned tables

A. A connection string must include the SID of a database Instance.

B. A connection string including a service name must be defined in the cnsnames.ora file.

C. A single database instance can support connections for multiple service names.

D. A service name is created by a listener.

E. A single connection string can refer to multiple database instances.

F. Different connection strings in the same tnsnames.ora file can contain the same service name, host and port parameters.

A. It Is held Inside an Oracle database schema.

B. It is a file-based repository held outside any database.

C. It can be used for problem diagnosis of a database when that database's instance is down.

D. The ADR base is specified In the diagnostic_dest database parameter.

E. It is only used for Oracle Database diagnostic information.

A. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;

B. SELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available')) FROM customers;

C. SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;

D. SELECT NVL(cust_credit_limit * .15, `Not Available') FROM customers;

E. SELECT NVL2(cust_credit_limit * .15, `Not Available') FROM customers;

A. It registers database services with all local and remote listeners known to the database instance

B. It kills sessions that exceed idle time

C. It frees resources held by abnormally terminated processes

D. It frees unused temporary segments

E. It records checkpoint information in the control file

A. COLUMN STORE COMPRESS BASIC

B. COLUMN STORE COMPRESS ADVANCED

C. ROW STORE COMPRESS ADVANCED

D. RON STORE COMPRESS BASIC

A. The CURRENT_TIMESTAMP function returns data without time zone information

B. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

C. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

D. A TIMESTAMP data type column contains information about year, month, and day

E. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row