Which of the following is correct syntax to create a table named Class with three attribute class_ID, start_time, Room?

• A) CREATE TABLE class (Class_ID varchar(5), Start_time datetime, Room varchar(10))
• B) CREATE Class COLUMN (Class_ID varchar(5), Start_time datetime, Room varchar(10))
• C) CREATE TBALE class COLUMN (Class_ID varchar(5), Start_time datetime, Room varchar(10))
• D) CREATE class (Class_ID varchar (5), Start_time datetime, Room varchar(10))

Which of the following SQL clauses used to sort the records in result set?

• A) order by
• B) from
• C) having
• D) where

Objective of an order by clause is to display or arrange output of a select statement in a particular order.

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

The ________ condition is used to retrieve values within a specific range.

• A) BETWEEN
• B) LIKE
• C) FROM
• D) AND

Identify the basic part(s) of a SELECT statement?

• A) SELECT
• B) FROM
• C) Both SELECT and FROM
• D) DISTINCT

Programs written to perform different requirement created by the users/organization are called----------------------

• A) Application program
• B) System Program
• C) Chip program
• D) low level program

Truncate is an alternative of Delete command.

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

Which of the following is not DML command?

• A) Truncate
• B) Select
• C) Update
• D) Delete

Value of a function in SQL is always determined by the input parameters

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

Which of the following is a String function in SQL?

• A) SQRT
• B) SIN
• C) LEN
• D) COUNT

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’;

• A) The statement has a syntax error
• B) The statement only displays the EmpID of those employees whose name is ALI
• C) The statement displays the entire fields from emp in which the Empname is ALI
• D) The statement must have an ORDERBY clause

Data Manipulation Language (DML) is the set of commands used to maintain and query a database including updating, inserting, modifying and retrieving data.

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

The _________ function helps to reduce the need of multiple OR conditions.

• A) AND
• B) BETWEEN
• C) Like
• D) IN

SQL stands for ______________.

I - Structured Query Language
II – Standard Query Language
lll- Status Query Language

• A) Only II
• B) Only I
• C) Only lll
• D) Both I and II

The general activities, which are performed during the development of------------------- Data input programmes, Editing, Display,Processing related activities and Reports.

• A) micro kernel program
• B) database program
• C) Hardware Program
• D) Application Program

If A -> B and A -> C, then A -> BC The Inference Rule applies is;

• A) Decomposition
• B) Reflexivity
• C) Union
• D) Augmentation

An attribute y may be functionally dependent on (i) a composite attribute x,y (ii) a single attribute x (iii) no attribute

• A) i and iii
• B) i and ii
• C) iii
• D) ii and iii

The following is an example of __________ inference rule. If stId → prName and prName → credits then stId → credits

• A) Additive
• B) Transitivity
• C) Projectivity
• D) Augmentation

With the help of _____________ technique data values with the smaller sized codes can further reduce the space needed by the data for storage in the database.

• A) Expansions
• B) Compression
• C) Extension
• D) Negation

If A→ BC then A → B and A→ C The above rule follows _____________ inference rule.

• A) Transitivity
• B) Projectivity
• C) Additivity
• D) Augmentation