Tag: technology

True

False

True

False

Column

1966_Invoices

Catch_#22

#Invoices

None of the above

the process of arranging information stored in a database in a way, which removes redundancy and ambiguity.

a special way of selecting data

the process of adding primary key to a table

All the above

a special type of store procedure, executed when certain event occurs

a special type of table

a special type of view

All the above

SELECT * FROM Contest WHERE ContestDate < '05/25/2006'

SELECT * FROM Contest HAVING ContestDate >= '05/25/2006'

SELECT * FROM Contest WHERE ContestDate >= '05/25/2006'

none of the above

we are joining more than 2 tables

we are joining table to itself

we are using left and right join together

none of the above

>=

Neither of the other two.

=>

!>=

The HAVING keyword specifies a search condition for an aggregate or a group

The HAVING keyword is used to select distinct values

The HAVING keyword is used to join 2 or more tables.

None of the above

The JOIN SQL clause.

List of columns that will be selected or the * symbol.

The name of the table we are selecting from.

None of the above