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

(a)

DDL

(b)

`DML

(c)

DCL

(d)

DQL

The command to delete a table is

(a)

DROP

(b)

DELETE

(c)

DELETE ALL

(d)

ALTER TABLE

Latest SQL standard as of now is

(a)

SQL 2008

(b)

SQL 2009

(c)

SQL 2018

(d)

SQL 2.0

Which of the following is not a RDBMS package?

(a)

Oracle

(b)

Foxpro

(c)

DBbase

(d)

MySQL

(e)

b and c

Which of the following is a collection of data entries?

(a)

Database

(b)

Table

(c)

Dbase

(d)

SQL

Which of the following processing skills of SQL provides commands for defining relation schemes?

(a)

MySQL

(b)

DDL

(c)

DML

(d)

DCL

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

(a)

View definition

(b)

Integrity

(c)

Authorization

(d)

Transaction control

TCL stands for

(a)

Transmission Control Language

(b)

Transfer Communication Language

(c)

Transaction Communication Language

(d)

Transaction control Language

Which of the following component simply deals with description of the database schema?

(a)

DML

(b)

DDL

(c)

DCL

(d)

DQL

The SQL DML command used remove all records from a table but not the space occupied by them is

(a)

Drop

(b)

Truncate

(c)

Delete

(d)

Del