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.

Views can be updated without the need to re-grant privileges on the view

Tables in the defining query of a view must always exist in order to create the view

The WITH CHECK clause prevents certain rows from being displayed when querying the view

Data Manipulation Language (DML) can always be used on views

Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

The WITH CHECK clause prevents certain rows from being updated or inserted

The generation of UNDO generates REDO

DML modifies Oracle database objects and only generates UNDO

The generation of REDO generates UNDO

DML modifies Oracle database objects and only generates REDO

DML modifies Oracle database objects and generates UNDO and REDO

Employee 100 will have SALARY set to the same value as the SALARY of employee 200

Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100

Employee 200 will have SALARY set to the same value as the SALARY of employee 100

Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

Employees 100 and 200 will have the same JOB_ID as before the update command

Employees 100 and 200 will have the same SALARY as before the update command

SELECT prod_id Il q"'s not available" FROM product_status where status = 'OUT OF STOCK';

SELECT prod_id II q'l's not available)' FROM product_status WHERE status = 'OUT OF STOCK';

SELECT prod_id "CURRENT AVAILABILITY" II q'<'s not available)' FROM product_status WHERE status = 'OUT OF STOCK

SELECT prod_id I I q' (*s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK

SELECT prod_id I I q' ('s not available) • 'CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK

SELECT prod_id q's not available" FROM product_status WHERE status = 'OUT OF STOCK*;

Private Temporary Tables (PTTS) store metadata in memory only

An index created with the UNUSABLE attribute has no segment

If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement

An index that is altered to be UNUSABLE will retain its segment

A table that is truncated will always have its segment removed

PCTFREE defaults to 10% for all blocks in all segments for all compression methods

ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows

Update operations always attempt to find blocks with free space appropriate to the length of the row being updated

Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted

A block will always be eligible for inserts if the row is short enough to fit into the block

ORDER BY “Last Name”

ORDER BY 2, 1

ORDER BY 2, cust_id

ORDER BY CUST_NO

ORDER BY “CUST_NO”

The second rollback command restores the row that was inserted.

The first rollback command leaves the table's 100 original rows locked.

The second rollback command rolls back the rollback to savepoint a command.

The first rollback command leaves the inserted row locked.

The first RollBack command restores the row that was inserted.

The second rollback command restores the 100 rows that were in the table originally.

The first rollback command restores the 100 rows that were in the table originally.

WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25

WHERE ADD_MONTHS

WHERE TO_XUMBER(start_date - SYSDATE) <= 25

WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25

Duplicates are eliminated automatically by the UNION ALL operator

The number of columns selected in each SELECT statement must be identical

The names of columns selected in each SELECT statement must be identical

The output is sorted by the UNION ALL operator

NULLS are not ignored during duplicate checking

It is owned by the sys user.

Data dictionary base tables can be queried directly.

It is owned by the system user.

Data dictionary views are always created with queries that join two or more base tables.

All data dictionary view joins base tables to dynamic performance views.

Revoke the CREATE SESSION privilege from other users

Revoke the CREATE SESSION privilege from user HR

Log in to the database instance

Grant the CREATE SESSION privilege with ADMIN OPTION to other users

Execute DDL statements in the HR schema

Execute DML statements in the HR schema

SELECT REPLACE FROM customers;

SELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;

SELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O'> FROM customers;

SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O*)) FROM customers;

You can use a single instance of EM Express to manage multiple database running on the same server.

EM Express uses a separate repository database to store target database metadata.

By default, EM express is available for a database after database creation using DBCA.

You can shut down a database instance using EM Express.

You cannot start up a database instance using EM Express.

T1, an index segment for the primary key, a LOB segment, and a lobindex segment

no segments are created

T1 only

T1 and an index segment created for the primary key only

T1, an index segment for the primary key, and a LOB segment only

The ON clause must be used

The query must use two different aliases for the table

It must be an equijoin

It must be an inner join

The ON clause can be used

It can be an outer join

PRODUCT _ic can be assigned the PRIMARY KEY constraint.

PRODUCT _price contains the value zero by default if no value is assigned to it.

PRODUCT _price can be used in an arithmetic expression even if it has no value stored in it.

EXPIRY_ DATE contains the sysdate by default if no date is assigned to it.

PRODUCT_NAKE cannot contain duplicate values.

EXPIRY_ DATE cannot be used in arithmetic expressions.