Tag: databases

bitmap index should be created on columns which have high cardinality

what is max length of table name in oracle

Oracle is written in which language

Answer the below query.. select to_date('01-01-51','DD-MM-YY') from dual ;

Answer the below query.. select to_date('01-01-51','DD-MM-RR') from dual

The out put of the below two queries will be same 1.select to_date('01-01-99','DD-MM-YY') from dual 2.select to_date('01-01-99','DD-MM-RR') from dual

The output of the below two queries will be same. 1.select to_date('01-01-00','DD-MM-YY') from dual 2.select to_date('01-01-00','DD-MM-RR') from dual

Output of the below query will be.. select '#' from dual;

Output of the below query.. select # from dual;

Output of the below two queries would be same.. 1.select 1 from dual; 2.select '1' from dual;