Oracle 1Z0-071 Quiz 76 Topic 16 Questions 376-380

Question: 1

Which three statements are true about the ALTER TABLE....DROP COLUMN.... command?

AA column can be dropped only if it does not contain any data.

BA column can be dropped only if another column exists in the table.

CA dropped column can be rolled back.

DThe column in a composite PRIMARY KEY with the CASCADE option can be dropped.

EA parent key column in the table cannot be dropped.

Show Answer

Question: 2

Which three tasks can be performed using SQL functions built into Oracle Database?

Adisplaying a date in a nondefault format

Bfinding the number of characters in an expression

Csubstituting a character string in a text expression with a specified string

Dcombining more than two columns or expressions into a single column in the output

Show Answer

Question: 3

The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues the following GRANT command:

GRANT ALL

ON orders, order_items

TO PUBLIC;

What correction needs to be done to the above statement?

APUBLIC should be replaced with specific usernames.

BALL should be replaced with a list of specific privileges.

CWITH GRANT OPTION should be added to the statement.

DSeparate GRANT statements are required for ORDERS and ORDER_ITEMS tables.

Show Answer

Question: 4

You are designing the structure of a table in which two columns have the specifications:

COMPONENT_ID -- must be able to contain a maximum of 12 alphanumeric characters and uniquely identify the row

EXECUTION_DATETIME -- contains Century, Year, Month, Day, Hour, Minute, Second to the maximum precision and is used for calculations and comparisons between components.

Which two options define the data types that satisfy these requirements most efficiently?

AThe EXECUTION_DATETIME must be of INTERVAL DAY TO SECOND data type.

BThe EXECUTION_DATETIME must be of TIMESTAMP data type.

CThe EXECUTION_DATETIME must be of DATE data type.

DThe COMPONENT_ID must be of ROWID data type.

EThe COMPONENT_ID must be of VARCHAR2 data type.

FThe COMPONENT_ID column must be of CHAR data type.

Show Answer

Question: 5

You want to display the date for the first Monday of the next month and issue the following command:

SQL>SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'),

'dd "is the first Monday for" fmmonth rrrr')

FROM DUAL;

What is the outcome?

AIn generates an error because rrrr should be replaced by rr in the format string.

BIt executes successfully but does not return the correct result.

CIt executes successfully and returns the correct result.

DIn generates an error because TO_CHAR should be replaced with TO_DATE.

EIn generates an error because fm and double quotation marks should not be used in the format string.

Show Answer

Oracle 1Z0-071 Quiz:76 Topic:16 Questions:376-380