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. BLOB

B. TEXT

C. VARCHAR

D. CHAR

Answer: Option A

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

What does a database constraint called a 'CHECK' constraint do?

A. It checks if the database server is running safely.

B. It automatically links tables together.

C. It verifies user authentication passwords.

D. It limits the range of values that can be placed in a column based on a specific condition.

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A CHECK constraint enforces domain integrity by limiting the values accepted by a column to only those that satisfy a specified Boolean predicate.

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

Question #2

What is the purpose of the SQL 'JOIN' clause?

A. To combine columns from multiple tables into a single table

B. To delete records from a table

C. To combine rows from two or more tables based on a related column

D. To create a new table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
JOIN is used to combine rows from different tables based on a common column, allowing querying across related tables.

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

Question #3

Which of the following is a characteristic of the relational model?

A. All of the above

B. Data is stored in tables

C. Data is accessed via SQL

D. Relationships are represented through keys

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The relational model organizes data in tables, uses keys for relationships, and is queried using a language like SQL.

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

Explore All Database Management System (DBMS) MCQs