Tag: technology

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

delete data from database table.

select data from 2 or more tables related by common attribute (table column).

verify that the inserted data is correct.

update database table.

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%'

SELECT * FROM Persons WHERE FirstName='Peter',LastName='Jackson'

SELECT * FROM Persons WHERE FirstName='Peter' OR LastName='Jackson'

SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons SORT BY 'FirstName' DESC

SELECT * FROM Persons SORT 'FirstName' DESC

SELECT * FROM Persons ORDER FirstName DESC

SELECT DIFFERENT

SELECT DISTINCT

SELECT COUNT

SELECT UNIQUE

you save and close the file

you save excel in XML format

you create an excel template

you save it in Excel 2007 version

An entire column gets selected in MS Excel

The entire worksheet gets selected in MS Excel

An entire row gets selected in MS Excel

Nothing happens