Computer Knowledge
Aptitude · Reasoning · English · CS — Corporate & Campus Interview Prep
309 Questions 5 Topics Take Test
Advertisement
Showing 241–250 of 309 questions
Q.241 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.242 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
Q.243 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.244 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.245 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
Advertisement
Q.246 Hard Database/SQL
In cybersecurity, what is a zero-day vulnerability?
A A security flaw unknown to vendors with no patch available
B A vulnerability found on the first day of software release
C A virus that activates at midnight
D A type of brute-force attack
Correct Answer:  A. A security flaw unknown to vendors with no patch available
Explanation:

Zero-day vulnerabilities are previously unknown exploits with no patch. They're extremely dangerous because users have no defense until vendors develop and release fixes.

Take Test
Q.247 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.248 Hard Database/SQL
What does BASE model in NoSQL stand for?
A Basically Available, Soft state, Eventually consistent
B Batch Available, System Events, Eventual consistency
C Buffer Availability, Strong consistency, Event-driven
D Backup Availability, Security-first, Efficient
Correct Answer:  A. Basically Available, Soft state, Eventually consistent
Explanation:

BASE is an alternative to ACID, prioritizing availability and partition tolerance. It accepts temporary inconsistencies that resolve eventually (eventual consistency).

Take Test
Q.249 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
Q.250 Easy Database/SQL
Which of the following is a ACID property that ensures all or nothing transaction execution?
A Atomicity
B Consistency
C Isolation
D Durability
Correct Answer:  A. Atomicity
Explanation:

Atomicity ensures that a transaction is treated as a single unit - either all operations complete or none do.

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