Samacheer Kalvi 12 Data Manipulationa through SQL Questions - 1

Question: 1

Which of the following clause avoid the duplicate?

(A) Distinct

(B) Where

(C) GroupBy

(D) Remove

Ans: A


Question: 2

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

(A) Run( )

(B) Cursor( )

(C) Execute( )

(D) Key( )

Ans: C

Execute( )

Question: 3

The most commonly used statement in SQL is

(A) Select

(B) Cursor

(C) Commit

(D) Execute

Ans: A


Question: 4

Which of the following is an organized collection of data?

(A) Information

(B) Database


(D) Records

Ans: B


Question: 5

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


(B) MAX( )

(C) LARGE( )


Ans: B

MAX( )

Question: 6

Which of the following is called the master table?

(A) sqlmaster

(B) sqlite master

(C) master_main

(D) main_master

Ans: B

sqlite master

Question: 7

Any changes made in the values of the record should be saved by the command

(A) Commit

(B) Oblige

(C) Save

(D) Save As

Ans: A


Question: 8

Which of the following function retrieves the average of a selected column of rows in a table?

(A) AVG( )

(B) Add( )

(C) SUM( )


Ans: A

AVG( )

Question: 9

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

(A) Cursor

(B) Key

(C) Pointer

(D) Insertion point

Ans: A


Question: 10

SQLite falls under which database system?

(A) Relational Database system

(B) Hierarchical database system

(C) Object oriented Database system

(D) Flat file database system

Ans: A

Relational Database system