FPSC Information Technology Mcqs

This category provides Information Technology (IT) MCQs for FPSC and other competitive exams. It covers key topics such as computer fundamentals, hardware, software, memory units, input/output devices, networking, internet, and Microsoft Office (Word, Excel, PowerPoint). These MCQs help candidates practice important concepts, test their knowledge, and prepare effectively for FPSC-related tests.

Which key uniquely identifies a record in a table?

A. Foreign Key

B. Primary Key

C. Candidate Key

D. Super Key

Correct answer is: B. Primary Key

Which of the following is a “Cloud Computing” service model?

A. SaaS

B. HTTP

C. HTML

D. LAN

Correct answer is: A. SaaS

Which SQL command is used to delete all records from a table without deleting the table structure?

A. DROP

B. TRUNCATE

C. DELETE

D. REMOVE

Correct answer is: B. TRUNCATE

Which component is known as the “Brain” of the computer?

A. RAM

B. CPU

C. Motherboard

D. BIOS

Correct answer is: B. CPU

The ‘ACID’ property in DBMS stands for Atomicity, Consistency, Isolation, and:

A. Data

B. Durability

C. Database

D. Degree

Correct answer is: B. Durability

1 Terabyte (TB) is equal to:

A. 1024 MB

B. 1024 GB

C. 1000 GB

D. 1024 KB

Correct answer is: B. 1024 GB

Which of the following is a NoSQL database?

A. MySQL

B. Oracle

C. MongoDB

D. PostgreSQL

Correct answer is: C. MongoDB

Which memory is non-volatile?

A. RAM

B. ROM

C. Cache

D. Registers

Correct answer is: B. ROM

A ‘Join’ operation in SQL combines:

A. Columns

B. Rows from two or more tables

C. Databases

D. Files

Correct answer is: B. Rows from two or more tables

ASCII stands for:

A. American Standard Code for Information Interchange

B. Asian Standard Code for Information Interchange

C. American Scientific Code for Interchange

D. All Standard Code for Information

Correct answer is: A. American Standard Code for Information Interchange