Which of the following is used to retrieve and insert information from database?

• A) DCL
• B) DDL
• C) DML
• D) Both DML and DDL

Which of the following is the Correct SQL statement for creating table in Microsoft SQL server?

• A) CREATE TABLE Customer (SID integer, Last_Name varchar(30), First_Name varchar(30))
• B) CREATE Customer (SID integer, Last_Name varchar(30), First_Name varchar(30));
• C) CREATE TABLE Customer (SID integer PRIMARY KEY, Last_Name varchar(30), First_Name varchar(30));
• D) All of the above

Which of the following is NOT a DDL command?

• A) Create DB
• B) Drop
• C) Delete
• D) Create table

Which of the following is a type of SQL command?

• A) TML commands
• B) DAL command
• C) DTL command
• D) DCL command

GRANT command belongs to which type of classification?

• A) DQL
• B) DML
• C) DCL
• D) DDL

A column used to uniquely identify individual rows of a given table, may be specified to be _______.

• A) Strong
• B) Variable length
• C) NOT NULL
• D) Fixed length

Which of the following is used to filter rows according to some condition(s)?

• A) UPDATE
• B) WHERE
• C) FROM
• D) SELECT

SQL is used for:

• A) Generating queries, organizing, managing and retrieving data stored in a database.
• B) Creating, managing and deleting tables and manage the relationships among the stored date.
• C) Maintaining data integrity and coordinate data sharing.
• D) All of the above

GRANT is a ______________ Command.

• A) DML
• B) None of the above
• C) DCL
• D) DDL

Consider a table named “emp” having fields Empname, EmpID, Age, salary.
Which of the following is true if the following SQL statement tries to execute?

SELECT *
FROM emp
WHERE Empname=’ALI’
ORDERBY Age;

• A) The statement displays the entire fields from emp in which the Empname is ALI in any order
• B) The statement displays the entire fields from emp in which the Empname is ALI in ascending order of their age
• C) The statement has a syntax error
• D) The statement displays the entire fields from emp in which the Empname is ALI in descending order of their age

According to his/her level of knowledge/ understanding how many types of users are there----------------------?

• A) four
• B) three
• C) six
• D) Two

Which of the following is used with INSERT command to insert values in a DB table?

• A) WITH
• B) INTO
• C) ONTO
• D) UPTO

DBMS stand for__________.

• A) Digital Base Mapping System.
• B) Database Manipulation Software.
• C) Database Management System.
• D) Data Borrowing and Movement Software

DML stands for _____________.

• A) Domain Modeling Language
• B) Data Manipulation Language
• C) Data Management Language
• D) Dynamic Modeling Language

Text based & Graphical User Interface (GUI) most commonly called as Forms, are two different types of -------------.

• A) Application programs
• B) system programs
• C) user interface
• D) language

Is the given SQL Statement prompt error?

Select * from relation1;

• A) Logical Error
• B) Parameter Error
• C) No Error
• D) Time out Error

In SQL, which command is used to modify the rows of tables.

• A) APPEND
• B) INSERT
• C) BROWSE
• D) UPDATE

Suppose we have two tables T1 and T2. Tuples of T1 that do not match some row in T2 will not appear in

• A) None of the above
• B) Inner Join
• C) Outer Join
• D) Both I and II

Functions in SQL return a single value

• A) True
• B) False
• C)
• D)

Which language is used to permit or prohibit access to a table?

• A) All of the above.
• B) DCL
• C) DDL
• D) DML