Tag: databases

Any constraints defined on the MGR_ID column would be removed by the above command

Any views created on the EMP table that include the MGR_ID column would have to bve dropped and re-created

Any index created on the MGR_ID column would continue to exists until the DROP UNUSED COLUMNS command is executed.

Any synonym existing on the EMP table would have to be re-created

To find the groups forming the subtotal in a row

To create group-wise totals for the groups specified within a GROUPBY clause

To create grouping for expressions or columns specified within a GROUPBY clause in one direction,from right to left for calculating the subtotals.

To create grouping for expressions or columns specified within a GROUPBY clause in all possible direction,which is cross-tabular report for calculating the subtotals

used to set the order for the groups to be used for calculating the grand totals and subtotals

used to form various groups to caculate totals and subtotals created using ROLLUP and CUBE operators

used to specify if the NULLL value in an expresion is a stored NULL value or created by ROLLUP and CUBE

used to specify the concatenated groups expressions to be used for calculating the grand totals and subtotals

both the DELETE statements would be rolledback

No SQL statements would be rolledback

only the second DELETE statements would be rolledback

both the DELETE statements and the update statements would be rolledback

TYPE

REJECT LIMIT

ACESS PARAMETERS

DEFAULT DIRECTORY

used to find the groups forming the subtotal in a row

used to identify the NULL value in the aggregate function.

use to form the group sets involved in generating the totals and subtotals

only be used with ROLLUP and CUBE operators specified in the GROUP BY clause

4,2,1,3

4,1,2,3

2,4,1,3

2,1,4,3

specify large pct free

specify large pct used

specify large initial & next sizes

specify small initrans

NLS_Language

NLS_Lang

NLS_Sort

NLS_Territory

4

8

12

16