Quick Revision

GK One-Line Question & Answer

15541+ short questions with short answers, covering every category and sub-category on the site — no long articles to scroll through. Good for a fast recap before an exam, or a few minutes of daily practice.

Looking for exam process/strategy questions instead? Try the Exam Preparation FAQ →

Computer Fundamentals → Introduction to Computer 39

ACID properties of databases stand for?
Atomicity, Consistency, Isolation, Durability
click to copy
Atomicity in ACID means?
All operations in a transaction succeed or none do
click to copy
Which type of index speeds up SELECT queries?
B-tree index
click to copy
ERD stands for in database design?
Entity Relationship Diagram
click to copy
Which SQL clause filters query results?
WHERE
click to copy
HAVING clause is used with?
GROUP BY
click to copy
Which aggregate function counts rows?
COUNT()
click to copy
Stored procedure in SQL is?
A saved SQL script executed by name
click to copy
A view in SQL is?
A virtual table based on a query
click to copy
Trigger in SQL executes?
Automatically in response to INSERT/UPDATE/DELETE
click to copy
Transaction control commands include?
COMMIT, ROLLBACK
click to copy
DCL in SQL stands for?
Data Control Language
click to copy
DDL in SQL stands for?
Data Definition Language
click to copy
DML in SQL stands for?
Data Manipulation Language
click to copy
Which normal form removes partial dependencies?
2NF
click to copy
3NF removes?
Transitive dependencies
click to copy
Which type of join returns only matching rows?
INNER JOIN
click to copy
Which HTTP status code indicates unauthorized access?
401
click to copy
HTTP 403 means?
Forbidden (authenticated but no permission)
click to copy
Port 3306 is associated with?
MySQL database
click to copy
Which of the following is a graph database?
Neo4j
click to copy
Redis is primarily used as?
In-memory key-value store/cache
click to copy
Cassandra is which type of database?
Wide-column NoSQL
click to copy
Which language is used for data analysis and statistics?
R
click to copy
Which Python library is used for data analysis?
Pandas
click to copy
Which Python library is used for machine learning?
Scikit-learn
click to copy
TensorFlow is used for?
Deep learning and neural networks
click to copy
Which layer in neural network processes input?
Input layer
click to copy
Activation function in neural networks?
Introduces non-linearity
click to copy
Backpropagation is used to?
Adjust weights by propagating error backward
click to copy
Overfitting in machine learning means?
Model memorizes training data, fails on new data
click to copy
Regularization techniques prevent?
Overfitting
click to copy
Which is supervised learning?
Linear regression
click to copy
Which is unsupervised learning?
K-means clustering
click to copy
Reinforcement learning learns by?
Trial and error with rewards
click to copy
CNN in deep learning stands for?
Convolutional Neural Network
click to copy
RNN stands for?
Recurrent Neural Network
click to copy
NLP stands for?
Natural Language Processing
click to copy
Which company developed ChatGPT?
OpenAI
click to copy

Computer Fundamentals → Memory Units 1

Which SQL keyword removes duplicate rows from results?
DISTINCT
click to copy