| Post Name | ASSISTANT DATA BASE ADMINISTRATOR (Kerala Water Authority) |
|---|---|
| Question Paper Code | 186/2024 |
| Category Code | 521/2023 |
| Date of Test | 30 December 2024 |
| Medium of Question | ENGLISH |
| Exam Type | OMR Examination |
| Total Questions | 100 |
1
If P, Q, R are subsets of a set A, then R × (Pc ∪ Qc)c =
Answer
A. (R × P) ∩ (R × Q)
2
If A, B, and C are non-empty sets, then
Answer
B. – A) =
A)
3
let R be the relation on the set R of all real numbers defined by aRb iff |a – b| ≤ 1,
then R is
i. Reflexive
ii. Symmetric
Answer
C. Both i and ii are true
4
let N denote the set of natural numbers and R be the relation on N × N defined by
Answer
D. if ad(b +
5
For all natural numbers’ “n”, the expression 4n + 15n – 1 is
i. divisible by 3
ii. divisible by
Answer
C. Both i and ii are true
6
A random variable X has the following distribution
X=x 1 2 3 4
P(X = x) k 2k 3k 4k
P(X < 3) is
5
Answer
B. 3 10
1
7
Abox contains 10 mangoes out of which 4 are rotten. Two mangoes are taken together from the box. If one of them is found to be good, the probability that the other is also good is 1 8 5
Answer
D. = ) 3 ) 15 ) 13 )
8
Five unbiased coins are tossed simultaneously. The probability of getting at least
one head is
1 31
Answer
B. —
9
A box contains 8 tickets bearing the numbers 1, 2, 3, 4, 5, 6, 8, 10. One ticket is drawn
at random and is kept aside and then the second is drawn. Find the probability that
both show even numbers.
5
Answer
A. = p) 4
14 5
5 7
— D —
10
Each question is provided with four choices
Answer
D. having one correct answer.
Choose the correct answer and darken the bubble corresponding to the question number
using Blue or Black Ball Point Pen in the OmR Answer Sheet.
11
The co-efficient of correlation between two variables x and y is 0.5. Their co-variance
is 15 and σx = 6. Then σy =
Answer
A. 5
12
If there exists a linear statistical relationship between two variables x and y, then the
regression coefficient of y on x is
Cov(x, y) Cov(x, y) Cov(x, y)
Answer
B. Cov(x, y)
13
Simplify the Boolean expression AB + A
Answer
Question Cancelled
14
The SOP expression for a logic function is given by, ∑
Answer
A. A′ + B′ + C′
15
Choose the correct option with respect to a full adder circuit.
Answer
C. Both
16
Identify the addressing mode used in the instruction, .mOV [5000], CX
Answer
A. direct Addressing mode
17
The size of the address bus and data bus of the 8086 microprocessor are
respectively
Answer
B. 20 and
18
Identify the correct statement.
Answer
C. An execute cycle consists of one or more micro-operations
19
Which of the following situations can result in cache-coherence issues ?
Answer
C. multiple processors with private caches
20
When a large block of data is to be transferred between an I/O device and the main
memory, which of the following techniques is fastest ?
Answer
A. direct memory Access
21
The address bus of a processor is 32 bits wide. The maximum size of the main
memory supported by this processor is
Answer
D. 4 GB
22
Which among the following is not a feature of real-time schedulers ?
Answer
D. Non-preemptive Execution
23
Given below is a code-snippet in C. Which variable will be shared between 2 threads
executing the same code ?
int myAge=20;
int main() {
int mymarks = 50;
________
}
Answer
A. myAge
24
A user does not have executable permission for a given file. Which of the following
commands can be used to update the permission ?
Answer
B. Chmod
25
Which of the following is not a function of a bootloader ?
Answer
B. Virtual memory management
26
What will be the output when the following shell script named test, is executed as
./test 25 26 27 ?
#!/bin/sh
echo “your name is $1 and your mark is $2”
Answer
D. your name is 25 and your mark is
27
Which of the following cases defined the complexities for best possible input ?
Answer
Question Cancelled
28
Which of the following is a disadvantage of AdT ?
Answer
D. None of the above
29
The array which contains majority of non-zero elements is
Answer
D. None of the above
30
For the following code, how much memory is allocated ?
struct example
{
int a;
float b;
char c;
};
Answer
Question Cancelled
31
A class is called a container class if
Answer
C. It contains the objects of another class as data members
32
int A[2] [4]; then A[1] [2] is equivalent to
Answer
D. Both
33
Which of the following is/are a polish notation ?
Answer
C. Prefix
34
An element of a stack is read in 0(1) time only if
Answer
C. It doesn’t matter how the stack is implemented
35
The linked list is not suitable data structure for
Answer
A. Binary search
36
If post-order traversal of some tree produced the sequence PNmyZX, then which
element will be the root node of the tree ?
Answer
C. X
37
The vertex with degree one is called
Answer
B. Pendant vertex
38
Which of the following statements are correct ?
Answer
D. All of the above
39
The feature which indicates code reusability in Object Oriented Programming is
Answer
B. Inheritance
40
Wrapper class in Java is
Answer
A. Used to encapsulate primitive data types
41
Which of the following are valid ways for dynamic memory allocation for an integer
by in C++ ?
Answer
D. All of the above
42
In order to assign a value of 66 to the variable year, which of following can be used
within an
Answer
C.
43
Which of the methods are invoked when an applet begins ?
Answer
C. init(), start(), paint()
44
Can the method main() be overloaded in Java ?
Answer
B. yes, the main() method can be overloaded
45
Which of the following are not legitimate thread states in Java ?
Answer
B. EXECUTING
46
Choose the statement which is true regarding polymorphism ?
Answer
A. An overridden method can be more restrictive than the superclass method
47
In multiple inheritance, if class C inherits two classes A and B as follows, which class
constructor will be called first ?
class A{ };
class B{ };
class
Answer
A. A()
48
Which of the following can be used to create an abstract class in the C++ programming
language ?
Answer
B. By using the pure virtual function in the class
49
The concept is late binding can be implemented using
Answer
D. Virtual functions
50
What does the ‘std::exception’ class represent in C++ ?
Answer
B. The base class for all standard exception classes
51
Consider the following functional dependencies and corresponding implications.
Which of the following statements are correct ?
i.
Answer
D. esignation, dA} → HRA, implies
52
let T1, T2, T3 and T4 are transactions.
Determine whether the following schedule is conflict serializable. [subscript indicate
transaction number]
r1(y); r2(X) ; r3(y) ; w1(X) ; w4(X) ; w2(Z) ; r3(X) ; w3(X)
Answer
C. Conflict Serializable; Schedule : T2, T1, T4, T3
53
Consider a schema R(A, B, C, d, E) and functional dependencies A → C and
B → dE. The decomposition of R into R1
Answer
A. ,
54
Consider a relation R
Answer
C. with functional dependencies : A → B, B → C, C → A.
let R be decomposed into R1 =
55
Consider the following relations and corresponding functional dependencies.
Identify the highest normal form of the relations.
R1
Answer
D. Fds are AB → C, BC → d
R2
56
Given a relation instance T1, pick the output generated by the following
SQl statements:
roll no. marks
101 50
102 60
103 60
104 70
105 null
i. select count(*) from T1
ii. select count(marks) from T1
iii. select avg(marks) from T1
Answer
A. 5, 4,
57
Assume that data about students in a department is stored in a table, Student
(sid, name, gender, gpa, cid). What will be the following query returns ?
select cid, count(*)
from Student
where gender = “female” and gpa > (select avg(gpa) from Student)
group by cid;
The query returns:
Answer
C. For each course, the number of girl students whose gpa is higher than
average gpa of all students in the department.
58
Consider two relations : R1
Answer
A. , B,
59
Identify the incorrect statement among the following
Answer
C. The query language relational algebra is nonprocedural, whereas relational
calculus is procedural.
60
Identify the option which correct matching of the statements :
a. The statement that is automatically run by i. durability
the system as a result of the database
modification
b. Ensure that a value appears in one relation ii. Isolation
for a given set of attributes also appears
for a certain set of attributes in another
relation
c. The changes applied to the database by a iii. Referential Integrity
committed transaction must persist in the
database, even if there is system failure
d. Ensures that changes made to the iv. Stored Procedure
database by authorized users do not result
in a loss of data consistency
v. Trigger
vi. Integrity Constraints
Answer
B. a – v, b – iii, c – i, d – vi
61
Consider a relation R
Answer
B. Fd BC → d is violated, but mVd BC → → d is not violated
62
Identify the true statements about two phase locking:
i. Two phase locking ensures conflict serializability.
ii. Two phase locking does not ensure freedom from deadlock.
iii. If the timestamp of a transaction Ti is smaller than the timestamp of transaction
Tj, two phase locking ensures that the produced schedule is equivalent to a serial
schedule.
iv. Cascading rollback can be avoided using strict two phase locking.
Answer
D. i, ii, iv are correct
63
Which of the following is not an open source web server ?
Answer
C. IIS Webserver
64
Which type of language is used to create dynamic web pages ?
Answer
D. Scripting language
65
What is the correct syntax to make each word of a sentence to start with a capital
letter in CSS ?
Answer
B. text-transform : capitalize;
66
Which is the tag to create a list of items with bullets in HTml ?
Answer
A.
67
Which of the following is true about Xml ?
Answer
B. Element and attribute names are case sensitive
68
Which of the following method is used to refresh a webpage in JavaScript ?
Answer
A. location.reload()
69
Which of the following is not a valid Web Server control in ASP.NET ?
Answer
C. Timeout
70
In Visual Basic, which of the following window displays the list of projects contained
in the current solution ?
Answer
A. Solution Explorer Window
71
Which is the first event triggered when a user requests an ASP.NET page ?
Answer
B. PreInit
72
In Xml, dTd stands for
Answer
C. Document Type Definition
73
How Ajax web applications exchange data from a webserver ?
Answer
D. With call-back function
74
Which of the following is not true for SignalR ?
Answer
C. SignaIR uses request response model
75
At which layer of the OSI model does IP addressing operate ?
Answer
C. Network layer
76
In the TCP/IP model, which protocol is used to transfer web pages from servers to
clients ?
Answer
B. HTTP
77
Which of the following IEEE standards is associated with Wireless lANs (Wi-Fi) ?
Answer
A. 802.11
78
Which protocol is commonly used alongside IP to provide error reporting and
diagnostic messages ?
Answer
D. ICmP
79
What is the primary purpose of UdP in the transport layer ?
Answer
B. Fast, connectionless data transfer without reliability guarantees
80
IdEA (International data Encryption Algorithm) operates using which key size ?
Answer
A. 128 bits
81
Which attack method involves injecting malicious code into trusted websites to target
users accessing those sites ?
Answer
D. Cross-site Scripting (XSS)
82
Which of the following is a valid IPv4 address ?
Answer
A. 192.168.1.100
83
Which physical medium uses Time division multiplexing (Tdm) to reduce signal
degradation in long-distance communication ?
Answer
D. All of these
84
Which of the following correctly describes the role of the backoff algorithm in medium
access control ?
Answer
C. It allows stations to retransmit after a random delay following a collision
85
In Kerberos, which type of cryptographic key is shared between the client and the
Authentication Server
Answer
A. S) ?
86
What is the purpose of the bind() function in socket programming ?
Answer
B. To associate a socket with a local address and port
87
Which exception is thrown in Java RmI if a remote method invocation fails ?
Answer
C. RemoteException
88
What is the primary role of UddI in web services ?
Answer
Question Cancelled
89
The most distinguishing feature of this model is its ability to handle risks. Which of
the following software process model is referred here ?
Answer
B. Spiral model
90
Which of the following is not an Object Oriented methodology for Software design ?
Answer
A. Data flow diagram
91
Which of the following International Standards Organization (ISO) standard is
applicable for software product development ?
Answer
C. ISO 9001
92
_________ testing verifies the internal datastructures and algorithms of a module
during the validation phase of software development.
Answer
A. White box testing
93
_________ is qualitative indication of the degree to which a module focuses on one
thing.
Answer
C. Cohesion
94
Which of the following is false when calculating cyclomatic complexity, V(G), for a
flow graph G ?
Answer
D. The number of conditions
95
Which of the following is a system testing done among the small group of customers ?
Answer
B. Beta testing
96
Which software size metric can be used to easily estimate the size of a software
product directly from the problem specification ?
Answer
C. Function Point
97
Which of the following is a not a level of Capability maturity model developed by
Software Engineering Institute of Carnegie mellon University ?
Answer
C. Verifiable
98
If a realtime system is used to control the safety system in a car, it must detect a
possible crash and inflate an air bag before the driver’s head hits the steering wheel.
Which control model is suitable for this ?
Answer
A. Interrupt driven model
99
Which of the following requirement elicitation method is used to understand the social
and organizational requirements ?
Answer
B. Ethnography
100
Which one of the following maintenance involves enhancing functionalities of the
system according to the customer’s requirements ?
Answer
C. Perfective maintenance
Discussion
Ask a doubt or share a tip.
No comments yet — start the discussion.