databases Online Quiz - 215
|Description: databases Online Quiz - 215|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Is any modification in logical level should not affect the view level?
select the valid Definition Languages in DBMS:
Low-level instruction generated by compiler are executed by DDL Interpreter.(True/False)
Which one of the following does not help to maintain referential integrity?
When is the authorization check on DB2 objects done?
What is a synonym?
What is index cardinality?
What is filter factor?
What is referential integrity?
What is FREEPAGE and PCTFREE in TABLESPACE creation?
What are the 4 environments which can access DB2?
When will you chose to run RUNSTATS?
Each PL/SQL block can have its own exception section
PL/SQL Exception message consists of
Types of PL/SQL exceptions are
Named system exceptions are:
To handle the exception explicity, they must be declared using Pragma EXCEPTION_INIT
When you declare your own exception, you must ____ it explicitly
Run-time errors arise from
___ exception is raised ___ whenever your PL/SQL program violates an Oracle rule or exceeds a system-dependent limit