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

(a)

DDL

(b)

`DML

(c)

DCL

(d)

DQL

The clause used to sort data in a database

(a)

SORT BY

(b)

ORDER BY

(c)

GROUP BY

(d)

SELECT

Which of the following language was designed for managing and accessing data in RDBMS?

(a)

DBMS

(b)

DDL

(c)

DML

(d)

SQL

SQL stands for

(a)

Standard Query Language

(b)

Secondary Query Language

(c)

Structural Query Language

(d)

Standard Question Language

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

The data in RDBMS, is stored in database objects called

(a)

Queries

(b)

Languages

(c)

Relations

(d)

Tables

Which component of SQL includes commands to insert, delete and modify tables in database?

(a)

DCL

(b)

TCL

(c)

DDL

(d)

DML

DCL stands for

(a)

Dynamic Control Language

(b)

Data Communication Language

(c)

Data Control Language

(d)

Dynamic Data Control Language

Which component provides a self definitions to specify storage structure used by the database system?

(a)

DML

(b)

DQL

(c)

DDL

(d)

TCL

Which of the following is not a SQL DDL commands?

(a)

Alter

(b)

Drop

(c)

Grant

(d)

Truncate

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

(a)

Select

(b)

display

(c)

Show

(d)

Select all

Which SQL TCL command save a transaction temporarily

(a)

Commit

(b)

Roll back

(c)

Save point

(d)

None of these

How many types of database integrity constraints are there?

(a)

4

(b)

5

(c)

3

(d)

Multiple

The command to delete all the rows in the table is

(a)

DELETE ALL FROM tablename

(b)

DELETE tablename

(c)

DELETE * FROM tablename

(d)

DELETE * FROM tablename ALL

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?

What is the difference between SQL and MYSQL?

Expand
(i) SQL
(ii) DBMS
(iii) RDBMS

What is the use of WAMP?

What are two basic types of DML.

Explain the following SQL TCL commands.
(i) Commit
(ii) Roll back
(iii) Save point

Write the syntax of creating table with constraint.

How will you retain duplicate rows while displaying the table?

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

Write any three DDL commands.

Write a SQL statement using DISTINCT keyword.

How the data in RDBMs is stored? Explain.

Write the function performed by DDL.

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

List the data types used in SQL.

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.

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.

Explain ALTER command in detail.

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

Explain TCL commands in detail.