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

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

All of above

XML data types

Table value parameters

Transactions

none of these

online transfer processing

online transfer process

online transaction processing

online train processing

informatica, businessobjects,cognos

datastage,hyperion,oracle builder

informatica,datastage,abinitio

abinitio,oraclebuilder,microstrategy

slow change dimension

slowly change direction

Slowly changing dimension

slow chance direction

slow change dimension

slowly change direction

Slowly changing dimension

slow chance direction

slow change dimension

slowly change direction

Slowly changing dimension

slow chance direction

SQL Server Integrated Server

SQL Server Integration Services

SQL Server Information Server

SQL Server Information Service

Relational

Network

Hierarchical

None of the above

Data Item

Database Key

Record Occurence

Record Structure

True

False

None

Record

Record Structure

Record Occurence