1) What statement would return the following about clerks in each department ?
DEPTNO MIN(SAL) MAX(SAL
10 1300 1300
20 800 1100
A. Select deptno, MIN(sal), MAX(sal)
WHERE job = 'CLERK' GROUP BY deptno
B. SELECT deptno, MIN(sal), MAX(sal)
GROUP BY deptno;
C. Select deptno, MIN(sal), MAX(sal)
FROM emp WHERE job = 'CLERK'
D. SELECT deptno, MIN(sal), MAX(sal)
FROM emp WHERE job = 'CLERK' GROUP BY deptno;
E. SELECT deptno, MIN, MAX
FROM emp WHERE job = 'CLERK' GROUP BY deptno;
2) You are evaluating a procedure that has the function MOD(100,10). What would be the result ?
A. 10000
10
100
0
1000
3) There are four categories of SQL operations. What is the category for operations that include REVOKE, ALTER USER and GRANT ?
A) DCL (Data Control Language)
B. DDL (Data Definition Language)
C). DDL (Data Definition Language)
D. TCO (Transaction Control Operations)
4) What are the maximum number of columns that can be returned when used with ORDER BY ?
128
B. Equal to the number of columns in the table
255
D. There is no maximum
5) What are the three major theoretical characteristics of an RDBMS ?
A. Integrity
Operations -- actions that act upon the data and structures.
C) Instance
Structures -- are objects like tables, indexes and view
D) Field
E. Records