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

Which SQL function returns the current date and time?
A. CURDATE()
B. GETDATE()
C. NOW()
D. All of the above depending on the DBMS
Answer: Option D
Solution (By JKSSB Mock Tests)
Different DBMSs have different functions: MySQL NOW(), SQL Server GETDATE(), etc. But all return current date/time.

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 the purpose of the REVOKE command in SQL?
A. To rollback a transaction
B. To delete a table
C. To remove user permissions
D. To create a user

Correct Answer: Option C


Explanation:
REVOKE is used to take away privileges previously granted to users.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which database model improves upon the hierarchical model by allowing a child record to have multiple parent records, creating a graph-like structure?
A. Network Model
B. Star Schema
C. Relational Model
D. Flat File Model

Correct Answer: Option A


Explanation:
The Network Model represents data as graphs where a record (node) can have multiple parent and child records, solving the strict single-parent limitation of hierarchical systems.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which concept represents a temporary workspace in memory used by database engines to fetch, manipulate, and navigate through query rows one at a time?
A. Index
B. View
C. Trigger
D. Cursor

Correct Answer: Option D


Explanation:
A Cursor is a database control structure that allows an application or script to traverse over the records of a query result set row by row.

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