Which is not related to SQL?

• A) Data Definition Language
• B) Data Translation Language
• C) Data Control Language
• D) Data Manipulation Language

What does DISTINCT means in the given SQL statement?
SELECT DISTINCT * ColumnName FROM TableName;

• A) Unique Values from Columns
• B) All Values from Columns
• C) Duplicate Values from Columns
• D) One Value from Columns

BETWEEN operator is used in _______________ clause.

• A) SELECT
• B) WHERE
• C) HAVING
• D) GROUP BY

Which logical operator will be used in where clause of SQL statement if you want to display the list of all employee names who are earning more than 2500 but less than 5000?

• A) OR
• B) AND
• C) XOR
• D) NOT

% wildcard means ____________.

• A) Exactly one character
• B) Zero characters
• C) More than zero characters
• D) Zero or more characters

Transaction is a unit of ____________ accomplished in a logical order against a database.

• A) Power
• B) Query
• C) Work
• D) Command

Which of the following SQL command will be used to delete a record of an employee named ALI form emp table?

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

Which of the following command will be used if you want to permanently save the changes made in database?

• A) Savepoint
• B) Rollback
• C) Commit
• D) Store

Which of the following SQL command will be used to change the salary of a particular Employee from 20000 to 25000 in EMPLOYEE table? (Salary is an attribute of EMPLOYEE table.)

• A) Commit
• B) Edit
• C) Insert
• D) Update

The Rollback statement is the transactional command used to save changes invoked by a transaction to the database.

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

______________ statement deletes the table but the structure remains un-deleted.

• A) Truncate
• B) Terminate
• C) Remove
• D) Drop

Insert, update and delete are the ______________ commands.

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

_______________ command is used to restore the changes made in the database.

• A) Commit
• B) Truncate
• C) Delete
• D) Rollback

In AMPS, the size of Mobile Identifier is ___________ bits.

• A) 15
• B) 32
• C) 34
• D) 4

Which of the following protects the network operators from different types of fraud found in today's cellular world?

• A) HLR
• B) VLR
• C) AUC
• D) EIR

In GSM network, each time slotted user is allocated a frequency of __________ in each direction.

• A) 100 KHz
• B) 50 KHz
• C) 200 KHz
• D) 30 KHz

Which of the following is NOT a supplementary service provided by a GSM network?

• A) Call Barring
• B) Handoff/Handover
• C) Conferencing
• D) Call Waiting

__________ is one of the supplementary services provided by GSM network.

• A) Conferencing
• B) Modem selection
• C) SMS
• D) Calling

_____________ is used to store the visitor user information temporarily.

• A) AUC
• B) HLR
• C) EIR
• D) VLR

The area in which radio coverage is provided by one BTS is called a(n) __________.

• A) MSC service area
• B) PLMN service area
• C) Location area
• D) Cell