WorksheetsFaculty Interview MCQ
Total questions: 50
Worksheet time: 25mins
What will be the output of the following C code?
Compile time error
Hello World! 34
Hello World! 1000
Hello World! followed by a junk value
What will be the output of the following C code?
128
-128
Depends on the compiler
None of the mentioned
What will be the output of the following C code?
1 2 3 4 5
Segmentation fault
Compilation error
Undefined behaviour
What will be the output of the following C code?
True
False
No Output will be printed
Run Time Error
What are the elements present in the array of the following C code?
5, 5, 5, 5, 5
5, 0, 0, 0, 0
5, (garbage), (garbage), (garbage), (garbage)
(garbage), (garbage), (garbage), (garbage), 5
What will be the output of the following C code?
6 -6 0 0
6 -5 0 1
-6 -6 0 1
6 -6 0 1
Which storage engine enables to access tables from a MySQL server managed by another server?
MyISAM
FEDERATED
EXAMPLE
InnoDB
Which data type is used to store data and time in MySQL?
Temporal data type
Char/Varchar
Text data type
Numeric data type
To check how MySQL would execute a SELECT query, which statement is used?
EXPLAIN
SHOW
DISPLAY
TELL
How do we write comments in HTML?
</…….>
<!……>
</……/>
<.......!>
Which of the following extensions is used to save an HTML file?
.html
.htm
Only A
Both A and B
What will be the output of the following C code?
990
9990
999 -1
99 -1
What will be the output of the following C code?
97
98
4
Runtime Error
What will be the output of the following C code ?
Run time Error
4
Compile Time Error
Syntax Error
What will be the output of the following C code ?
53 65
65 65
065 65
Syntax Error
What will be the output of the following C code ?
10
-10
-11
-9
Which clause in SQL is used to restrict the rows returned by a query?
WHERE
ORDER BY
HAVING
GROUP BY
What is the purpose of the GROUP BY clause in SQL?
To sort records
To filter records
To group records based on one or more columns
To combine records from multiple tables
Which of the following is an example of an aggregate function in SQL?
COUNT
SUM
AVG
All of the above
How many clustered indexes can be created on a single database table?
None
One
Multiple
Unlimited
To access the services of the operating system, the interface is provided by the ___________
Library
System calls
Assembly instructions
API
The priority of a process will ______________ if the scheduler assigns it a static priority.
Depends on the operating system
Change
Remain unchanged
None of the mentioned
In the Memory, the Operating System is placed _____
In the high-memory
In the low-memory
In both high and low memory
Either low or high memory based on the interrupt vector location
Which protocol does NOT guarantee packet delivery or order?
TCP
UDP
HTTP
FTP
If a subnet mask is 255.255.255.224, how many usable IP addresses does the subnet provide?
32
30
64
62
Which of the following is NOT true about HTTP/2?
It uses binary framing
It supports multiplexing over a single TCP connection
It requires encryption via TLS
It replaces TCP with QUIC
Which strategy does the Rabin-Karp algorithm use for string matching?
Brute-force comparison
Sliding window with hashing
Prefix table
Backtracking
Which of the following is not a valid Big-O complexity?
O(n!)
O(n^n)
O(log log n)
O(n^-1)
What is the main drawback of the Waterfall model?
Too flexible for large teams
Poor documentation
Late discovery of problems
Requires real-time collaboration
Black Box testing is done
To show that software is operational at its interfaces i.e. input and output
To examine internal details of code
At client side
None of the above
In a schedule where multiple transactions execute, two-phase locking protocol ensures serializability but may lead to:
Non-repeatable reads
Phantom reads
Deadlocks
Lost updates
Which of the following is TRUE about multivalued dependencies (MVDs)?
They always imply functional dependencies
They only occur in binary relations
They can be eliminated by 3NF
They are addressed in 4NF
Does the following MySQL statement belong to the “Inequality condition”?
Yes
No
Depends
None of the mentioned
What is the time complexity of inserting an element into a red-black tree in the worst case?
O(1)
O(log n)
O(n)
O(n log n)
Which of the following statements is TRUE for a min-heap?
Every level is fully filled
Each node’s key is less than or equal to its children’s
It is always a complete binary search tree
In-order traversal gives sorted order
Choose the most appropriate answer from the statements: Statement I: In datagram networks - routers hold state information about connections Statement II: In virtual circuit network - each virtual circuit requires router table space per connection
Both Statement I and Statement II are correct
Both Statement I and Statement II are incorrect
Statement I is correct but Statement II is incorrect
Statement I is incorrect but Statement II is correct
Which of the following statements about firewalls in computer networks are true?
Firewalls are only available as hardware devices and only examine traffic entering a network
Firewalls allow a user to set rules for network traffic
Firewalls will automatically stop all malicious traffic
Firewalls can be used to block access to certain websites
What is the result of evaluating the postfix expression "43*25*+b-"?
8
14
10
5
A system bus in which each data item is transferred during a time slice known in advance to both units (source and destination) is called:
MIMD
DMA
Asynchronous bus
Synchronous bus
Which of the following statements are CORRECT regarding constructors?
Constructors are invoked automatically when the objects are created
Constructors do not have return types, not even void
Constructors cannot be inherited, though a derived class can call base class constructors
Constructors can be declared as virtual
What is the output of the following code?
AB
B
Compilation Error
Run time Error
What is the output of the following XOR operation?
2
10
7
3
What is the output of the following bitwise shift operation?
-6
-8
-2
2
What is the output of the following ternary operation?
20
30
10
Error
What is the output of the following code?
0
1
2
Error
What will be the output of the following code?
10
15
11
Compilation Error
What is the output of the following code?
100
100
Hello
Compilation Error
Hello
What is the output of the following code?
False
True
True
True
False
False
True
False
What is the output of the following code?
Animal eats
Dog eats bones
Cat eats fish
Dog eats bones
Animal eats
Cat eats fish
Dog eats bones
Cat eats fish
Dog eats bones
Cat eats fish
Animal eats
What is the output of the following code?
A
B
Compile time Error
Runtime Error
