Computer Science MCQS

Computer Science MCQ with detailed explanations for students & freshers preparing for entrance exams, various tests, interviews, competitive exams like GATE exam, interview, competitive examination and entrance exam.

📚 Table of Content

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

Normalization is used to:

A. Increase Speed

B. Reduce Data Redundancy

C. Encrypt Data

D. Backup Data

Correct answer is: B. Reduce Data Redundancy

Which is the fastest memory in a computer?

A. RAM

B. Hard Disk

C. Registers

D. SSD

Correct answer is: C. Registers