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. 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.

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 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

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

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

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

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

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

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)

Explore All Database Management System (DBMS) MCQs