Tag: databases

True

False

No effect

The index will be rendered invalid

The index will be dropped

The index will contain NULL values.

avg()

sqrt()

max()

sum()

Names starting with “a”

Names with "a" as second character

Last character as "a"

Names with atleast two "a" at the start.

SELECT

WHERE

SEARCH

FIND

DELETE clause

INSERT clause

SELECT clause

JOIN clause

Strong Query Language

Standard Query Language

Strict Query Language

Structured Query Language

The name of the table we are selecting from

list of columns to be selected

Definition of the condition to be met for the rows to be returned

None of above

The primary key column is a column or combination of columns whose values can be non-unique

The primary key is a column or combination of columns whose values uniquely identify each row in the table

The primary key is a column that can have NULL values

all of above

An index is the same as alias

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

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

None of above