Which of the following is a valid SQL data type for storing decimal numbers with exact precision? MCQ with Answer and Explanation

Which of the following is a valid SQL data type for storing decimal numbers with exact precision?
A. DECIMAL
B. REAL
C. DOUBLE
D. FLOAT
Answer: Option A
Solution (By JKSSB Mock Tests)
DECIMAL (or NUMERIC) is used for exact numeric values with fixed precision and scale. FLOAT, DOUBLE, REAL are approximate.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
Which of the following is a valid SQL data type for storing large binary data?
A. BLOB
B. VARCHAR
C. TEXT
D. CHAR

Correct Answer: Option A


Explanation:
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)
Question #2
What is the purpose of the SQL 'ORDER BY' clause?
A. To sort the result set
B. To filter rows
C. To group rows
D. To join tables

Correct Answer: Option A


Explanation:
ORDER BY sorts the query results in ascending or descending order based on specified columns.

This question belongs to: Computer Database Management System (DBMS)
Question #3
What is the difference between DELETE and TRUNCATE commands?
A. DELETE removes all rows; TRUNCATE removes structure
B. DELETE can be rolled back; TRUNCATE cannot (in most DBMS)
C. No difference
D. TRUNCATE can have WHERE; DELETE cannot

Correct Answer: Option B


Explanation:
DELETE is a DML command that can be rolled back and can use WHERE; TRUNCATE is a DDL command that removes all rows and cannot be rolled back (in some DBMS) and resets auto-increment counters.

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