Indexes

__________are used to retrieve data from the

database more quickly than otherwise

• Implicit

• Index

• Roll Back

• Auto Commit

SQL Server supports the following types of indexes

• Clustered

• Implicit

• Non-Clustered

• Explicit

Indexes can be deleted

• TRUE

• FALSE

A sports club needs to store information about each member. The all the information about each member is called a:

• Field

• File

• Table

• Record

What is a database?

• A piece of software to do calculations

• A device to load information onto the computer.

• A structured collection of records

• A calculator

The best data type to choose for date of birth would be

• Number

• Date/Time

• Text

• Currency

The software that we use to create a database is

• Microsoft Publisher

• Microsoft Word

• Microsoft Excel

• Microsoft Access

In a TABLE, a row is known as a...

• Information

• Column

• Data

• Record

What is a query?

• Table

• Question

• Spreadsheet

• Report

How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

• UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

• MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

• MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

• UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’