DBMS QUIZ
1. You
want to create report to show different jobs in each department. You do not
want to display any duplicate roles in the report. Which SELECT statement do
you use to create the report?
a. SELECT
deptno, job FROM emp;
b.SELECT
no duplicate deptno, job FROM emp;
c.SELECT
distinct deptno, job FROM emp;
d.SELECT
distinct deptno, distinct job FROM emp;
2.In which order does the Oracle server evaluate cluses?
a.HAVING,
WHERE, GROUP BY
b.WHERE,
GROUP BY, HAVING
c.GROUP
BY, HAVING, WHERE
d.WHERE,
HAVING, GROUP BY
3.In
the declarative section of PL/SQL block, you created but did not initialize a
number variable. when the block executes what will be the initial value of the
variable?
a. 0
b.null
c.It
depends on the scale and precision of the variable
d.the
block will not execute because the variable was not initialized