Using a view to access the table

Using a referential constraint on the table

Revoking access from the phone_number column

Defining a table check constraint on the table

ON DELETE RESTRICT

ON DELETE CASCADE

ON DELETE SET NULL

ON DELETE CHILD

ON DELETE MATCH

forces cursor to close after commit

Keeps cursor open after commit

Does not allow cursor to close till all rows are fetched

Locks the cursor

None of the above

Normalization

Indexing

Sequence

Join

Substitute( )

Place value ( )

NVL ( )

Place( )

EQUI-JOIN

NON EQUI-JOIN

Both A. and B.

None of the Above

Clusters

Synonym

Views

Sequences

100 rows

50 rows

150 rows

5000 rows

ALTER TABLE command is used to create a table

ALTER TABLE command is used to change the column elements in a table

ALTER TABLE command is used to delete a table

Both A. and C.

Unique constraints

Primary keys

Cascading actions

Foreign keys

Cursors

Host Variables

Indicator Variable

SQLCA

Control file

Redo Logfile and datafile

Database

Current SCN Number

All of the above

It is the point at which ORACLE starts writing to one online redo log file and begins writing to another at same time

It is the point at which ORACLE ends writing to one online redo log file and begins writing to another

It is the point at which ORACLE starts writing to one online redo log file and ends writing to another

It is the point at which ORACLE ends writing to one online redo log file and starts writing to another

Database Buffer Cache

Redo Log Buffer

Shared Pool

PGA

To access the HR user account, the account should be unlocked first

All accounts created by the Database Creation Assistant are locked

The SYS and SYSTEM accounts use the same default password as in previous Oracle versions

All accounts created by the Database Creation Assistant initially have expired passwords

The related columns of the tables are called the cluster key. The cluster key is indexed using a cluster index and its value is stored only once for multiple tables in the cluster.

The related columns of the tables are called the cluster key. The cluster key is indexed using a b+ tree index and its value is stored only once for multiple tables in the cluster.

The related columns of the tables are called the cluster key. The cluster key is indexed using a bitmap index and its value is stored only once for multiple tables in the cluster.

The related columns of the tables are called the cluster key. The cluster key is indexed using a range index and its value is stored only once for multiple tables in the cluster.

It is the auditing of the use of normal system privileges with regard to specifically named objects

It is the auditing of the use of powerful system privileges without regard to specifically named objects

It is the auditing of the use of powerful system privileges with regard to specifically named objects

None of these

Two-phase commit is mechanism that guarantees a distributed transaction that always commits on all involved nodes to maintain data consistency across the global distributed database.

Two-phase commit is mechanism that guarantees a distributed transaction either commits on all involved nodes or rolls back on all involved nodes to maintain data consistency across the global distributed database. It has two phase, a Prepare Phase and a C

Two-phase commit is mechanism that guarantees a distributed transaction that always rollback on all involved nodes to maintain data consistency across the global distributed database.

Two-phase commit is mechanism that guarantees a distributed transaction that always commit on all involved nodes to maintain data consistency across the global heirarchical database.

Heterogeneous Services

Oracle Connection Manager

Dynamic Service Registration

Oracle Names Server

Inline

Simple

Complex

Nested