Question 1

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.

You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.

Examine this SQL statement:

Exhibit 1.

Exhibit 2.

What will be the result?

Options :

A : It gives an error because the ALL keyword is not valid

B : It gives an error because the GROUP BY clause is not valid

C : It executes successfully but does not give the required result

D : It executes successfully and gives the required result

Answer: D

Question 2

Evaluate these commands which execute successfully:

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

Options :

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

Answer: B,C

Question 3

Which two statements are true about single row functions? (Choose two.)

Options :

A : MOD : returns the quotient of a division operation

B : FLOOR : returns the smallest integer greater than or equal to a specified number

C : TRUNC : can be used with NUMBER and DATE values

D : CONCAT : can be used to combine any number of values

E : CEIL : can be used for positive and negative numbers

Answer: A,C

Question 4

Which statement is true about aggregate functions?

Options :

A : Aggregate functions can be nested to any number of levels

B : The AVG function implicitly converts NULLS to zero

C : Aggregate functions can be used in any clause of a SELECT statement

D : The MAX and MIN functions can be used on columns with character data types

Answer: D

Question 5

Which two statements are true about Database Instances and Real Application Clusters (RAC)?

Options :

A : A RAC database can have one Instance.

B : A RAC database can have instances on separate servers.

C : Two RAC databases can share their instances.

D : A RAC database must have three or more Instances.

E : A RAC database must have two or more instances.

Answer: A,B