Oracle 1Z0-071 Quiz 13 Topic 13 Questions 61-65

Question: 1

Which two are true about granting privileges on objects?

AAn object privilege can be granted to other users only by the owner of that object.

BAn object privilege can be granted to a role only by the owner of that object.

CA table owner must grant the REFERENCES privilege to allow other users to create FOREIGN KEY constraints using that table.

DThe owner of an object acquires all object privileges on that object by default.

EThe WITH GRANT OPTION clause can be used only by DBA users.

Show Answer

Question: 2

In the PROMOTIONS table, the PROMO_BEGIN_DATE column is of data type DATE and the default date format is DD-MON-RR.

Which two statements are true about expressions using PROMO_BEGIN_DATE contained a query?

APROMO_BEGIN_DATE -- 5 will return a date.

BPROMO_BEGIN_DATE -- SYSDATE will return a number.

CTO_NUMBER(PROMO_BEGIN_DATE) -- 5 will return a number.

DTO_DATE(PROMO_BEGIN_DATE * 5) will return a date.

EPROMO_BEGIN_DATE -- SYSDATE will return an error.

Show Answer

Question: 3

Examine the description of the BOOKS table:

q3_1Z0-071

The table has 100 rows.

Examine this sequence of statements issued in a new session:

q3_1Z0-071

Which two statements are true?

AThe first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed.

BThe second ROLLBACK command replays the delete.

CThe first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row.

DThe second ROLLBACK command undoes the insert.

EThe second ROLLBACK command does nothing.

Show Answer

Question: 4

Examine this query:

q4_1Z0-071

Which two methods should you use to prevent prompting for a hire date value when this query is executed?

AReplace '&1' with '&&1' in the query.

BUse the DEFINE command before executing the query.

CUse the UNDEFINE command before executing the query.

DExecute the SET VERIFY ON command before executing the query.

EStore the query in a script and pass the substitution value to the script when executing it.

FExecute the SET VERIFY OFF command before executing the query.

Show Answer

Question: 5

You execute this command:

q5_1Z0-071

Which two are true?

AIt drops any triggers defined on the table.

BIt always retains the space used by the removed rows.

CA ROLLBACK statement can be used to retrieve the deleted data.

DIt retains the integrity constraints defined on the table.

EIt retains the indexes defined on the table.

FA FLASHBACK TABLE statement can be used to retrieve the deleted data.

Show Answer

Oracle 1Z0-071 Quiz:13 Topic:13 Questions:61-65