Kerala PSC Previous Years Question Paper & Answer
Page:6
Below are the scanned copy of Kerala Public Service Commission (KPSC) Question Paper with answer keys of Exam Name 'Jr Instrctor(Information Communication Technology System Maintenance) Industrial Training(cat no 093/2018)' And exam conducted in the year 2019. And Question paper code was '061/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.
C:-Mysql
D:-5ql server
Correct Answer:- Option-A
Question41:-Which one of the following is used to create a virtual relation for storing a query?
۸-۷
B:-function
C:-procedure
D:-table
Correct Answer:- Option-A
Question42:-which one of the following option clause is used with view to reject the tuples that do not satisfy the "where
condition"?
A:-with
B:-with check
C:-check
D:-none of these
Correct Answer:- Option-B
Question43:-When using Foreign Key, the ____ of one relation is referenced in another relation
A:-Foreign Key
B:-Primary Key
C:-Check constraint
D:-None of these
Correct Answer:- Option-B
Questiondd:-____is the preferred method for enforcing data integrity
A:-Constraints
B:-Triggers
C:-Cursors
D:-Stored Procedure
Correct Answer:- Option-A
Question45:-What values does the count(*)function ignore?
A:-null values
B:-Integer
C:-character
D:-none of these
Correct Answer:- Option-A
Question46:-The ____ statement is used in SQL for authorization
A:-implement
B:-revoke
C:-grant
D:-none of these
Correct Answer:- Option-C
Question47:-____is executed when a table is modified
A:-procedure
B:-function
C:-trigger
D:-none of these
Correct Answer:- Option-C
Question48:-Which of the following command is used to delete a particular column in a relation?
A:-DELETE
B:-ALTER
C:-UPDATE
D:-DROP
Correct Answer:- Option-B
Question49:-A transaction completes its execution is said to be
A:-Saved
B:-Rolled
C:-Committed
D:-Loaded
Correct Answer:- Option-C
Question50:-The language used in application program to request for data from DBMS is