ISRO Scientist/Engineer Question Paper Computer Science 2017

6. Question

ACID properties of a transactions are




Answer
7. Question

Database table by name Overtime_allowance is given below :

Employee Department OT_allowance
RAMA Mechanical 5000
GOPI Electrical 2000
SINDU Computer 4000
MAHESH Civil 1500

What is the output of the following SQL query?
select count(*) from ((select Employee, Department from Overtime_allowance) as S
natural join (select Department, OT_allowance from Overtime_allowance) as T);




Answer
8. Question

Which symbol denote derived attributes in ER Model?




Answer
9. Question

The symmetric difference of sets A = {1, 2, 3, 4, 5, 6, 7, 8} and B = {1, 3, 5, 6, 7, 8, 9} is




Answer
10. Question

The problems 3-SAT and 2-SAT are




Answer