• databases Online Quiz - 215
Back
0

databases Online Quiz - 215

Description: databases Online Quiz - 215
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

select the valid Definition Languages in DBMS:

technology databases

  1. Data Definition Language

  2. View Definition Language

  3. Query Definition Language

  4. Storage Definition Language

Show answer
Correct Option: A,B,D

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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

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

technology databases

  1. Unique constraints

  2. Primary keys

  3. Cascading actions

  4. Foreign keys

Show answer
Correct Option: A

When is the authorization check on DB2 objects done?

technology databases

  1. at BIND time

  2. at RUN time

  3. at Execution time

  4. at End time

Show answer
Correct Option: B

What is a synonym?

technology databases

  1. A View of a table

  2. an alternate name for a table

  3. A Secondary table

  4. A Primary table

Show answer
Correct Option: A,B

What is index cardinality?

technology databases

  1. Number of distinct values a column contain

  2. Number of distinct values a column or columns contain

  3. Number of distinct values a row contain

  4. Number of distinct values a row or rows contain

Show answer
Correct Option: A,B

What is filter factor?

technology databases

  1. One divided by the number of distinct values of a column.

  2. Zero divided by the number of distinct values of a column.

  3. Zero divided by the number of distinct values of a row.

  4. One divided by the number of distinct values of a Rrow.

Show answer
Correct Option: A

What is referential integrity?

technology databases

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

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

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

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

Show answer
Correct Option: A

What is FREEPAGE and PCTFREE in TABLESPACE creation?

technology databases

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

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

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

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

Show answer
Correct Option: A

What are the 4 environments which can access DB2?

technology databases

  1. TSO and CICS

  2. IMS and BATCH

  3. TSO, CICS, IMS and DB2

  4. TSO, CICS, IMS and VSAM

Show answer
Correct Option: A,B

When will you chose to run RUNSTATS?

technology databases

  1. After a load

  2. After mass updates

  3. After a deletes

  4. After a inserts

Show answer
Correct Option: A,B,C,D

Each PL/SQL block can have its own exception section

technology databases

  1. True

  2. False

Show answer
Correct Option: A

PL/SQL Exception message consists of

technology databases

  1. Type of Exception

  2. Finally block

  3. An Error Code

  4. A message

Show answer
Correct Option: A,C,D

Types of PL/SQL exceptions are

technology databases

  1. Named System Exceptions

  2. Unnamed System Exceptions

  3. Implicit Exceptions

  4. Explicit Exceptions

  5. User-defined Exceptions

Show answer
Correct Option: A,B,E

Named system exceptions are:

technology databases

  1. Not Declared explicitly

  2. Raised implicitly when a predefined Oracle error occurs

  3. caught by referencing the standard name within an exception-handling routine

  4. All of the above

  5. None of the above

Show answer
Correct Option: D

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

technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

technology databases

  1. DECLARE

  2. RAISE

  3. PRAGMA

  4. INITIATE

Show answer
Correct Option: B

Run-time errors arise from

technology databases

  1. Hardware failures

  2. Design faults

  3. Coding mistakes

  4. None of the above

  5. All of the above

Show answer
Correct Option: E

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

  1. internal, explicitly

  2. internal, implicitly

  3. user-defined, explicitly

  4. user-defined, implicitly

Show answer
Correct Option: B
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions