Oracle 1Z0-071 Quiz 10 Topic 17 Questions 46-50

Question: 1

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

ACEIL: can be used for positive and negative numbers

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

CTRUNC: can be used with NUMBER and DATE values

DCONCAT: can be used to combine any number of values

EMOD: returns the quotient of a division operation

Show Answer

Question: 2

Which three statements are true about sequences in a single instance Oracle database? (Choose three.)

AA sequence can issue duplicate values

BA sequence's unallocated cached value are lost if the instance shuts down

CSequences can always have gaps

DTwo or more tables cannot have keys generated from the same sequence

EA sequence can only be dropped by a DBA

FA sequence number that was allocated can be rolled back if a transaction fails

Show Answer

Question: 3

Examine this statement:

q3_1Z0-071

What is returned upon execution?

A1 row

Ban error

C0 rows

D2 rows

Show Answer

Question: 4

Which three are true about system and object privileges? (Choose three.)

AWITH GRANT OPTION can be used when granting an object privilege to both users and roles

BAdding a primary key constraint to an existing table in another schema requires a system privilege

CAdding a foreign key constraint pointing to a table in another schema requires the REFERENCES object privilege

DRevoking a system privilege that was granted with WITH ADMIN OPTION has a cascading effect

ERevoking an object privilege that was granted with the WITH GRANT OPTION clause has a cascading effect.

FWITH GRANT OPTION cannot be used when granting an object privilege to PUBLIC

Show Answer

Question: 5

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 statements:

q5_1Z0-071

What will be the result?

Exhibit 1.

q5_1Z0-071

Exhibit 2.

q5_1Z0-071

AIt gives an error because the GROUP BY clause is not valid

BIt executes successfully but does not give the required result

CIt executes successfully and gives the required result

DIt gives an error because the ALL keyword is not valid

Show Answer

Oracle 1Z0-071 Quiz:10 Topic:17 Questions:46-50