Tag: databases

Questions Related to databases

For which of the following tasks would it be most appropriate to use a PL/SQL WHILE loop?
technology databases

  1. To add six new services to the SERVICE table

  2. To change MACHINE_ID 123456 to 456789 and change all others to 900000

  3. To change MACHINE_ID 123456 to 456789

  4. To add new services to the SERVICE table until finished

Show answer
Correct Option: D

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?
technology databases

  1. Parameter has to be used in this cursor to make its execution successful.

  2. Correlated subquery cannot be used in CURSOR declaration.

  3. Correlated FROM clause subquery cannot be used in CURSOR declaration.

  4. AND logical operator cannot be used in WHERE clause of cursor declaration.

  5. No logical error.

Show answer
Correct Option: E

In which section is a user-defined exception trapped?
technology databases

  1. Declaration

  2. Execution

  3. Exception

  4. Header

Show answer
Correct Option: C

Which of the following architecture is used to support the agent or the application tier?
technology databases

  1. simple

  2. two tier

  3. n tier

  4. client server

Show answer
Correct Option: C

What is the purpose of SET DBMSSERVER OUTPUT ON
technology databases

  1. TO PRINT

  2. TO COPY

  3. TO CONVERT

  4. TO SEE THE RESULT OF PL/SQL PROGRAMS ON DISPLAY

Show answer
Correct Option: D

SQL is a product of ?
technology databases

  1. ASCII

  2. ANSCI

  3. ORACLE

  4. DBMS

Show answer
Correct Option: B

How many normalization processes are available in RDBMS
technology databases

  1. 2

  2. 3

  3. 6

  4. 12

Show answer
Correct Option: C

How many constraints are available in SQL
technology databases

  1. 1

  2. 2

  3. 3

  4. 5

Show answer
Correct Option: D

Auto commit occurs on
technology databases

  1. On any DML

  2. On any DDL

  3. On both

  4. On none

Show answer
Correct Option: B

Which component will never allocate memory from the larger pool
technology databases

  1. Oracle Library Cache

  2. Oracle Parallel Query

  3. Oracle Recovery Manager

  4. Oracle Multithreaded Server

Show answer
Correct Option: C