QUESTION: 45

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?

PUBLIC should be replaced with specific usernames.
ALL should be replaced with a list of specific privileges.
WITH GRANT OPTION should be added to the statement.
Separate GRANT statements are required for the ORDERS and ORDER_ITEMS tables.

Answer(s): D

Reference:

http://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqljgrant.html

Show Answer Next Question

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.)

The EXECUTION_DATETIME must be of INTERVAL DAY TO SECOND data type.
The EXECUTION_DATETIME must be of TIMESTAMP data type.
The EXECUTION_DATETIME must be of DATE data type.
The COMPONENT_ID must be of ROWID data type.
The COMPONENT_ID must be of VARCHAR2 data type.
The COMPONENT_ID column must be of CHAR data type.

Answer(s): C,F

Show Answer Next Question

QUESTION: 47

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

What is the outcome?

In generates an error because rrrr should be replaced by rr in the format string.
It executes successfully but does not return the correct result.
It executes successfully and returns the correct result.
In generates an error because TO_CHAR should be replaced with TO_DATE.
In generates an error because fm and double quotation marks should not be used in the format string.

Answer(s): C

Show Answer Next Question

QUESTION: 48

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

You can use column alias in the GROUP BY clause.
Using the WHERE clause after the GROUP BY clause excludes the rows after creating groups.
The GROUP BY clause is mandatory if you are using an aggregate function in the SELECT clause.
Using the WHERE clause before the GROUP BY clause excludes the rows before creating groups.
If 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.

Answer(s): D,E

Show Answer Next Question

Free Oracle 1Z0-071 Exam Braindumps (page: 13)

QUESTION: 45

Reference:

QUESTION: 46

QUESTION: 47

QUESTION: 48

1Z0-071 Exam Discussions & Posts