A.  

The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.

B.  

The number, but not names, of columns must be identical for all SELECT statements in the query.

C.  

The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.

D.  

The names and number of columns must be identical for all SELECT statements in the query.

E.  

The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

A.  

Dynamic service registration cannot be used for this database instance

B.  

The LREG process registers services dynamically with the LISTENER_1 listener

C.  

LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

D.  

There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances

E.  

The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

A.  

Private Temporary Tables (PTTS) store metadata in memory only

B.  

An index created with the UNUSABLE attribute has no segment

C.  

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

D.  

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

E.  

A table that is truncated will always have its segment removed

A.  

ORDER BY “Last Name”

B.  

ORDER BY 2, 1

C.  

ORDER BY 2, cust_id

D.  

ORDER BY CUST_NO

E.  

ORDER BY “CUST_NO”

A.  

A UNIQUE index can be altered to be non-unique

B.  

A SELECT statement can access one or more indices without accessing any tables

C.  

A table belonging to one user can have an index that belongs to a different user

D.  

An update to a table can result in updates to any or all of the table’s indexes

E.  

When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped

F.  

An update to a table can result in no updates to any of the table’s indexes

A.  

UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.

B.  

UNDO_RETENTION specifies how long all types of UNDO are retained.

C.  

Unexpired UNDO is always retained.

D.  

Active UNDO is always retained.

E.  

UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

A.  

Table aliases can improve performance

B.  

The BETWEEN condition always performs better than using the >= and <= conditions

C.  

The join syntax used makes no difference to performance

D.  

The BETWEEN condition always performs less well than using the >= and <= conditions

E.  

The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

A.  

It overwrites data in EMP with data in EMP.DAT

B.  

It uses the database buffer cache to load data

C.  

It generates a log that contains control file entries, which can be used with normal SQL*Loader operations

D.  

It generates a sql script that it uses to load data from EMP.DAT to EMP

E.  

It appends data from EMP.DAT to EMP

A.  

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

B.  

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

C.  

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

D.  

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

E.  

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

F.  

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

A.  

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

B.  

It frees resources held by abnormally terminated processes

C.  

It records checkpoint information in the control file

D.  

It frees unused temporary segments

E.  

It kills sessions that exceed idle time

A.  

dump files

B.  

control files

C.  

password files

D.  

bad files

E.  

input files

A.  

It is available only when the database is open

B.  

It can be used to perform database recovery

C.  

The same port number can be used for Database Express configurations for databases on different hosts

D.  

It can be used to switch a database into ARCHIVELOGMODE

E.  

The same port number can be used for multiple Database Express configurations for multiple databases on the same host

A.  

CONCAT (qty_sold, invoice_date) : requires explicit conversion

B.  

invoice_date = ’15-march-2019’ : uses implicit conversion

C.  

invoie_date > ’01-02-2019’ : uses implicit conversion

D.  

qty_sold BETWEEN ‘101’ AND ’110’ : uses implicit conversion

E.  

qty_sold = ‘0554982’ uses implicit conversion

A.  

SELECT * FROM customers WHERE city LIKE ‘D_%’;

B.  

SELECT * FROM customers WHERE city = ‘%D_’;

C.  

SELECT * FROM customers WHERE city LIKE ‘D_’;

D.  

SELECT * FROM customers WHERE city = ‘D_%’;