Truncate command response time is ______ as compared to Delete command.

• A) worst
• B) Same
• C) Poor
• D) Better

Browser Based & Non-Browser/Simple are two different types of--------------------------------------.

• A) forms
• B) language
• C) interface
• D) Programs

Which of the following is not an aggregate function?

• A) MAX
• B) AVG
• C) SUM
• D) UPPER

Which of the following statement creates a database named IMDB?

• A) CREATE IMDB DATABASE;
• B) ADD DATABASE named IMDB;
• C) CREATE DATABASE IMDB;
• D) CREATE DB IMDB;

Which of the following is incorrect about alter table statement?

• A) Can not be used to create a new table
• B) Can be used to add column in the existing table
• C) Can be used to delete a column
• D) Cannot be used to modify type or size of an existing column

Users know what to do and how to do it are called -------.

• A) new
• B) Experts
• C) beginners
• D) intermediate

Consider the two relations,
Supplier (S_no, S_name, Contact_No, Address) and
Supply (S_no, Item_no).
Which of the following statements give(s) a list of supplier names supplying the item with Item_no ‘555’?

• A) SELECT S_name FROM Supplier WHERE S_no EXISTS (SELECT S_no FROM Supply WHERE Item_no=’555’)
• B) SELECT S_name FROM Supplier WHERE S_name EXISTS (SELECT S_name FROM Supply WHERE Item_no='555')
• C) SELECT S_name FROM Supplier WHERE Item_no=’555’
• D) SELECT S_name FROM Supplier, Supply WHERE Supplier.S_no=Supply.S_no AND Item_no=’555’

Which of the following prevents duplicate values to be displayed as a result of an SQL statement?

• A) ALTER
• B) DISTINCT
• C) UPDATE
• D) DELETE

REVOKE is a ______________ statement.

• A) Control Access
• B) Data manipulation
• C) Data Definition
• D) Data description

“It should be user friendly and user must not search for required buttons or text boxes” this statement is about------------------------------.

• A) Application program
• B) user friendly interface
• C) system program
• D) language

What happens if the WHERE clause is omitted from a DELETE statement?

• A) First record of the table will be deleted
• B) All records from the table are deleted
• C) The statement will not be executed and will give a syntax error
• D) No record from the table will be deleted

Columns used to uniquely identify individual rows of a given table, may be specified to be NOT NULL.

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

An effective user interface minimizes the----------- users require to learn and implement the system.

• A) efficiency
• B) Time
• C) Space
• D) complexity,

The ________ operator allows to use wild cards in the where clause of an SQL statement.

• A) LIKE
• B) FROM
• C) None of the above.
• D) IN

DML does not used to :

• A) add new rows to tables
• B) retrieve rows from table
• C) alter a table definition
• D) modify the rows of tables

__________ User Interface is preferred over ________ User Interface with respect to user.

• A) Easy to understand, effective
• B) Hard to understand, effective
• C) Hard to understand, efficient
• D) Easy to understand, efficient

Forms are used in application programs, how many types of forms are available----------------------?

• A) One
• B) five
• C) two
• D) four

UPDATE command belongs to which type of Classification?

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

Which of the following is not a part of an INSERT statement?

• A) INSERT
• B) INTO
• C) MODIFY
• D) VALUES

Which of the following syntax of the functions in SQL is used to add column values?

• A) MAX(expression)
• B) COUNT(expression)
• C) COUNT(*)
• D) SUM(expression)