Question 1

Suppose in the declaration section of a PL/SQL block, you create but do not initialize a NUMBER variable. What will be the initial value of the variable when the block is executed?

technology databases

0
NULL
Depends on the scale and precision of the datatype.
Without initialization, a variable cannot be used in the executable section of the block.

Answer

Correct Option: B

Question 2

A user executes a PL/SQL block containing complex data with several update and insert statements using multiple row subqueries and complex inline view. Under which of the following conditions will the database save the change after executing one or more PL/SQL blocks? (Choose two)

technology databases

When you disconnect from your session abnormally
After PL/SQL block is executed successfully
When you issue TRUNCATE command at SQL prompt
When COMMIT command is issued
When each UPDATE statement is executed

Answer

Correct Option: C,D

Question 3

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

technology databases

If-Then-Else
While loop
GOTO
DECODE

Answer

Correct Option: C

Question 4

You are declaring a variable of data type NUMBER in a PL/SQL block. During the execution of the PL/SQL block, a query returns seven rows, and the next FETCH statement is issued. If the variable was assigned a value by using %ROWCOUNT attribute, which of the following values will be stored in it?

technology databases

0
8
7
NULL

Answer

Correct Option: C

Question 5

Which of the following statements about an SQL statement are not correct? (Choose two)

technology databases

SQL statements can be on one or more lines.
Keywords cannot be split across lines.
SQL statements are not case-sensitive, unless indicated.
Keywords can be abbreviated.
Place a slash on the last line in the buffer.
You can use arithmetic operators in any clause of a SQL statement.

Answer

Correct Option: C,D

Question 6

Suppose you have to remove a table. There are several indexes associated with this table. Which among the following would remove all the indexes associated with the table?

technology databases

DROP INDEX
ALTER TABLE ....... DROP PRIMARY KEY CASCADE
ALTER TABLE ....... DROP CONSTRAINT
DROP TABLE

Answer

Correct Option: D

Question 7

Which of the following are not legal?

technology databases

DECLARE V_Destination_India Number;
DECLARE V_123, V_213, V_132 Varchar2(10);
DECLARE V_sys Boolean := 1;
DECLARE V_destination_India Number(4);
DECLARE V_Hiredate NOT NULL DATE := '01-JAN-00';

Answer

Correct Option: B,C,E

Question 8

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

technology databases

EXISTS
SUBSTR
TRIM
FLOOR
COUNT
UPPER

Answer

Correct Option: A,C,E

Question 9

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

technology databases

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

Answer

Correct Option: D

Question 10

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

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.

Answer

Correct Option: E

Question 11

In which section is a user-defined exception trapped?

technology databases

Declaration
Execution
Exception
Header

Answer

Correct Option: C

Question 12

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

technology databases

simple
two tier
n tier
client server

Answer

Correct Option: C

Question 13

What is the purpose of SET DBMSSERVER OUTPUT ON

technology databases

TO PRINT
TO COPY
TO CONVERT
TO SEE THE RESULT OF PL/SQL PROGRAMS ON DISPLAY

Answer

Correct Option: D

Question 14

SQL is a product of ?

technology databases

ASCII
ANSCI
ORACLE
DBMS

Answer

Correct Option: B

Question 15

How many normalization processes are available in RDBMS

technology databases

2
3
6
12

Answer

Correct Option: C

Question 16

How many constraints are available in SQL

technology databases

1
2
3
5

Answer

Correct Option: D

Question 17

Auto commit occurs on

technology databases

On any DML
On any DDL
On both
On none

Answer

Correct Option: B

Question 18

Which component will never allocate memory from the larger pool

technology databases

Oracle Library Cache
Oracle Parallel Query
Oracle Recovery Manager
Oracle Multithreaded Server

Answer

Correct Option: C

Question 19

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

technology databases

The column is populated by sequence
The column contains many different values
The column is mainly used for value range scans
The columns implementing an inverted list attribute.

Answer

Correct Option: A

Question 20

What is the best table to be cached?

technology databases

Small table rarely retrieved with a full table scan
Large table rarely retrieved with a full table scan
Small table frequently retrieved with a full table scan
Large table frequently retrieved with a full table scan

Answer

Correct Option: C

Description: databases Online Quiz - 97
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 97

Find more quizzes from top tags