Which of the following is a valid SQL data type for storing large binary data? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is a valid SQL data type for storing large binary data?

A. TEXT

B. VARCHAR

C. CHAR

D. BLOB

Answer: Option D

Solution (By JKSSB Mock Tests)

BLOB (Binary Large Object) is used for storing large binary data, such as images or files.

This question belongs to: Computer Database Management System (DBMS)

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1

Share Report

Which type of lock prevents other concurrent transactions from obtaining any form of lock on the same row, securing exclusive read and write access?

A. Exclusive Lock

B. Implicit Lock

C. Static Lock

D. Shared Lock

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
An Exclusive Lock (X-lock) blocks all other locks, ensuring that only the transaction holding the lock can modify or read the protected resource.

This question belongs to: Computer Database Management System (DBMS)

Question #2

Share Report

When the same data is updated in one location but remains unchanged in another location, it creates a state of what?

A. Data Inconsistency

B. Data Independence

C. Data Security

D. Data Integrity

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Data Inconsistency occurs when different versions of the same data appear in different places due to uncontrolled data redundancy.

This question belongs to: Computer Database Management System (DBMS)

Question #3

Share Report

Which SQL command is used to add new rows of data into an existing table?

A. ADD

B. UPDATE

C. APPEND

D. INSERT

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The INSERT command is a Data Manipulation Language (DML) statement used to add new records/rows to a table.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs