RelationalDBDesign

SiteMap

SQL Functions «Prev

Oracle 26ai Date Functions - Quiz

Five Oracle 26ai questions, one point each. Select one answer per question. Missing or invalid answers receive no point. The quiz checks your selected answers; it does not execute SQL.

1.	In Oracle 26ai, assume the table and DATE columns exist. What is wrong with this statement? `SELECT DATEDIFF(days, FirstDate, SecondDate), FirstDate, SecondDate FROM MyTable;` Select one answer.
	A.	The time unit must be DAY, not days.
	B.	MyTable must also be a function argument.
	C.	A SELECT cannot contain other columns alongside DATEDIFF.
	D.	Nothing is wrong.

2.	Which Oracle 26ai query counts calendar DAY boundaries from January 1, 1998 to the current database date/time? Select one answer.
	A.	`SELECT DAYCOUNT(DAY, DATE '1998-01-01', SYSDATE) FROM DUAL;`
	B.	`SELECT DATEDIFF(DAY, DATE '1998-01-01') FROM DUAL;`
	C.	`SELECT DATEDIFF(WEEK, DATE '1998-01-01', SYSDATE) * 7 FROM DUAL;`
	D.	`SELECT DATEDIFF(DAY, DATE '1998-01-01', SYSDATE) FROM DUAL;`

3.	What datetime value does this Oracle 26ai statement return (regardless of display format)? `SELECT DATEADD(MONTH, -1, TIMESTAMP '2023-04-30 11:24:54 +01:00') FROM DUAL;` Select one answer.
	A.	2023-03-30 11:24:54 +01:00
	B.	2023-03-31 11:24:54 +01:00
	C.	NULL because March has no 30th day.
	D.	An error because negative increments are not allowed.

4.	Which expression returns the current database date and time as an Oracle DATE value, without function parentheses? Select one answer.
	A.	GETDATE()
	B.	NOW()
	C.	SYSDATE
	D.	CURDATE()

5.	What does this Oracle 26ai expression return? `DATEDIFF(DAY, TIMESTAMP '2026-10-01 23:59:00', TIMESTAMP '2026-10-02 00:01:00')` Select one answer.
	A.	0, because fewer than 24 hours have elapsed.
	B.	1, because one midnight boundary is crossed.
	C.	2, because two minutes have elapsed.
	D.	An error because DAY requires DATE rather than TIMESTAMP inputs.