Question 1

Is any modification in logical level should not affect the view level?

technology databases

True
False

Answer

Correct Option: B

Question 2

select the valid Definition Languages in DBMS:

technology databases

Data Definition Language
View Definition Language
Query Definition Language
Storage Definition Language

Answer

Correct Option: A,B,D

Question 3

Low-level instruction generated by compiler are executed by DDL Interpreter.(True/False)

technology databases

True
False

Answer

Correct Option: B

Question 4

Which one of the following does not help to maintain referential integrity?

technology databases

Unique constraints
Primary keys
Cascading actions
Foreign keys

Answer

Correct Option: A

Question 5

When is the authorization check on DB2 objects done?

technology databases

at BIND time
at RUN time
at Execution time
at End time

Answer

Correct Option: B

Question 6

What is a synonym?

technology databases

A View of a table
an alternate name for a table
A Secondary table
A Primary table

Answer

Correct Option: A,B

Question 7

What is index cardinality?

technology databases

Number of distinct values a column contain
Number of distinct values a column or columns contain
Number of distinct values a row contain
Number of distinct values a row or rows contain

Answer

Correct Option: A,B

Question 8

What is filter factor?

technology databases

One divided by the number of distinct values of a column.
Zero divided by the number of distinct values of a column.
Zero divided by the number of distinct values of a row.
One divided by the number of distinct values of a Rrow.

Answer

Correct Option: A

Question 9

What is referential integrity?

technology databases

The relation of the primary key of a base table with foreign key of the reference table is known as referential integriety.
The relation of the secondary key of a base table with foreign key of the reference table is known as referential integriety.
The relation of the primary key of a secondary table with foreign key of the reference table is known as referential integriety.
The relation of the primary key of a base table with index key of the reference table is known as referential integriety.

Answer

Correct Option: A

Question 10

What is FREEPAGE and PCTFREE in TABLESPACE creation?

technology databases

PCTFREE: percentage of each page to be left free and FREEPAGE: Number of pages to be loaded with data between each free page.
PCTFREE: percentage of each page to be loaded with data and FREEPAGE: Number of pages to be loaded with data between each free page.
PCTFREE: percentage of each page to be left free and FREEPAGE: Number of pages to be left free with data between each loaded page.
PCTFREE: percentage of each page to be loaded with data between each free page and FREEPAGE: Number of pages to be left free.

Answer

Correct Option: A

Question 11

What are the 4 environments which can access DB2?

technology databases

TSO and CICS
IMS and BATCH
TSO, CICS, IMS and DB2
TSO, CICS, IMS and VSAM

Answer

Correct Option: A,B

Question 12

When will you chose to run RUNSTATS?

technology databases

After a load
After mass updates
After a deletes
After a inserts

Answer

Correct Option: A,B,C,D

Question 13

Each PL/SQL block can have its own exception section

technology databases

True
False

Answer

Correct Option: A

Question 14

PL/SQL Exception message consists of

technology databases

Type of Exception
Finally block
An Error Code
A message

Answer

Correct Option: A,C,D

Question 15

Types of PL/SQL exceptions are

technology databases

Named System Exceptions
Unnamed System Exceptions
Implicit Exceptions
Explicit Exceptions
User-defined Exceptions

Answer

Correct Option: A,B,E

Question 16

Named system exceptions are:

technology databases

Not Declared explicitly
Raised implicitly when a predefined Oracle error occurs
caught by referencing the standard name within an exception-handling routine
All of the above
None of the above

Answer

Correct Option: D

Question 17

To handle the exception explicity, they must be declared using Pragma EXCEPTION_INIT

technology databases

True
False

Answer

Correct Option: A

Question 18

When you declare your own exception, you must ____ it explicitly

technology databases

DECLARE
RAISE
PRAGMA
INITIATE

Answer

Correct Option: B

Question 19

Run-time errors arise from

technology databases

Hardware failures
Design faults
Coding mistakes
None of the above
All of the above

Answer

Correct Option: E

Question 20

___ exception is raised ___ whenever your PL/SQL program violates an Oracle rule or exceeds a system-dependent limit

technology databases

internal, explicitly
internal, implicitly
user-defined, explicitly
user-defined, implicitly

Answer

Correct Option: B

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

databases Online Quiz - 215

Find more quizzes from top tags