What is the main disadvantage of using a linked list compared to arrays?
Answer: A
Linked lists require extra memory for storing pointers/references in each node, making them memory-inefficient compared to arrays.
Q.82Easy
In AWS, what does the term 'Auto Scaling' primarily ensure?
Answer: B
AWS Auto Scaling automatically adjusts the number of EC2 instances based on demand metrics like CPU utilization or network traffic.
Q.83Easy
What is the primary function of a hash table data structure?
Answer: B
Hash tables use hash functions to map keys to indices, providing O(1) average-case lookup, insertion, and deletion operations.
Q.84Easy
What is the time complexity of the binary search algorithm on a sorted array?
Answer: B
Binary search divides the search space in half with each iteration, resulting in O(log n) time complexity on sorted data.
Q.85Easy
What is the purpose of the COMMIT statement in SQL transactions?
Answer: B
COMMIT saves all changes made during the current transaction to the database permanently. Until COMMIT, changes can be rolled back using ROLLBACK.
Advertisement
Q.86Easy
Which cryptographic algorithm is currently recommended by NIST for symmetric encryption?
Answer: B
AES is the current NIST standard for symmetric encryption with key sizes of 128, 192, or 256 bits. DES is deprecated due to weak key size.
Q.87Easy
Which SQL JOIN returns only matching records from both tables?
Answer: A
INNER JOIN returns only the records that have matching values in both tables, filtering out non-matching rows.
Q.88Easy
In database indexing, which structure provides O(log n) search complexity?
Answer: B
B-Tree maintains balanced structure ensuring O(log n) search, insert, and delete operations, commonly used in databases.
Q.89Easy
Which data structure is best for implementing a priority queue in heapsort algorithm?
Answer: C
A heap (min-heap or max-heap) efficiently supports priority queue operations with O(log n) insertion and deletion.
Q.90Easy
What is the main advantage of cloud computing's elasticity?
Answer: B
Elasticity allows automatic resource provisioning and de-provisioning based on real-time demand, reducing costs.
Q.91Easy
In SQL, what does the GROUP BY clause do?
Answer: B
GROUP BY groups rows with identical values in specified columns, used with aggregate functions like COUNT(), SUM().
Q.92Easy
In a relational database, which normal form eliminates partial dependencies and is considered essential for most practical database designs?
Answer: B
3NF eliminates partial and transitive dependencies, making it the standard for practical database design. BCNF is stricter but 3NF is the most commonly implemented normalization form.
Q.93Easy
Which of the following is a characteristic of NoSQL databases that makes them suitable for handling big data in cloud environments?
Answer: B
NoSQL databases like MongoDB and Cassandra are designed for horizontal scaling and flexible schemas, making them ideal for cloud-based big data applications with varying data structures.
Q.94Easy
Which of the following represents a vulnerability in SQL query construction that can be exploited through malicious user input, and can be prevented using parameterized queries?
Answer: C
SQL injection occurs when untrusted input is concatenated into SQL queries. Parameterized queries/prepared statements separate code from data, preventing attackers from modifying query logic.
