12th Computer Science Weekly Test - 3 ( Structured Query Language (SQL) )

St. Britto Hr. Sec. School - Madurai

12th Computer Science Weekly Test - 3 ( Structured Query Language (SQL) )-Aug 2020

Time : 1.30 Hours

Part - A

Multiple Choice Question - Answer All Question

Which of the following command replaces some or all data values in a database?

REPLACE
UPDATE
SET
none ofthese

The SQL DQL command used to display all the records from the table is

Select
display
Show
Select all

The SQL DDL command removes all records from a table and also release the space occupied by these records is

Delete
Truncate
Rollback
Drop

The ______ keyword defines a range of values the record must fall into make the condition true.

BETWEEN
RANGE
IN
WHERE

The clause used to sort data in a database

SORT BY
ORDER BY
GROUP BY
SELECT

DML stand for

Data Manipulation language
Data Meaningful Language
Directional Manipulate Language
Data Management Language

The _____ symbol is used with the COUNT to induce the NULL values.

Which of the following have a special meaning in SQL?

Keywords
Commands
Clause
Arguments

Choose the incorrect statement from the following

(1) Unique constraint ensures that no two rows have same value in the specified column (2) Primary Key constraint does not help to identify a record in the table.
(3) While creating table, no default value for thefield is assigne(d)
(4) Check constraint use only Assignment operator for condition .
(5) Constraints does not ensure database integrity.

1, 4
2,4,5
4, 5
3, 4, 5

Choose the incorrect pair from the following

Drop - SQL DDL command
Delete - SQL DDL command
Truncate - SQL DDL comman
Grant - SQL DDL command

InstaQB

Institutions

12th Standard English Medium

12th Standard Tamil Medium

11th Standard English Medium

11th Standard Tamil Medium

10th Standard English Medium

9th Standard English Medium

8th Standard English Medium

7th Standard English Medium

Class XII

Class XI

12Th Standard

11Th Standard

10Th Standard

9Th Standard

12th Computer Science Weekly Test - 3 ( Structured Query Language (SQL) )

St. Britto Hr. Sec. School - Madurai

12th Computer Science Weekly Test - 3 ( Structured Query Language (SQL) )-Aug 2020

Part - A

Multiple Choice Question - Answer All Question

Which of the following command replaces some or all data values in a database?

The SQL DQL command used to display all the records from the table is

The SQL DDL command removes all records from a table and also release the space occupied by these records is

The ______ keyword defines a range of values the record must fall into make the condition true.

The clause used to sort data in a database

DML stand for

The _____ symbol is used with the COUNT to induce the NULL values.

Which of the following have a special meaning in SQL?

Choose the incorrect pair from the following

Part - B

Generic 2 - Answer All Question

WhatisSQL?

How will you include aggregate function on the group created in a table using GROUP BY clause?

Expand (i) DDL (ii) DML (iii) WAMP

Write the syntax of GROUP BY and HAVING clause.

Write a note on data query language.

Part - C

Generic 3 - Answer All Question

Write the syntax for the following commands. (i) INSERT (ii) DELETE (iii) UPDATE

Write a SQL statement using DISTINCT keyword.

How will set a primary key for more than one field? Explain with example.

Write the different categories of SQL commands.

List the data types used in SQL.

Comment

Other Study material

12th Computer Science Weekly Test - 1 ( Data manip

12th Computer Science Monthly Test - 3 (Importing

12th Computer Science Monthly Test - 3 ( Data vis

12th Computer Science Weekly Test - 4 ( Data manip

12th Computer Science Weekly Test - 3 ( Data manip

12th Computer Science Weekly Test - 2 ( Data manip

12th Computer Science Monthly Test - 1 ( Python an

12th Computer Science Monthly Test - 2 ( Python an

12th Computer Science Monthly Test - 3 ( Python an

12th Computer Science Weekly Test - 1 ( Importing

12th Computer Science Weekly Test - 2 ( Importing

12th Computer Science Weekly Test - 3 ( Importing

12th Computer Science Weekly Test - 4 ( Importing

12th Computer Science Weekly Test - 5 ( Importing

12th Computer Science Monthly Test - 1 ( Importing

Tamilnadu Stateboardszs - Class

How will you include aggregate function on the group created in a table using GROUP BY
clause?

Expand

(i) DDL
(ii) DML
(iii) WAMP

Write the syntax for the following commands.
(i) INSERT (ii) DELETE (iii) UPDATE