Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.

The variables used in your query are never undefined in your session.

Which query can be used?

A.

SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;

B.

SELECT &col1, &col2FROM &&tableWHERE &condition;

C.

SELECT &col1, &col2FROM “&table”WHERE &condition;

D.

SELECT ‘&&col1’, ‘&&col2’FROM &tableWHERE ‘&&condition’ = ‘&cond’;

E.

SELECT &&col1, &&col2FROM &tableWHERE &&condition;

Examine this command and some partial output:

Why does the DB01.abc.com service show unknown status?

A.

The service DB01.abc.com is dynamically registered

B.

The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1

C.

The service DB01.abc.com is statically registered

D.

The listener is not listening on the default port 1521

E.

The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

A.

A table can have only one primary key but multiple foreign keys

B.

A table can have only one primary key and one foreign key

C.

The foreign key columns and parent table primary key columns must have the same names

D.

It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted

E.

It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted

F.

Only the primary key can be defined at the column and table level

G.

Primary key and foreign key constraints can be defined at both the column and table level

Which two actions can you perform using DBCA for an existing database?

A.

Create a template that can be used to clone the database.

B.

Change the server mode from dedicated to shared, and vice versa.

C.

Change the character set.

D.

Create an additional listener.

E.

Create nonstandard block size tablespaces.

Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

A.

If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS

B.

Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ

C.

Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO

D.

Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

E.

Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

Which two statements are true about the PMON background process? (Choose two.)

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

Which three are types of segments in an Oracle Database? (Choose three.)

A.

undo

B.

index

C.

stored procedures

D.

sequences

E.

tables

F.

clusters

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.

The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

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

Which two statements are true about substitution variables?

A.

A substitution variable prefixed with & always prompts only once for a value in a session.

B.

A substitution variable prefixed with to prompts only once for a value in a session unless it is set to undefined in the session

C.

A substitution variable can be used only in a select statement.

D.

A substitution variable used to prompt for a column name must be enclosed in single quotation marks.

E.

A substitution variable can be used with any clause in a select statement.

F.

A substitution variable used to prompt for a column name must be enclosed in double quotation marks.

Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER.

Examine these SQL statements:

Statement 1:

SELECT MAX(unit_price * quantity) “Maximum Order”

FROM order_items;

Statement 2:

SELECT MAX(unit_price * quantity) “Maximum Order”

FROM order_items

GROUP BY order_id;

Which two statements are true?

A.

Statement 1 returns only one row of output.

B.

Statement 2 returns only one row of output.

C.

Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.

D.

Both the statements give the same output.

E.

Statement 2 may return multiple rows of output.