Computer Knowledge
Programming, networking, database and OS questions
309 Questions 5 Topics Take Test
Advertisement
Showing 61–70 of 309 questions
Q.61 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.62 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.63 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.64 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.65 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.66 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.67 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.68 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.69 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.70 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
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