Kerala PSC Previous Years Question Paper & Answer

Title : SYSTEM ANALYST / PROGRAMMER
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 ' 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)

% 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?‏

Similar Question Papers

Ask Question

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


Questions & Answers

SYSTEM ANALYST / PROGRAMMER : Video