12th Computer Science Chapter- 15 Onemarks Online Test

Question 1: Which of the following is an organized collection of data?

A) Database

B) DBMS

C) Information

D) Records

Question 2: SQLite falls under which database system

A) Falt file database system

B) Relational database system

C) Hierarchical database system

D) Object oriented database system

Question 3: 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

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

A) Save

B) Save As

C) Commit

D) Oblige

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

A) execute()

B) key()

C) cursor()

D) run()

Question 6: 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 ()

Question 7: The function that returns the largest value of the selected column is

A) MAX()

B) LARGE()

C) HIGH()

D) MAXIMUM()

Question 8: Which of the following is called the master table?

A) sqlite_master

B) sal_master

C) main_master

D) master_main

Question 9: The most commonly used statement in SQL is

A) cursor

B) select

C) execute

D) commit

Question 10: Which of the following keyword avoid the duplicate?

A) Distinct

B) Remove

C) Where

D) GroupBy

Report Card

Total Questions Attempted: 0

Correct Answers: 0

Wrong Answers: 0

Percentage: 0%