Tag: databases

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