Computer Knowledge
Aptitude · Reasoning · English · CS — Corporate & Campus Interview Prep
150 Questions 5 Topics Take Test
Advertisement
Showing 111–120 of 150 questions
Q.111 Medium Database/SQL
What is the primary purpose of database replication in distributed systems?
A Improve availability and fault tolerance
B Increase query processing speed only
C Reduce storage costs
D Eliminate the need for backups
Correct Answer:  A. Improve availability and fault tolerance
Explanation:

Replication maintains copies across nodes for high availability, disaster recovery, and load distribution. It doesn't eliminate backups—they serve different purposes.

Take Test
Q.112 Medium Database/SQL
Which algorithm is commonly used for sorting in most programming language standard libraries?
A Introsort (Quicksort + Heapsort hybrid)
B Bubble Sort
C Insertion Sort
D Selection Sort
Correct Answer:  A. Introsort (Quicksort + Heapsort hybrid)
Explanation:

Modern languages use Introsort which starts with Quicksort (O(n log n) avg) but switches to Heapsort (O(n log n) worst) to avoid worst-case scenarios.

Take Test
Q.113 Medium Database/SQL
In machine learning basics, what is overfitting?
A Model learns noise in training data and performs poorly on new data
B Model fails to learn any patterns
C Model parameters are too few
D Training data is insufficient
Correct Answer:  A. Model learns noise in training data and performs poorly on new data
Explanation:

Overfitting occurs when a model memorizes training data including noise, reducing generalization. Regularization and cross-validation help prevent it.

Take Test
Q.114 Medium Database/SQL
Which of the following is a characteristic of NoSQL databases?
A Flexible schema and horizontal scalability
B Rigid schema required
C ACID compliance always guaranteed
D Requires complex joins
Correct Answer:  A. Flexible schema and horizontal scalability
Explanation:

NoSQL databases prioritize flexible schemas and horizontal scaling. They may use eventual consistency (BASE model) rather than strict ACID.

Take Test
Q.115 Medium Database/SQL
What is the purpose of database sharding?
A Distribute data across multiple servers to improve scalability
B Create backups of databases
C Encrypt sensitive data
D Perform real-time analytics
Correct Answer:  A. Distribute data across multiple servers to improve scalability
Explanation:

Sharding partitions data based on a key (e.g., user ID) across servers. This horizontal scaling improves performance and handles large datasets efficiently.

Take Test
Advertisement
Q.116 Medium Database/SQL
In AI/ML, what does a neural network's activation function do?
A Introduce non-linearity to enable learning complex patterns
B Normalize input data
C Calculate loss function
D Perform data augmentation
Correct Answer:  A. Introduce non-linearity to enable learning complex patterns
Explanation:

Activation functions (ReLU, Sigmoid, Tanh) add non-linearity, allowing neural networks to learn non-linear relationships. Without them, networks become linear classifiers.

Take Test
Q.117 Medium Database/SQL
Which of the following best describes microservices architecture?
A Breaking applications into small, independently deployable services
B Running entire application as single monolith
C Storing all data in one centralized database
D Using multiple programming languages is forbidden
Correct Answer:  A. Breaking applications into small, independently deployable services
Explanation:

Microservices decompose applications into loosely-coupled, independently deployable services. This enables scalability, flexibility, and technology diversity.

Take Test
Q.118 Medium Database/SQL
What is the purpose of connection pooling in database management?
A Reuse database connections to reduce overhead and improve performance
B Encrypt all database communications
C Backup database at regular intervals
D Monitor database queries in real-time
Correct Answer:  A. Reuse database connections to reduce overhead and improve performance
Explanation:

Connection pooling maintains a pool of reusable connections, reducing the cost of opening/closing connections repeatedly. This significantly improves application performance.

Take Test
Q.119 Medium Database/SQL
Which sorting algorithm is most efficient for nearly sorted data?
A Insertion Sort
B Merge Sort
C Heap Sort
D Quick Sort
Correct Answer:  A. Insertion Sort
Explanation:

Insertion Sort has O(n) best-case complexity for nearly sorted data. Other algorithms don't exploit this, maintaining O(n log n) regardless of initial order.

Take Test
Q.120 Medium Database/SQL
In cloud security, what is the principle of least privilege?
A Grant users only minimum permissions necessary to perform tasks
B Give all users administrator access for efficiency
C Disable security features for better performance
D Use the weakest encryption available
Correct Answer:  A. Grant users only minimum permissions necessary to perform tasks
Explanation:

Least privilege minimizes security risk by restricting access. Users get only permissions needed for their role, reducing damage from compromised accounts.

Take Test
IGET
iget AI
Online · Ask anything about exams
Hi! 👋 I'm your iget AI assistant.

Ask me anything about exam prep, MCQ solutions, study tips, or strategies! 🎯
UPSC strategy SSC CGL syllabus Improve aptitude NEET Biology tips