Use NVL function to provide an alternate value to a column when NULL.ДЎ7. SELECT NVL(TO_CHAR(MONTHS_BETWEEN(START_DATE,END_DATE)),вЂ™In ProgressвЂ™) FROM training ДЄnswer: A, D.SELECT NVL(MONTHS_BETWEEN(START_DATE,END_DATE),вЂ™In ProgressвЂ™) FROM training.SELECT TO_DATE (NVL(SYSDATE-END_DATE,SYSDATE)) FROM training.SELECT NVL (ADD_MONTHS (END_DATE,1),SYSDATE) FROM training.Which two SQL would execute successfully? (Choose two) Examine the TRAINING table as given below: Name Null? Type Raises exception 'ORA-01756: quoted string not properly terminated'ДЎ6.'Tutorial''s Point compiles technical tutorials'.Tutorial's Point compiles technical tutorials.Tutorial''s Point compiles technical tutorials.Determine the output of the below query SELECT 'Tutorial''s Point compiles technical tutorials' FROM DUAL Any arithmetic operation with NULL results in NULL.ДЎ5. SELECT null||'test'||null as вЂњTestвЂќ from dual ДЄnswer: B, D.SELECT 'this is a '||null||'test with nulls' from dual.Which expressions do NOT return NULL values? Subtraction between two dates results in numeric difference of days between the two datesДЎ4. The query raises error since arithmetic operations cannot be performed on date columnsДЄnswer: B.Determine the type of output returned by the below query SELECT sysdate - hiredate The DUAL table in Oracle is owned by SYS and contains one column DUMMY of type VARCHAR2(1).ДЎ3. A table with the name DUAL can be created by a user in its own schemaДЄnswer: B, C, D.DUAL table owned by SYS cannot be dropped.DUAL table contains only one character type column known as DUMMY.DUAL table is a temporary table in Oracle database.Which of the below statements correctly describle the DUAL table in Oracle? The expression (sysdate-hiredate) returns the number of employment days of an employee with the company.ДЎ2. The query raises exception 'ORA-00932: inconsistent datatypes: expected NUMBER got DATE'ДЄnswer: C.Number of days spent by employee with the company.Number of days in the year when an employee was hired.Interpret the output returned by the below SELECT query SELECT ename, (sysdate - hiredate) Expressions within the brackets hold the highest precedence level.ДЎ1. From the below operators, which one of them holds the highest precedence level?ДЄnswer: C. Addition, subtraction and Concatenation are the operations permitted for date and timestamp columns.ДЎ0. Which of the following operations are permitted for date and timestamp columns?ДЄnswer: B, C, and D. The keyword DISTINCT is used to filter out the duplicate rows from the SELECT query.Д©. SELECT empno, DISTINCT deptno FROM emp ДЄnswer: B & C.Write a SELECT query to list down unique departments from EMP table? Only one WHERE clause is allowed in a SELECT query.ДЁ. It can use function as one of the operand. The WHERE clause must have comparison operator to evaluate the condition. There can be multiple WHERE clause in a SELECT queryДЄnswer: C.Functions can be used as operands in the WHERE clause.Comparison operator is an optional element in WHERE clause condition.Column Alias can be used in WHERE clause to refer a column.Which of the following statements are correct about the WHERE clause? The WHERE clause is an optional clause in the SELECT query which can be used only once to restrict the number of rows.Д§. What is the maximum number of WHERE clauses that can be included in a SELECT query?ДЄnswer: A. The WHERE clause is an optional clause in the SELECT query which is only used to restrict the number of rows.Д¦. What is the minimum number of WHERE clauses that must be present in a SELECT query?ДЄnswer: C. In all other scenarios, either TRUE or FALSE is returned.ДҐ. If the result of the condition in WHERE clause is not known, NULL is returned. Which of the following values can NOT be returned after evaluation of WHERE clause condition?ДЄnswer: A. Table Name is not required in the WHERE clause predicate.Д¤. What are the elements NOT contained in the WHERE clause predicate of the SELECT query?ДЄnswer: D. The WHERE clause can be used to compare the values from columns, literals, arithmetic functions and functions.ДЈ. Choose the database elements whose values can be compared in a WHERE clause of a SELECT query.ДЄnswer: A, D. The WHERE clause is used to restrict the number of rows returned from a SELECT query.Дў. Which of the following clause is used to limit the number of rows retrieved from a SELECT query?ДЄnswer: B.

What is ztreewin character sort order