Tag: databases

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