databases Online Quiz - 85
Description: databases Online Quiz - 85 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Which two are attributes of iSQL*Plus? (Choose two)
union all is faster than union
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 ;
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;
How many rows records the following query will display.. select * from TEMP where rownum between 0 and 3 ? N.R. Temp table has 30 records
How many rows records the following query will display.. select * from TEMP where rownum in (1,3); N.R. Temp table has 30 records