InstaQB

Home
Institutions
- Institutions
  
  Polytechnic Colleges
  
  Medical Colleges
  
  Arts & Science Colleges
  
  Universities
  
  Engineering Colleges
  
  Agricultural Colleges
  
  Research Institute
  
  Law Colleges
  
  Audiology and Speech Colleges
  
  Business & Management colleges
  
  Nursing colleges
  
  Hotel Management institutes
  
  Aeronautical Colleges
  
  Bachelor's Degree
Syllabus
Courses
Stateboard
- 12th Standard English Medium
  
  Maths
  
  Physics
  
  Chemistry
  
  Biology
  
  Computer Science
  
  Business Maths
  
  Economics
  
  Commerce
  
  Accountancy
  
  History
  
  Computer Applications
  
  Computer Technology
  12th Standard Tamil Medium
  
  உயிரியல்
  
  கணினி பயன்பாடுகள்
  
  கணினி அறிவியல்
  
  வணிகக் கணிதம்
  
  வணிகவியல்
  
  பொருளியல்
  
  கணிதவியல்
  
  வேதியியல்
  
  இயற்பியல்
  
  கணினி தொழில்நுட்பம்
  
  வரலாறு
  
  கணக்குப்பதிவியல்
  11th Standard English Medium
  
  Maths
  
  Commerce
  
  Economics
  
  Biology
  
  Business Maths
  
  Accountancy
  
  Computer Science
  
  Physics
  
  Chemistry
  
  Computer Applications
  
  History
  
  Computer Technology
  
  Bio - Zoology
  11th Standard Tamil Medium
  
  கணிதவியல்
  
  உயிரியல்
  
  பொருளியல்
  
  இயற்பியல்
  
  வேதியியல்
  
  வணிகக் கணிதம்
  
  கணினி அறிவியல்
  
  கணக்குப்பதிவியல்
  
  வணிகவியல்
  
  கணினி பயன்பாடுகள்
  10th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  
  9th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  
  8th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  7th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
ICSE/ISC
- Class XII
  
  Mathematics
  
  Physics
  
  Accountancy
  
  Biology
  
  History
  
  Geography
  
  Psychology
  
  chemistry
  
  Economics
  
  Computer Science
  
  Political Science
  
  Business Studies
  Class XI
  
  Accountancy
  
  Chemistry
  
  Mathematics
  
  Biology
  
  Geography
  
  Physics
  
  History
CBSE
- 12Th Standard
  
  Physics
  
  Chemistry
  
  Maths
  
  Biology
  
  History
  
  Economics
  
  Commerce
  
  Geography
  
  Socialogy
  
  Business Studies
  
  Computer Science
  
  Biotechnology Class
  
  Political Science
  
  Home Science
  11Th Standard
  
  Physics
  
  Chemistry
  
  Maths
  
  Biology
  
  History
  
  Economics
  
  Commerce
  
  Socialogy
  
  Business Studies
  
  Geography
  
  Home Science
  
  Computer Science
  
  Biotechnology Class
  
  Political Science
  10Th Standard
  
  Physics
  
  Chemistry
  
  Biology
  
  Mathematics
  
  Economics
  
  Geography
  
  History & Civics
  
  Computer Application
  9Th Standard
  
  Physics
  
  Chemistry
  
  Biology
  
  mathematics
  
  Computer Application
  
  Economics
  
  Geography
  
  History & Civics

12th Computer Science Monthly Test - 1 ( Structured Query Language (SQL) )

St. Britto Hr. Sec. School - Madurai

12th Computer Science Monthly Test - 1 ( Structured Query Language (SQL) )-Aug 2020

Time : 2.30 Hours

Part - A

Multiple Choice Question - Answer All Question

The keyword used to sort the records in ascending order is

ASCD
ASD
ASCE
ASC

The specific related information about every record in the table is maintained by

language
relation
tuple
field

The data in a database is stored based on the kind of value stored is known as

language
function
record
datatype

Queries can be generated using

SELECT
ORDER BY
MODIFY
ALTER

The Primary key constraint is similar to _______ constraint.

Unique
Check
Default
none of the these

SQL stands for

Standard Query Language
Secondary Query Language
Structural Query Language
Standard Question Language

Defined multiple constraints are separated by

comma
space
semicolon
colon

Which processing skills of SQL includes commands of access rights to creations and views of tables?

View definition
Integrity
Authorization
Transaction control

Choose the correct pair from the following

Update - SQL DCL command
Commit - SQL TCL command
Insert - SQL DML command
Create - SQL DDL command

The data in RDBMS, is stored in database objects called

Queries
Languages
Relations
Tables

Which commands provide definitions for creating table structure, deleting relations, and modifying relation schemas.

DDL
`DML
DCL
DQL

A_____ is a collection of related fields in a table.

Attributes
SQL
Record
Relations

The constraint enforces a field to always contain a value is

NULL
NOT NULL
YES
ALWAYS

The NULL value in the field can be searched in a table using the _____ in the WHERE clause.

==NULL
NULL
ISNULL
NOTNULL

Which of the following must be specified when a table is created?

column name
datatype
Size
all of these

Part - B

Generic 2 - Answer All Question

Write a note on data query language.

List the SQL DML commands.

WhatisSQL?

Write the syntax of creating table with constraint.

How will you retain duplicate rows while displaying the table?

Define Primary Key Constraint.

How will you filter the records in a table? Give an example.

Write the syntax of creathig table in database.

Write a query that selects all students whose age is less than 18 in order wise.

What are two basic types of DML.

What is RDBMS ?

List the SQL DDL commands .Explain each.
Expand
(i) SQL (ii) DBMS (iii) RDBMS

Write the difference between table constraint and column constraint?

List few RDBMS packages.

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

Part - C

Generic 3 - Answer All Question

How will you frame the commands to work on database?

Write the different categories of SQL commands.

Write any three DDL commands.

How will set a primary key for more than one field? Explain with example.
Define Data Control Language and also list the command under this.

Write a SQL statement to modify the student table structure by adding a new field.

How will you generate queries and retrieve data from the table? Explain?

Which constraint helps to set a limit value placed for a field?

Write a SQL statement using DISTINCT keyword.

List the data types used in SQL.

Write the use of Savepoint command with an example.

Part - D

Generic 5 - Answer All Question

Write the processing skills of SQL.

Explain TCL commands in detail.
Construct the following SQL statements in the student table-
(i) SELECT statement using GROUP BY clause.
(ii) SELECT statement using ORDER BY clause.

Write the different types of constraints and their functions.

Explain ALTER command in detail.

What are the components of SQL? Write the commands in each.

Comment

Add Comment

Tamilnadu Stateboardszs - Class