4000

8000

32768

32767

SELECT FROM GROUP BY WHERE

SELECT FROM GROUP BY ROLLUP

SELECT GROUP BY FROM

SELECT WHERE FROM GROUP BY

True

False

ROLLUP

COUNT

AVG

SUM

ON DELETE SET NULL

ON DELETE CASCADE

ON DELETE DELETE

ON DELETE RESTRICT

True

False

SUBSTR

CON_STR

CON_CAT

WM_CONCAT

Restricts the length of the String

Replaces a sequence of characters in a string with another set of characters

Modifies the datatype of a column

Renames a column

WHEN

HAVING

WHERE

ANY

Replaces word by word

Replaces a column with another column

Replaces character by character

Replaces a row with another row

IN executes the inner query for each row affected by the outer query and EXISTS executes the inner query only once irrespective of the outer query

IN executes the inner query only once irrespective of the outer query and EXISTS executes the inner query only once irrespective of the outer query

IN executes the inner query only once irrespective of the outer query and EXISTS executes the outer query for each row affected by the outer query

IN executes the inner query for each row affected by the outer query and EXISTS executes the outer query for each row affected by the outer query

AMP bucket number

Primary Index

Primary Key

None of the above

Defined immediately after the table CREATE statement, used to find the Primary Key

Defined during the table CREATE statement, used to assign rows to an AMP

Defined immediately after the table CREATE statement, used to assign rows to an AMP

Defined during the table CREATE statement, used to find the Primary Key

Defined immediately after the table CREATE statement, used to assign rows to an AMP

Defined immediately after the table CREATE statement, used to find the Primary Key

Defined during the table CREATE statement, used to assign rows to an AMP

Defined during the table CREATE statement, used to find the Primary Key

Error

1

No data Found

0

select '''||'TCS'||''' from dual

select 'TCS' from dual

select '''TCS''' from dual

select "TCS" from dual

2009-may-25

Error

may-2009-25

200925may

select '''||'TCS ||''' from dual

select '''TCS''' from dual

select "TCS" from dual

select 'TCS' from dual

AMP

PE

BYNET

CLIQUE

Nothing

Everything

Disk

Processor