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?
Which three of the following methods make PL/SQL tables easier to use? (Choose three)
For which of the following tasks would it be most appropriate to use a PL/SQL WHILE loop?
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?
Which of the following architecture is used to support the agent or the application tier?
SQL is a product of ?
What is the main reason to create a reverse key index on a column