SQL originally called as

(a)

DBMS

(b)

RDBMS

(c)

SQL

(d)

SQLITE

Latest SQL standard as of now is

(a)

SQL 2008

(b)

SQL 2009

(c)

SQL 2018

(d)

SQL 2.0

WAMP stands for

(a)

Windows, Android, MySQL, PHP

(b)

Windows, Apache, MySQL, Python

(c)

Windows, APL, MySQL, PHP

(d)

Windows, Apache, MySQL, PHP

TCL stands for

(a)

Transmission Control Language

(b)

Transfer Communication Language

(c)

Transaction Communication Language

(d)

Transaction control Language

DQL Stands for

(a)

Database Query Language

(b)

Data Query Language

(c)

Defined Query Language

(d)

Dynamic Query Language

Which DML requires a user to specify what data is needed without specifying how to get it?

(a)

Produced DML

(b)

Non-Procedural DML

(c)

Programmable DML

(d)

PRocedural DQL

The SQL DCL command withdraws the access permission given by the GRANT statement is

(a)

WITHDRAWN

(b)

REMOVE

(c)

DELETE

(d)

REVOKE

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

(a)

language

(b)

function

(c)

record

(d)

datatype

Double data type precision may exceed

(a)

64

(b)

74

(c)

54

(d)

14

How many types of database integrity constraints are there?

(a)

4

(b)

5

(c)

3

(d)

Multiple

____________ is a condition application on a field or set of fields?

(a)

Class

(b)

Control structure

(c)

Constraint

(d)

Arguments

The Primary key constraint is similar to ___________ constraint.

(a)

Unique

(b)

Check

(c)

Default

(d)

none of the these

The __________ command is used to modify the table structure (schema)

(a)

ALTER

(b)

CHANGE

(c)

REPLACE

(d)

MODIFY

The _______ keyword is used along with the SELECT command to eliminate duplicate rows in the table?

(a)

DUPLICATE

(b)

DISTINCT

(c)

ELIMINATE

(d)

a ro b

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

(a)

BETWEEN

(b)

RANGE

(c)

IN

(d)

WHERE

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

Differentiate Unique and Primary Key constraint

Write the difference between table constraint and column constraint?

Which component of SQL lets insert values in tables and which lets to create a table?

What is the difference between SQL and MYSQL?

List few RDBMS packages.

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

What is the use of WAMP?

List the SQL DDL commands. Explain each.

List the SQL DML commands.

What is a constraint? Write short note on Primary key constraint.

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

Write the use of Savepoint command with an example.

Write a SQL statement using DISTINCT keyword.

How the data in RDBMs is stored? Explain.

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

How will you frame the commands to work on database?

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

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

Write the different categories of SQL commands.

Write the different types of constraints and their functions.

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

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

Write a SQL statement to create a table for employee having any five fields and create a table constraint for the employee table.

Write the processing skills of SQL.

Write a note on
(i) TRUNCATE command.
(ii) DROP TABLE command.

Explain TCL commands in detail.