Tag: databases

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

An index is the same as alias.

An index is a special way to join 2 or more tables.

An index is a database table attribute, which speeds-up data search within a table.

None of the above

A view is a special stored procedure executed when certain event occurs.

A view is a database diagram.

A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are

None of the above

UPDATE Persons SET LastName='Hansen' WHERE LastName='Nilsen'

MODIFY Persons SET LastName='Hansen' WHERE LastName='Nilsen'

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

SELECT * FROM Persons WHERE FirstName='%a%'

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName LIKE '%a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'