Which SQL function returns the current date and time? MCQ with Answer and Explanation

Question Report Error

Which SQL function returns the current date and time?

A. GETDATE()

B. All of the above depending on the DBMS

C. NOW()

D. CURDATE()

Answer: Option B

Solution (By JKExamLibrary)

Different DBMSs have different functions: MySQL NOW(), SQL Server GETDATE(), etc. But all return current date/time.

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

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1 Report Error

DCL commands in SQL include:

A. CREATE and DROP

B. INSERT and UPDATE

C. SELECT and JOIN

D. GRANT and REVOKE

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
Data Control Language (DCL) commands manage access permissions.

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

Question #2 Report Error

Which of the following is a characteristic of a DBMS?

A. Data redundancy control

B. Security and access control

C. Data independence

D. All of the above

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
A DBMS provides features like data independence, reduced redundancy, security, and concurrent access.

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

Question #3 Report Error

The process of organizing a relational database schema to minimize data redundancy and prevent update anomalies is called what?

A. Denormalization

B. Generalization

C. Normalization

D. Aggregation

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Normalization is the systematic process of structuring relational database schemas to eliminate redundant data and maintain data integrity through decomposition.

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

Explore All Database Management System (DBMS) MCQs