Oracle 1Z0-071 Quiz 52 Topic 9 Questions 256-260

Question: 1

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

GRANT ALL

ON orders, order_items

TO PUBLIC;

What must be done to fix the 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 the ORDERS and ORDER_ITEMS tables.

Show Answer

Question: 2

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 must 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? (Choose two.)

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

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

q3_1Z0-071

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

Question: 4

Which two statements are true regarding the GROUP BY clause in a SQL statement? (Choose two.)

AYou can use column alias in the GROUP BY clause.

BUsing the WHERE clause after the GROUP BY clause excludes the rows after creating groups.

CThe GROUP BY clause is mandatory if you are using an aggregate function in the SELECT clause.

DUsing the WHERE clause before the GROUP BY clause excludes the rows before creating groups.

EIf the SELECT clause has an aggregate function, then those individual columns without an aggregate function in the SELECT clause should be included in the GROUP BY cause.

Show Answer

Question: 5

Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS tables:

q5_1Z0-071

You want to generate a list of all department IDs along with any course IDs that may have been assigned to them.

Which SQL statement must you use?

ASELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON (d.department_id=c.department_id);

BSELECT d.department_id, c.course_id FROM department_details d LEFT OUTER JOIN course_details c ON (d.department_id=c.department_id);

CSELECT d.department_id, c.course_id FROM course_details c LEFT OUTER JOIN department_details d ON (c.department_id=d.department_id);

DSELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON (c.department_id=d.department_id);

Show Answer

Oracle 1Z0-071 Quiz:52 Topic:9 Questions:256-260