Kerala PSC Previous Years Question Paper & Answer
Page:19
Below are the scanned copy of Kerala Public Service Commission (KPSC) Question Paper with answer keys of Exam Name ' Instructor Gr I (Engineering Colleges) in Information Technology & Computer Engineering' And exam conducted in the year 2022. And Question paper code was '091/2022'. Medium of question paper was in Malayalam or English . Booklet Alphacode was 'A'. Answer keys are given at the bottom, but we suggest you to try answering the questions yourself and compare the key along wih to check your performance. Because we would like you to do and practice by yourself.
81.
82.
83.
84.
091/22
In RDBMS, second normal form deals with
A) Functional dependencies
B) Transitive dependencies
C) Partial dependencies
D) Multivalued dependencies
A relation R(x, y) ina particular relational database has redundant data due to inconsistent
data entry and errors. Due to this several queries may fail to execute or generate incorrect
answers. Despite these challenges, can any of the queries listed below execute without
any errors and without any redundant records ?
A) SELECT x FROM R WHERE x = 1
B) SELECT x, y FROM R GROUP BY x, y
C) SELECT MAX(y) FROM R GROUP BY x
)
0) All of the above
Consider two transactions T1 and T2 shown in figure. Based on the practical assumption
that ACID properties have to be adhered to, in order to keep the database in consistent
state, which of the two transactions would have to execute rollback due to failed operations,
if concurrency control algorithms have been implemented on the database.
Time
Read Validate Write
71
Read set : (ಸಿ, 8) Write set : (8, 0)
ணன ண னை
Read set :{A,D} Write set : (ಸಿ, 8)
T1 only
T2 only
T1 or T2 based on priority
Both T1 and T2
For N given relations, number of alternative join trees possible may be approximately
A) O(N) B) O(N2)
C) O(N log N) D) None of the above
-19-