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 'JUNIOR INSTRUCTOR(COMPUTER OPERATOR AND PROGRAMMING ASSISTANT' And exam conducted in the year 2023. And Question paper code was '147/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.
35.
Which is the correct syntax to create a stored procedure?
(A) CREATE PROCEDURE procedure_name
AS
sql_statement
GO;
(B) CREATE STOREDPROCEDURE procedure_name
AS
sql_statement
GO;
(C) CREATE PROCEDURE procedure_name
AS
sql_statement
START;
(D) CREATE PROCEDURE procedure_name
sql_statement
GO;
36. A is basically a program which gets automatically executed in response to
some events such as modification in the database.
(A) Cursor (B) Method
(C) Trigger (D) Action
87. A table that displays data redundancies yields ————————_ anomalies.
(^) Insertion (B) Deletion
(C) Update ൯) Allof the above
38. Which of the following statements creates a new table ‘skilledworker’ that has the same
schema as ‘worker’?
(A) create table skilledworker;
(B) Create table skilledworker like worker;
(C) Create Table skilledworker as worker;
(D) Create table like skilledworker;
39. Which is right statement to insert multiple records?
(A) INSERT INTO TABLENAME VALUES (‘col1’; ‘col2’), (col1’, ‘col2’),...
(B) INSERT INTO TABLENAME VALUES (‘col1’, ‘col2’), VALUES (‘col1’, ‘col2’),...
(C) INSERT INTO VALUES OF TABLENAME (‘col1’, ‘col2’), ‘coll’, ‘col2),...
(D) INSERT INTO TABLENAME VALUES ("0011', ‘col2’), TABLENAME VALUES
(८011, ८०12")...
147/2028 8 A