Tag: databases

select next_day('19-SEP-09','FRIDAY') from dual and select next_day('19-SEP-09',7) from dual would results in?(answers in mm/dd/yyyy formate)

which of the following comes under General Functions category in Single Row Functions

select round(139.898,-2),round(188.898,-2) from dual would results in?

state true or false can we apply Round() to the column whose datatype is declared as DATE?

select substr('DECCANPARK',-5,6) FROM DUAL

The database administrator of your company created a public synonum called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query: SELECT * FROM HR;

What is the result of the query "Select length(to_char(to_date(11032007,'ddmmyyyy'),'March')) from dual;" ?

When we use DISTINCT keyword in a SELECT query it will sort the output by the column-name we specified in the DISTINCT clause.

The output of the query " Select length(to_char(2000,'9999')) from dual; " is 4.

The output of the query " Select length(substr('SQL Functions',-10,12)) from dual; " is