Kerala PSC Previous Years Question Paper & Answer

Title : SYSTEM ANALYST / PROGRAMMER KPSC MEDIUM : ENGLISH
Question Code : A

Page:8


Below are the scanned copy of Kerala Public Service Commission (KPSC) Question Paper with answer keys of Exam Name 'SYSTEM ANALYST / PROGRAMMER KPSC MEDIUM : ENGLISH ' And exam conducted in the year 2019. And Question paper code was '017/2019/OL'. 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.

page: 8 out of 12
Excerpt of Question Code: 017/2019/OL

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}

‎Xy 2‏
21 #1 21
1 آلا ‎೫2‏
‏1 2لا ثلا

‎Which of the following functional dependency sets are valid
ArX->Y, Y->Z, Z->X
B:-X->Y, X->Z, Y->Z
C:-Both 1 8೧6 2
D:-None of the above
Correct Answer:- Option-B
Question64:-The SQL aggregate function that retums number of values in a given column is
A:-count( }
B:-count(*}
C:-sum( }
D:-All of the above
Correct Answer:- Option-A
Question65:-Which of the following construct retums true if a given tuple is not present in the subquery
A:-exists
B:-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 EmployesView 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?
കണ
8:11
C-m-n
ப்ர
Correct Answer:- Option-D
೧6560768: - 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?

Similar Question Papers

Ask Question

(Press Ctrl+g to toggle between English and the chosen language)


Questions & Answers

SYSTEM ANALYST / PROGRAMMER KPSC MEDIUM : ENGLISH : Video