(A) the underlying data and the relations among them
(B) processing requirments and the floe of data
(C) decesion and control information
(D) communication and network structure
What are the potental problems when a DBMS executes multiple transections concurrently?
(A) The lost update problem
(B) The dirty read problem
(C) The unrepeatable read problem
(D) All the three
The column of a table is reffered to as the?
(A) tuple
(B) attribute
(C) entity
(D) degree
If every non key attrebute is functionaly dependent on the primary key then the relation will be in?
(A) first normal form
(B) second normal form
(C) third normal form
(D) fourth normal form
Given Relations R(w,x) and S(x,y) the result of SELECT DISTINCT w,x FORM R,S is guaranted to be same as R,if?
(A) R has no duplicates and S is non-empty
(B) R and S has no duplicates
(C) S has no duplicates and R is non-empty
(D) R and S has same numbers of tuples
The concept of locking can be used to solve the problem?
(A) lost update
(B) uncommitted dependency
(C) inconsistant data
(D) All the three
Which normal form is considerd adequate for rational database design?
(A) 2NF
(B) 3NF
(C) 4NF
(D) BCNF
In which of the following parameters passing mechanisms, the actual argument has to be variable:
(A) Pass by value
(B) Pass by result
(C) Pass by value-result
(D) Pass by reference