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. All of the above depending on the DBMS

B. NOW()

C. CURDATE()

D. GETDATE()

Answer: Option A

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

Share Report

The intentional process of introducing redundant data into a normalized database structure to optimize read query performance is called what?

A. Normalization

B. Fragmentation

C. Denormalization

D. Decomposition

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Denormalization is a strategy applied to normalized databases where redundant data is selectively added to speed up complex read queries by minimizing costly table joins.

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

Question #2

Share Report

What is a pivot table in a database context?

A. A technique to rotate rows into columns for data summarization

B. A view

C. A stored procedure

D. A type of index

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Pivoting transforms data by turning unique values from one column into multiple columns, often for reporting.

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

Question #3

Share Report

Which clause is used in SQL to sort the final query result set in ascending or descending order?

A. ORDER BY

B. SORT BY

C. ARRANGE BY

D. GROUP BY

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The ORDER BY clause is used to sort the result set of a query in either ascending (default) or descending (using DESC) order.

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

Explore All Database Management System (DBMS) MCQs