9 Database Quiz

A collection of related records in a table is called

• Query

• Database

• Records

• Fields

An SQL command that specifies fields(columns) from a table

• ORDER BY

• FROM

• SELECT

• WHERE

An SQL command to include only those records(rows) in a query that match a given condition

• WHERE

• SELECT

• FROM

• ORDER BY

An SQL command that identifies the table to use

• ORDER BY

• WHERE

• FROM

• SELECT

A field in a database that uniquely identifies a record

• Secondary key

• Encryption key

• Main Key

• Primary key

An SQL command that returns the sum of all the values in a field (column)

• COUNT

• SUM

• ANG

• ORDER BY

An SQL statement must end with the following symbol

• +

• =

• %

• ;

Identify the mistake in the given SQL query:

SELECT ID

FROM StudentTable

WHERE StudentName=Sana ;

• Spelling mistakes in the querry

• The querry must end with a full stop sign

• Name of the student must be enclosed in single quotation marks

• Name of the student must be enclosed in double quotation marks

Each records in a database table has the same number of fields

• True

• False

It is possible for a database table to have no field that can be choosen as primary key.

• No

• Yes

• May be