In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?

• A. to create group-wise grand totals for the groups specified within a GROUP BY clause
• B. to create a grouping for expressions or columns specified within a GROUP BY clause in one direction, from right to left for calculating the subtotals
• C. to find the groups forming the subtotal in a row
• D. to create a grouping for expressions or columns specified within a GROUP BY clause in all possible directions, which is cross-tabular report for calculating the subtotals

You need to create a table for a banking application with the following considerations:
1) You want a column in the table to store the duration of the credit period.
2) The data in the column should be stored in a format such that it can be easily added and
subtracted with 3) date type data without using the conversion functions.
4) The maximum period of the credit provision in the application is 30 days.
5) The interest has to be calculated for the number of days an individual has taken a credit for.
Which data type would you use for such a column in the table?

• A. INTERVAL DAY TO SECOND
• B. INTERVAL YEAR TO MONTH
• C. TIMESTAMP WITH LOCAL TIME ZONE
• D. TIMESTAMP WITH TIME ZONE

Which statement is true regarding the SESSION_PRIVS dictionary view?

• A. It contains the current object privileges available in the user session.
• B. It contains the current system privileges available in the user session.
• C. It contains the system privileges granted to other users by the current user session.
• D. It contains the object privileges granted to other users by the current user session.

Which statement best describes the GROUPING function?

• A. It is used to specify the concatenated group expressions to be used for calculating the grand totals and subtotals.
• B. It is used to set the order for the groups to be used for calculating the grand totals and subtotals.
• C. It is used to identify if the NULL value in an expression is a stored NULL value or created by ROLLUP or CUBE.
• D. It is used to form various groups to calculate total and subtotals created using ROLLUP and CUBE operators.

View the Exhibit and examine the structure of the ORDERS table.
The ORDERS table belongs to the user OE. HR is another user in the database.
Evaluate the commands issued by users OE and HR in the following order:
Statement 1 by user OE: GRANT SELECT,
UPDATE(customer_id, order_total)
ON orders
TOhr;
Statement 1 by user HR: SELECT * FROM oe.orders;
Statement 2 by user HR: UPDATE oe.orders
SET order_totah 10000;
Which statement is true regarding the above commands?

• A. Statement 1 by user HR would not work because SELECT and UPDATE privileges have been granted only on CUSTOMER_ID and ORDER_TOTAL columns.
• B. Statement 1 by user OE would not work because the statement has to be issued by the DB
• C. There are no errors in the statements issued by OE and HR; all the statements would execute successfully.
• D. Statement 2 by user HR would not work because the grant is only for SELECT in a subquery of update.