TN Online TestSamacheer Kalvi practice

12th Standard Computer Science — Data manipulation through SQL: Book Back Online Practice Test

Pick how many questions you want and set a time limit, then start. You'll get your score at the end with the correct answer and an explanation for every question. Free, in Tamil and English — 10 questions available.

Set up your test

Number of questions

Time limit

Time remaining00:00

Which of the following is an organized collection of data?

A.Database B.DBMS C.Information D.Records

SQLite falls under which database system?

A.Flat file database system B.Relational Database system C.Hierarchical database system D.Object oriented Database system

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

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

A.Save B.Save As C.Commit D.Oblige

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

A.execute() B.key() C.cursor() D.run()

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

A.Add() B.SUM() C.AVG() D.AVERAGE()

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

A.MAX() B.LARGE() C.HIGH() D.MAXIMUM()

Which of the following is called the master table?

A.sqlite_master B.sql_master C.main_master D.master_main

The most commonly used statement in SQL is

A.cursor B.select C.execute D.commit

Q10

Which of the following keyword avoid the duplicate?

A.Distinct B.Remove C.Where D.GroupBy

More for this chapter

Book Back Questions10 textbook MCQs · solved Additional MCQs15 extra MCQs · solved Practice TestInteractive · instant score Additional MCQ TestTest yourself on the extra set Study NotesConcepts & methods Formula SheetAll key formulas

About this Data manipulation through SQL test

This free online practice test covers Data manipulation through SQL from the 12th Standard Computer Science (Samacheer Kalvi) syllabus. Choose the number of questions and an optional time limit, then answer and submit — everything is checked in your browser, with the correct answers and a worked explanation shown at the end. For the full solutions to every question in this set, see the solved MCQs page.

More chapters in Computer Science

View all

1 Function 2 Data Abstraction 3 Scoping 4 Algorithmic Strategies 5 Python -Variables and Operators 6 Control Structures 7 Python functions 8 Strings and String manipulation 9 Lists, Tuples, Sets and Dictionary 10 Python Classes and objects 11 Database Concepts 12 Structured Query Language (SQL) 13 Python and CSV files 14 Importing C++ programs in Python. 16 Data visualization using pyplot: line chart, pie chart and bar chart