D:-byte code, object code, executable
Correct Answer:- Option-B
Question61:-Collection of entities that have the same attributes are called
A:-Domain
B:-Value set
C:-Entity set
D:-Entity type
Correct Answer:- Option-D
Question62:-Which of the following key is related with referential integrity constraint?
A:-Primary key
B:-Candidate key
C:-Foreign key
D:-Super key
Correct Answer:- Option-C
Question63:-Consider the following table of data r(R) of the relation schema R(XYZ)

% Y Z
xl yl zl
x2 yl zl
x3 y2 21

Which of the following functional dependency sets are valid
A:-X->Y, Y->Z, Z->X
->Y, X->Z, Y->Z
:-Both 1 and 2
D:-None of the above
Correct Answer:- Option-B
Question64:-The SQL aggregate function that returns number of values in a given column is
A:-count( )
B:-count(*)
:-sum( )
D:-All of the above
Correct Answer:- Option-A
Question65:-Which of the following construct returns true if a given tuple is not present in the subquery
A:-exists
-not present
C:-not exists
D:-none of the above
Correct Answer:- Option-C
Question66:-What will be the output of the following query?
CREATE EmployeeView VIEW AS SELECT nothing FROM Employee WHERE ID < 100
A:-EmployeeView will be created with no columns
B:-EmployeeView will be created with column nothing
C:-Syntax error
D:-None of the above
Correct Answer:- Option-C

Question67:-Consider a relation A with m rows and relation B with n rows. How many rows will be generated if A x B is
performed?

ری
ہ + 06-:8
ریت
"0:01۰
‎Correct Answer:- Option-D‏
‎Question68:- is the statement which specifies when the trigger is to be executed.‏
‎A:-From‏
‎B:-Where‏
‎C:-When‏
‎D:-None of the above‏
‎Correct Answer:- Option-C‏
‎Question69:-Which of the following is true about Atomicity?‏