• databases Online Quiz - 211
Back
0

databases Online Quiz - 211

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

Which condition in your database forces you to perform only consistent backups?
technology databases

  1. The database is in mount state.

  2. One of the tablespaces is offline.

  3. One of the tablespaces is read only.

  4. The database operates in ARCHIEVELOG mode.

  5. The database operates in NOARCHIEVELOG mode.

Show answer
Correct Option: E

Which statement regarding the contents of the V$PARAMETER view is true?

technology databases

  1. Displays only the list of default values

  2. Displays only the list of all basic parameters

  3. Displays the currently in effect parameter values

  4. Displays only the list of all advanced parameters

  5. Displays the list of all the parameter files of a database

  6. Displays the current contents of the server parameter file.

Show answer
Correct Option: C

Which type of backup would be appropriate in NOARCHIVELOG mode?
technology databases

  1. Hot backup

  2. Online backup

  3. consistent backup

  4. incremental backup

  5. inconsistent backup

Show answer
Correct Option: C

Which is the only sys view which can be modified ?
technology databases

  1. col$

  2. aud$

  3. row$

  4. none

Show answer
Correct Option: B

What is meant by an index scan
technology databases

  1. When an entire index is scanned to locate rows we call it as index scan

  2. When only part of the index is scanned to locate rows we call it as index scan

  3. When all the rows are scanned we call it as index scan

  4. None of the above

Show answer
Correct Option: A

What does SPUFI stands for

technology databases

  1. SQL Programming Using File Input

  2. SQL Processing Using File Input

  3. SQL Processor Using File Input

  4. Sequence Processing Using File Input

Show answer
Correct Option: C

A key made up of more than one column is called
technology databases

  1. Complex Key

  2. Secondary Key

  3. Composite Key

  4. Foreign Key

Show answer
Correct Option: C

For which database object can a lock be obtained

technology databases

  1. a database directory

  2. a database tablespace

  3. a database bufferpool

  4. a database column

Show answer
Correct Option: B

What is the purpose of the COLLECTION parameter of precompile/bind parameter
technology databases

  1. define the name of the package

  2. provide an alias for the package

  3. define the schema of the package

  4. define the database of the package

Show answer
Correct Option: C

Which type of cursor should be used so that its position will be maintained between transactions
technology databases

  1. FOR HOLD

  2. FOR UPDATE

  3. FOR FETCH

  4. WITH HOLD

Show answer
Correct Option: D

What is the function of DB2 pre-compiler
technology databases

  1. Removes all the statements in source code

  2. Replaces all the SQL statements into corresponding host language CALL statements

  3. Replaces SQL statements into corresponding host language statements

  4. None of the above

Show answer
Correct Option: B

Where is the isolation level specified
technology databases

  1. BIND

  2. REBIND

  3. Both A & B

  4. None of the above

Show answer
Correct Option: C

Which SQLCODE is used to check for duplicate index on a column

technology databases

  1. -803

  2. -811

  3. -805

  4. -855

Show answer
Correct Option: A

A Package is

technology databases

  1. A single, bound DBRM

  2. A Multi bound DBRM with optimised access paths

  3. A Single bound DBRM with optimised access paths

  4. A Multi bound DBRM

Show answer
Correct Option: C

What does DBRM contain
technology databases

  1. Edited form of the SQL statements with some additional information

  2. Complied version of SQL statements

  3. Complied version of source code

  4. None of the above

Show answer
Correct Option: A

Which is the system that DB2 uses for locking

technology databases

  1. LOCK Manager

  2. Resource Manager

  3. IRLM

  4. None of the above

Show answer
Correct Option: C

A Plan

technology databases

  1. Is an executable module containing access path logic provided by the DB2 optimiser

  2. In an non executable module containing access path logic provide by the DB2 optimiser

  3. Is just a module containing access path to DB2 optimiser

  4. Is a module containing access path

Show answer
Correct Option: A

What will the FREE command do to a plan

technology databases

  1. It will drop the existing plan

  2. It will delete the existing plan

  3. Both a & b

  4. None of the above

Show answer
Correct Option: C

Can a UNION and a JOIN be used in the same SELECT statement

technology databases

  1. YES

  2. NO

  3. Cant say

  4. Depends on the query

Show answer
Correct Option: B

Bind component Produces

technology databases

  1. Only Package

  2. Only application plan

  3. Both A & B

  4. None of the above

Show answer
Correct Option: C
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3600 Quizzes
119725 Questions
 technology
307 Quizzes
36705 Questions
 sports
961 Quizzes
19148 Questions
 history
1088 Quizzes
13125 Questions
 physics
537 Quizzes
11445 Questions
 biology
1026 Quizzes
11462 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
432 Quizzes
8610 Questions
 maths
438 Quizzes
7860 Questions
 softskills
0 Quizzes
7131 Questions