Data block headers contain their own Data Block Address (DBA)

A table row piece can be chained across several database blocks

Multiple row pieces from the same row may be stored in different database blocks

Multiple row pieces from the same row may be stored in the same block

Data block free space is always contiguous in the middle of the block

Index block free space is always contiguous in the middle of the block

SELECT NULLIF(NULL, 100) FROM DUAL;

SELECT COALESCE (100, ' AM FROM DUAL;

SELECT 2TOLLIF(100, ' A ' ) FROM DUAL;

SELECT NULLIF(100,100) FROM DUAL;

SELECT COALESCE(100, NULL, 200) FROM DUAL;

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND due_amount IS NOT NULL;

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND cust_credit_level !=NULL;

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level < > NULLAND due_amount < > NULL;

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND due_amount != NULL;

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND cust_credit_limit IS NOT NULL;

two or more instances on separate servers all associated with one database

one instance on one server associated with one database

one instance on one server associated with two or more databases on the same server

one instance on one server not associated with any database

one instance on one server associated with two or more databases on separate servers

It Is held Inside an Oracle database schema.

The ADR base is specified In the diagnostic_dest database parameter.

It is only used for Oracle Database diagnostic information.

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

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

All roles granted to a user are set on by default when the user logs in,

Object privileges may not be granted to roles.

The SET ROLE statement can disable one or more roles for a session.

Roles must be password protected.

Roles may be granted to roles.

The SET ROLE statement can enable one or more roles for a session.

Multiple INTERSECT operators are not possible in the same SQL statement

It processes NULLs in the selected columns

INTERSECT is of lower precedence than UNION or UNION ALL

It ignores NULLs

SELECT NVL(cust_credit_limit * .15, ‘Not Available’) FROM customers;

SELECT NVL2(cust_credit_limit * .15, ‘Not Available’) FROM customers;

SELECT NVL(TO_CHAR(cust_credit_limit * .15), ‘Not Available’) FROM customers;

SELECT TO_CHAR(NVL(cust_credit_limit * .15, ‘Not Available’)) FROM customers;

SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), ‘Not Available’) FROM customers;

COLUMN STORE COMPRESS BASIC

COLUMN STORE COMPRESS ADVANCED

RON STORE COMPRESS BASIC

ROW STORE COMPRESS ADVANCED

SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS DATE, amount + 100 “DUES” FROM transactions;

SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS “DATE”, amount + 100 DUES FROM transactions;

SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 “DUES AMOUNT” FROM transactions;

SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;

SELECT customer_id AS ‘CUSTOMER-ID’, transaction_date AS DATE, amount + 100 ‘DUES AMOUNT’ FROM transactions;