Which of the following is a valid SQL data type for a date and time? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is a valid SQL data type for a date and time?

A. DATETIME

B. DATE

C. All of the above

D. TIMESTAMP

Answer: Option C

Solution (By JKSSB Mock Tests)

Different DBMS support DATETIME, TIMESTAMP, DATE, etc. All are valid date/time types.

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 is a domain in the context of the relational model?

A. A table name

B. A primary key

C. A set of allowed values for an attribute

D. A foreign key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A domain defines the set of permissible values that an attribute can take, ensuring data consistency.

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

Question #2

What is the term for a column in a database table?

A. Tuple

B. Attribute

C. Entity

D. Relation

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
An attribute is a column or field in a table, representing a property of the entity.

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

Question #3

Which of the following best defines a Database?

A. A single file containing text

B. Software for creating spreadsheets

C. A collection of related data organized for easy access

D. Hardware used to store programs

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A database is an organized collection of related data stored electronically for efficient retrieval and management.

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

Explore All Database Management System (DBMS) MCQs