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

Question

Share Report Error

Which SQL function returns the current date and time?

A. CURDATE()

B. All of the above depending on the DBMS

C. NOW()

D. GETDATE()

Answer: Option B

Solution (By JKSSB Mock Tests)

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)

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

In SQL, which clause is used to specify the table(s) from which to retrieve data?

A. WHERE

B. FROM

C. GROUP BY

D. SELECT

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The FROM clause identifies the table(s) from which data is to be selected.

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

Question #2

What is a stored procedure?

A. A view

B. A trigger

C. A set of precompiled SQL statements that can be executed as a single unit

D. An index

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A stored procedure is a named collection of SQL statements and logic stored in the database, which can be invoked by applications.

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

Question #3

Which of the following is a benefit of DBMS?

A. Data sharing among multiple users

B. Higher data redundancy

C. Limited data access

D. Increased data inconsistency

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
DBMS allows controlled data sharing while maintaining integrity and security.

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

Explore All Database Management System (DBMS) MCQs