0

databases Online Quiz - 97

Description: databases Online Quiz - 97
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. 0

  2. NULL

  3. Depends on the scale and precision of the datatype.

  4. Without initialization, a variable cannot be used in the executable section of the block.


Correct Option: B
  1. When you disconnect from your session abnormally

  2. After PL/SQL block is executed successfully

  3. When you issue TRUNCATE command at SQL prompt

  4. When COMMIT command is issued

  5. When each UPDATE statement is executed


Correct Option: C,D

For an unconditional approach to a particular part of a complex PL/SQL block, which of the following control structures can be used?

  1. If-Then-Else

  2. While loop

  3. GOTO

  4. DECODE


Correct Option: C
  1. SQL statements can be on one or more lines.

  2. Keywords cannot be split across lines.

  3. SQL statements are not case-sensitive, unless indicated.

  4. Keywords can be abbreviated.

  5. Place a slash on the last line in the buffer.

  6. You can use arithmetic operators in any clause of a SQL statement.


Correct Option: C,D
  1. DECLARE V_Destination_India Number;

  2. DECLARE V_123, V_213, V_132 Varchar2(10);

  3. DECLARE V_sys Boolean := 1;

  4. DECLARE V_destination_India Number(4);

  5. DECLARE V_Hiredate NOT NULL DATE := '01-JAN-00';


Correct Option: B,C,E

Which three of the following methods make PL/SQL tables easier to use? (Choose three)

  1. EXISTS

  2. SUBSTR

  3. TRIM

  4. FLOOR

  5. COUNT

  6. UPPER


Correct Option: A,C,E

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

  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


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?

  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.


Correct Option: E
  1. Declaration

  2. Execution

  3. Exception

  4. Header


Correct Option: C

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

  1. simple

  2. two tier

  3. n tier

  4. client server


Correct Option: C
  1. TO PRINT

  2. TO COPY

  3. TO CONVERT

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


Correct Option: D

SQL is a product of ?

  1. ASCII

  2. ANSCI

  3. ORACLE

  4. DBMS


Correct Option: B
  1. On any DML

  2. On any DDL

  3. On both

  4. On none


Correct Option: B
  1. Oracle Library Cache

  2. Oracle Parallel Query

  3. Oracle Recovery Manager

  4. Oracle Multithreaded Server


Correct Option: C

What is the main reason to create a reverse key index on a column

  1. The column is populated by sequence

  2. The column contains many different values

  3. The column is mainly used for value range scans

  4. The columns implementing an inverted list attribute.


Correct Option: A
  1. Small table rarely retrieved with a full table scan

  2. Large table rarely retrieved with a full table scan

  3. Small table frequently retrieved with a full table scan

  4. Large table frequently retrieved with a full table scan


Correct Option: C
- Hide questions