Which of the following is an organized collection of data?

(a)

Database

(b)

DBMS

(c)

Information

(d)

Records

Which of the following is a control structure used to traverse and fetch the records of the database?

(a)

Pointer

(b)

Key

(c)

Cursor

(d)

Insertion point

Which of the following executes the SQL command to perform some action?

(a)

Execute()

(b)

Key()

(c)

Cursor()

(d)

run()

The function that returns the largest value of the selected column is

(a)

MAX()

(b)

LARGE()

(c)

HIGH()

(d)

MAXIMUM()

The most commonly used statement in SQL is

(a)

cursor

(b)

select

(c)

execute

(d)

commit

Which SQlite method is used to fetch the required number of rows in the database table?

(a)

fetch ( )

(b)

fetchamany ( )

(c)

fetchrows ( )

(d)

tablerows ( )

Which SQlite keyword is used to fetch only the unique value from database table?

(a)

UNIQUE

(b)

DISTINCT

(c)

GROUPBY

(d)

HAVING

In which class the group functions can be used?

(a)

WHERE

(b)

HAVING

(c)

DISTINCT

(d)

GROUP BY

Which of the following operator cannot be used to filter records based on more than one condition?

(a)

AND

(b)

OR

(c)

XOR

(d)

NOT

_________ program can interact as a user of a SQL database.

(a)

C++

(b)

Python

(c)

Java

(d)

C