Home Tests Campus Placement Computer Knowledge

Campus Placement
Computer Knowledge

Campus placement MCQ questions — Aptitude, Verbal, Reasoning, Technical.

309 Q 4 Subjects Any Graduate
Take Mock Test
Difficulty: All Easy Medium Hard 11–20 of 309
Advertisement
Q.11 Medium Computer Knowledge Database/SQL
What is the primary difference between supervised and unsupervised machine learning?
A Supervised uses labeled data; unsupervised uses unlabeled data
B Unsupervised is faster than supervised
C Supervised cannot predict outcomes
D Unsupervised requires human supervision
Correct Answer:  A. Supervised uses labeled data; unsupervised uses unlabeled data
EXPLANATION

Supervised learning trains on labeled data (features + targets); unsupervised finds patterns in unlabeled data without predefined outputs.

Take Test
Q.12 Medium Computer Knowledge Database/SQL
In cybersecurity, what is SQL injection attack?
A Inserting legitimate SQL into database
B Malicious SQL code injected into input fields to manipulate database queries
C A method to optimize SQL performance
D Splitting SQL statements across multiple lines
Correct Answer:  B. Malicious SQL code injected into input fields to manipulate database queries
EXPLANATION

SQL injection exploits vulnerable input handling to execute unintended SQL commands, potentially exposing or modifying data.

Take Test
Q.13 Medium Computer Knowledge Database/SQL
What does normalization in machine learning context primarily aim to achieve?
A Reduce features to 2D
B Scale features to similar ranges to improve model performance
C Remove all outliers
D Increase dataset size
Correct Answer:  B. Scale features to similar ranges to improve model performance
EXPLANATION

Normalization scales features (e.g., 0-1 range) preventing features with larger scales from dominating model training.

Take Test
Q.14 Medium Computer Knowledge Database/SQL
In graph algorithms, which algorithm finds the shortest path in weighted graphs?
A DFS
B BFS
C Dijkstra's algorithm
D Topological sort
Correct Answer:  C. Dijkstra's algorithm
EXPLANATION

Dijkstra's algorithm efficiently finds shortest paths from a source node to all other nodes in weighted graphs with non-negative weights.

Take Test
Q.15 Medium Computer Knowledge Database/SQL
What is the difference between DELETE and TRUNCATE in SQL?
A DELETE is faster than TRUNCATE
B TRUNCATE is DDL; DELETE is DML and is slower but can be rolled back
C TRUNCATE cannot be rolled back while DELETE can
D Both have identical functionality
Correct Answer:  B. TRUNCATE is DDL; DELETE is DML and is slower but can be rolled back
EXPLANATION

TRUNCATE is DDL (immediate, cannot be rolled back in most databases), DELETE is DML (slower, can be rolled back).

Take Test
Advertisement
Q.16 Medium Computer Knowledge Database/SQL
In cloud computing, which service model allows customers to run their own applications but not manage infrastructure?
A IaaS
B PaaS
C SaaS
D DBaaS
Correct Answer:  B. PaaS
EXPLANATION

PaaS (Platform as a Service) provides a platform to develop and deploy applications without managing underlying infrastructure.

Take Test
Q.17 Medium Computer Knowledge Database/SQL
What is the time complexity of quicksort algorithm in the worst case?
A O(n log n)
B O(n²)
C O(n)
D O(log n)
Correct Answer:  B. O(n²)
EXPLANATION

Quicksort's worst-case complexity is O(n²) when pivot selection is poor, though average case is O(n log n).

Take Test
Q.18 Medium Computer Knowledge Database/SQL
Which normalization form eliminates all non-key dependencies?
A 1NF
B 2NF
C 3NF
D 4NF
Correct Answer:  C. 3NF
EXPLANATION

3NF (Third Normal Form) ensures all non-key attributes depend only on the primary key, eliminating transitive dependencies.

Take Test
Q.19 Easy Computer Knowledge Database/SQL
In SQL, what does the GROUP BY clause do?
A Joins multiple tables
B Aggregates rows into groups based on specified columns
C Deletes duplicate records
D Orders results alphabetically
Correct Answer:  B. Aggregates rows into groups based on specified columns
EXPLANATION

GROUP BY groups rows with identical values in specified columns, used with aggregate functions like COUNT(), SUM().

Take Test
Q.20 Easy Computer Knowledge Database/SQL
What is the main advantage of cloud computing's elasticity?
A Lower initial hardware cost
B Automatic resource scaling based on demand
C Guaranteed 100% uptime
D Elimination of all security risks
Correct Answer:  B. Automatic resource scaling based on demand
EXPLANATION

Elasticity allows automatic resource provisioning and de-provisioning based on real-time demand, reducing costs.

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