Test Your SQL Basics - Part_2
Conversion Functions Questions 1. What will be the outcome of the following query? SELECT ROUND(144.23,-1) FROM dual; 140 144 150 100 2. Which of the following commands is used to count the number of rows and non-NULL values in Oracle database? NOT NULL INSTR SUBSTR COUNT 3. Which of the following statements are true regarding the single row functions? They accept only a single argument. They can be nested only to two levels. Arguments can only be column values or constants. They can return a data type value different from the one that is referenced. 4. Which of the following type of single-row functions cannot be incorporated in Oracle DB? Character Numeric Conversion None of the above 5. Which of the following is true for the statement given as under. NVL2 (arg1, arg2, arg3) Arg2 and Arg3 can have any data type Arg1 cannot have the LONG data type Oracle will convert the data type of expr2 according to Arg1 If Arg2 is a NUMBER, then Oracle determines the nume...