21.

22.

23.

24.

25.

26.

27.

095/23

Which are the properties of transaction in database ?

i) Atomicity ii) Consistency iii) Isolation iv) Concurrency
A) i, ii and iii only B) All the above

C) iionly D) ii and iii only
Another name of tuple is

A) Record B) Field

C) File D) Relation

In an ER diagram, symbol used for an attribute is

A) Rectangle B) Ellipse

C) Double Rectangle D) Diamond

In three tier architecture, query processing languages resides in
A) Application tier B) User tier

C) Database tier D) None of these

Suppose you are assigned with the task of removing all data in a table “Student”
without deleting table definition. Which statement is used ?

A) DROP TABLE Student B) TRUNCATE TABLE Student

C) UPDATE TABLE Student D) All the above

A stored program needs to be invoked automatically before a new record is
inserted into a table. Then which of the following is more correct ?

A) Define a row level trigger B) Define a statement level trigger
C) Define a procedure D) Define a function

A telephone company wishes to give an offer validity extension of 10 more days for
all customers with a plan “PLAN197”. Then which of the query is more correct ?
A) MODIFY Customers

SET ValidPrd = ValidPrd+10

WHERE Plan = “PLAN197”
B) ALTER table Customers

SET ValidPrd = ValidPrd+10

WHERE Plan = “PLAN197”
C) SELECT Customers

SET ValidPrd = ValidPrd+10

WHERE Plan = “PLAN197”
D) UPDATE Customers

SET ValidPrd = ValidPrd+10

WHERE Plan = “PLAN197”