Statewise Prepration
Govt. Examwise MCQ
431 MCQ Questions in english हिन्दी
Indexing in DBMS:
Improves retrieval performance at cost of space.
NoSQL databases are designed for:
Schema-less storage like JSON docs or key-value pairs.
ACID properties ensure:
Atomicity, consistency, isolation, durability.
A primary key:
Ensures each record is unique.
SQL stands for:
Used to manage relational databases.
SQL stands for:
Used to manage relational databases.
API stands for:
Interface for software component interaction.
RAID level that mirrors data:
RAID 1 — redundancy through duplication.
Virtual memory uses:
Enables running larger programs than physical RAM.
Multitasking OS can run:
Handles concurrent processes.
Two-factor authentication adds:
Enhances account security (e.g. code + password).
A firewall is used to:
Network security barrier
Phishing is:
deceitful emails/websites to steal info.
What does VPN do?
Protects privacy via secure tunneled connection.
Which is a symmetric encryption algorithm?
AES — same key for encryption/decryption.
DNS maps:
Translates human-friendly names to IPs.
HTTP uses which port by default?
Port 80 — standard web traffic.
IP address uniquely identifies:
End device in network communication.
TCP stands for:
Reliable, connection-oriented transport protocol.
OSI model has how many layers?
Seven — layers from physical to application.
A full binary tree of height h has:
Maximum nodes in perfectly balanced tree.
Merge sort’s time complexity is:
Efficient, stable sort.
Big O of binary search on sorted array:
Logarithmic time — halving search space each step.
Which structure uses key-value pairs?
Hash map — fast lookups.
Who was the longest-serving Chief Minister of Uttar Pradesh?
Explanation: Yogi Adityanath became the longest-serving Chief Minister in UP’s history by surpassing previous leaders like Sampurnanand. His second term and uninterrupted leadership since 2017 contribute to this record. His tenure is marked by policy and infrastructure reforms.
The Chief Secretary of Uttar Pradesh is appointed by:
Explanation: The Chief Secretary is the top bureaucrat in the state and is appointed by the Chief Minister. Though officially under the Governor’s name, the appointment is made on CM’s advice. The role includes coordinating all administrative functions.
The first woman Chief Minister of Uttar Pradesh was:
Explanation: Sucheta Kripalani became the first woman Chief Minister of Uttar Pradesh in 1963. She was also the first woman to hold such a post in any Indian state. She played a significant role in the independence movement and in state politics.
Which of the following Chief Ministers of Uttar Pradesh later became the Prime Minister of India?
Explanation: Charan Singh served as the Chief Minister of UP and later became the fifth Prime Minister of India. He was a leader of the farmer community and promoted agrarian policies. His tenure as PM was brief but historically important.