Page:5
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.
30.
31.
32.
33.
34.
What do we use to define a block of code in python?
(A) Key (3)
(0) Block (0)
DCL stands for :
(ಹ) Data Consistency Language
(B) Data Configuration Language
(C) Data Control Language
(D) Database Control Language
In relational model tables are also known as :
(A) Tuples (B)
(C) Schema (D)
Brackets
Indentation
Relations
Structures
property of transaction ensures that multiple transactions can occur
independently without interference.
(ಹ) Consistency (B)
(C) Durability (D)
Isolation
Atomicity
Which of the following statement is/are correct about keys in MySql?
@ A foreign key is a field (or collection of fields) in one table that refers to the primary key
in another table
Gi) There will be more than one primary key in one table.
(10) A table can have multiple foreign keys
(iv) A table can have multiple candidate keys, but can only have one primary key.
(A) @ and Gi)
(B) Only (i), (iii) and (iv)
(C) Only @) and (iv)
(D) All of above (i), (ii), (iii) and (iv)
147/2023
[P.T.0.]