For which of the following tasks would it be most appropriate to use a PL/SQL WHILE loop?
To add six new services to the SERVICE table
To change MACHINE_ID 123456 to 456789 and change all others to 900000
To change MACHINE_ID 123456 to 456789
To add new services to the SERVICE table until finished
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?
Parameter has to be used in this cursor to make its execution successful.
Correlated subquery cannot be used in CURSOR declaration.
Correlated FROM clause subquery cannot be used in CURSOR declaration.
AND logical operator cannot be used in WHERE clause of cursor declaration.
No logical error.
In which section is a user-defined exception trapped?
Declaration
Execution
Exception
Header
Which of the following architecture is used to support the agent or the application tier?
simple
two tier
n tier
client server
What is the purpose of SET DBMSSERVER OUTPUT ON
TO PRINT
TO COPY
TO CONVERT
TO SEE THE RESULT OF PL/SQL PROGRAMS ON DISPLAY
SQL is a product of ?
ASCII
ANSCI
ORACLE
DBMS
How many normalization processes are available in RDBMS
2
3
6
12
How many constraints are available in SQL
1
5
Auto commit occurs on
On any DML
On any DDL
On both
On none
Which component will never allocate memory from the larger pool
Oracle Library Cache
Oracle Parallel Query
Oracle Recovery Manager
Oracle Multithreaded Server