XII CS EM ONLINE TEST

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

XII CS EM ONLINE TEST - 15

15.DATA MANIPULATION THROUGH SQL

one mark questions :

Prepared by S. Saminathan , GHSS - MUKHASAPARUR,CUDDALORE DT

https://sites.google.com/view/tn-computer-science/home

Name *

School *

GHSS MUKHASAPARUR

OTHERS

1. Which of the following is an organized collection of data? *

1 point

Information

DBMS

Database

Records

2. SQLite falls under which database system? *

1 point

lat file database system

Object oriented Database system

Relational Database system

Hierarchical database system

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

1 point

Key

Pointer

Insertion point

cursor

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

1 point

commit

save

save as

Oblige

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

1 point

run( )

execute( )

cursor( )

key( )

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

1 point

AVERAGE( )

AVG( )

SUM( )

ADD( )

7. The function that returns the largest value of the selected column is *

1 point

MAX( )

MAXIMUM( )

HIGH( )

LARGE( )

8. Which of the following is called the master table? *

1 point

sqlite_master

master_main

sql_master

main_master

9. The most commonly used statement in SQL is *

1 point

cursor

commit

execute

select

10.which of the following is clause avoid the duplicate? *

1 point

Where

Remove

Distinct

group by

Submit

Clear form

Never submit passwords through Google Forms.

This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy

Forms