Oracle (BI_ORAAPPS) Crossword Day-2

Edit Answers
123456789
Across
  1. 2. _______________Product is the result of joining two or more tables when the where clause in Joining condition is poorly defined.
  2. 4. What is the output of the given query: SELECT DEPTNO, SUM(SAL) FROM EMP GROUP BY SUM(SAL); Outputs are a) group function is not allowed here b) not a single-group group function c)none of these options; (Answer is a, b or c).
  3. 5. See the scenario: We need to display the Customers data along with the Orders details. Though the customer has not placed any order, we should be able to track those customers with null data against respective orders. Which would be the appropriate join type to use in this case?
  4. 6. Assume, we have three departments in DEPT table as 'sales','ADMIN','mktg'. What will be the output of the Query: select min(dname) from dept?
  5. 8. The database contains two tables named SalesOrderDetail and Product. You need to ensure that all products referenced in the SalesOrderDetail table have a corresponding record in the Product table. Using ______ Constraints, you can satisfy the above mentioned requirement.
Down
  1. 1. What will be output of following Query if COMM field contain null value for 'KING': sql>select ename,nvl2(comm,'PRESIDENT','MANAGER') from emp where ename='KING '
  2. 2. Evaluate this SQL statement; SELECT empno, e.deptno, dname FROM emp e, dept d WHERE e.deptno=d.deptno; Which SQL statement is equivalent to the above SQL statement? A) SELECT empno, d.deptno, dname FROM emp WHERE deptno IN (SELECT deptno FROM dept); B)SELECT empno, d.deptno, dname FROM emp NATURAL JOIN dept; C) SELECT empno, d.deptno, dname FROM emp e JOIN dept d ON e.deptno =d.deptno; D)SELECT empno, d.deptno, dname FROM emp JOIN dept USING (e.deptno, d.deptno); (Answer is a, b,c or d).
  3. 3. What is the output of the Query: SQL>SELECT REPLACE(RTRIM('Anticipation'),'ti','shun')FROM dual;
  4. 7. We can use WILDCARD CHARACTERS in ___ clause of select statement.
  5. 9. SQL> SELECT DEPTNO, SUM(SAL) FROM EMP GROUP BY DEPTNO HAVING DEPTNO=20; whether this query will work without the errors or not (Answer is YES/NO). Consider we have referred table with given structure.