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)
syntax error and 09/26/2009,
09/25/2009 and 09/25/2009
09/25/2009 and syntax error
09/25/2009,09/26/2009
which of the following comes under General Functions category in Single Row Functions
COALESCE()
NVL()
NVL2()
CASE
select round(139.898,-2),round(188.898,-2) from dual would results in?
139.89,188.89
100,200
-139.89,-188.89
140,189
state true or false can we apply Round() to the column whose datatype is declared as DATE?
True
False
select substr('DECCANPARK',-5,6) FROM DUAL
ERROR
NPARK
DECCAN
NULL
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;
You obtain the results retrieved from the public synonym HR created by the DBA.
You obtain the results retrieved from the HR table that belongs to you schema.
You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
You obtain the results retrieved from both the publich synonym HR and the HR table that belongs to your schema, as a Cartesian product.
What is the result of the query "Select length(to_char(to_date(11032007,'ddmmyyyy'),'March')) from dual;" ?
3
5
9
Error
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
12
10
13
error