12-STD CS : CH-15-DATA MANIPULATION THROUGH SQL

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

Created By K.RAJA- SILVER JUBILEE MATRIC. SCHOOL- MAYILADUTHURAI

The most commonly used statement in SQL is

1 point

CURSOR

SELECT

EXECUTE

COMMIT

Clear selection

NAME *

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

1 point

ADD

SUM

AVG

AVERAGE

Clear selection

CLASS *

Which of the following is called the master table?

1 point

SQLITE_MASTER

SQL_MASTER

MAIN_MASTER

MASTER_MAIN

Clear selection

SQLite falls under which database system?

1 point

Flat file Database

Realational Database

Hierarchical database

Object oriented Database

Clear selection

SCHOOL

SILVER JUBILEE

OTHERS

Clear selection

Which of the following keyword avoid the duplicate?

1 point

DISTINCT

REMOVE

WHERE

GROUPBY

Clear selection

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

1 point

MAX

HIGH

MAXIMUM

LARGE

Clear selection

Which of the following is an organized collection of data?

1 point

Database

DBMS

Information

Record

Clear selection

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

1 point

Pointer

Key

Cursor

Insertion Point

Clear selection

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

1 point

Save

Save As

Commit

Oblige

Clear selection

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

1 point

execute ( )

key( )

cursor( )

run( )

Clear selection

Submit

Clear form

Never submit passwords through Google Forms.

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

Does this form look suspicious? Report

Forms