databases Online Quiz - 97
|Description: databases Online Quiz - 97|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
For an unconditional approach to a particular part of a complex PL/SQL block, which of the following control structures can be used?
Examine the statement of correlated subquery in the following cursor declaration. DECLARE CURSOR c1 IS SELECT D1.deptno, D1.loc, E1.Totalemp FROM dept D1, (SELECT deptno, COUNT(*) Totalemp FROM emp GROUP BY deptno) E1 WHERE D1.deptno = E1.deptno AND E1.Totalemp > 6; Why does this statement result in an error?
In which section is a user-defined exception trapped?
Which of the following architecture is used to support the agent or the application tier?
SQL is a product of ?
Auto commit occurs on
What is the main reason to create a reverse key index on a column