Kerala PSC Previous Years Question Paper & Answer
Page:4
Below are the scanned copy of Kerala Public Service Commission (KPSC) Question Paper with answer keys of Exam Name ' IT Officer - Kerala State Co-operative Bank Ltd' And exam conducted in the year 2023. And Question paper code was '232/2023'. 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.
21.
22.
23.
24.
25.
26.
27.
SQL query for finding the Cartesian product of relations R andS :
(^) Select all column from R, S
(B)_ Select * from R, S
(C) Select all columns from R natural join B
(D)_ Select * from R full outer join S
is the minimal super key.
(A) Primary key (B) Candidate key
(C) Super key (D) Foreign key
Which one is not a DDL Command?
(A) UPDATE (B) CREATE
(C) ALTER (D) DROP
Which statement is true for the key of a relation?
(ಸಿ) One or more attributes form a key
(B) Aunique ID assigned to each row can be a key
(0) Both (A) and (B)
(D) None of the above
Which of the following is a concurrency problem?
(A) Temporary update problem (B) Lost update problem
(C) None of the above (D) Both (A) and (B)
Dirty Read problem also known as
(A) W-R Conflict (3) W-W Conflict
(C) R-R Conflict (D) None of the above
If a schedule S can be transformed into a schedule S' by a series of swaps of non-conflicting
instructions, then S and S' are
(A) Conflict equivalent (B) Non conflict equivalent
(C) Equal (D) Isolation equivalent
232/2023 6 A