Index

Page deallocation

Trigger creation

None of the above

Strong Question Language

Structured Query Language

Structured Question Language

None of the Above

TRUNCATE

DELETE

DELETE ALL

REMOVE

SELECT, FROM , WHERE,GROUP BY, ORDER BY, HAVING?

SELECT, FROM, WHERE, ORDER BY, HAVING,GROUP BY

SELECT, FROM, WHERE, ORDER BY, GROUP BY, HAVING

SELECT, FROM , WHERE,GROUP BY, HAVING, ORDER BY

2

4

3

5

ASCENDING

DESCENDING

RANDOM

PHYSICAL

UNION only selects distinct values, UNION ALL selects all values (excluding ?duplicates)?

UNION ALL only selects distinct values, UNION selects all values (including ?duplicates)?

UNION only selects distinct values, UNION ALL selects all values (including ?duplicates)?

UNION ALL only selects distinct values, UNION selects all values (excluding ?duplicates)?

10

1

5

50

WHERE

HAVING

HAVING BY

ORDER BY

Delete

Truncate

Insert

Update

Increase the performance during SELECT operation

Degrade the performance during INSERT operation?

Degrade the performance during the UPDATE or DELETE operation

All of the above

Natural Key

Domain Key

Candidate Key

All of the Above

AMP stores and retrieves data using the file system

AMP parses the SQL to determine the type and validity

AMP sorts and formats the output

AMP environment is a Shared Nothing Architecture

True

False

Perm space can be dynamically modified.

All Perm space specifications are subtracted from the immediate owner or parent.

Perm space currently unused is available to be used as Spool or Temp space.

Perm space is only used for tables and stored procedures.

Volatile Temporary tables and “derived” tables utilize Perm space.

We are using left and right join together

We are joining more than 2 tables

We are joining table to itself

we are joining 2 tables

The AS clause is used with the JOIN clause only.

The AS SQL clause is used change the name of a column in the result set or to assign a name to a derived column.

The AS clause defines a search condition.

The AS clause defines a join

a column list.

a table list.

a list of values.

a range to test in the SQL query search condition.

UNIQUE

DIFFERENT

DISTINCT

DISTINCTIVE

Tranform

Extract

Load

All of the Above