Tag: databases

Questions Related to databases

A “trusted” client needs to communicate with a server that has been configured to Use CLIENT Authentication. Which of the following will be used to verify passwords?
technology databases

  1. User ID/Password File

  2. Communications Layer

  3. Client Applications

  4. Operating Systems

Show answer
Correct Option: D

Which of the following tools for DB2 V9 allows user to create and debug an SQL Stored Procedure
technology databases

  1. Control Center

  2. Development Center

  3. Developer Work Bench

  4. Stored Procedure Builder

Show answer
Correct Option: C

Which of the following tools is used to view historical information about tasks, Database changes, messages and notifications.
technology databases

  1. Journal

  2. Task Center

  3. Control Center

  4. Activity Monitor

Show answer
Correct Option: A

which of the following tools is used to analyze all of the database operations by an application against a DB2 for i5/OS database?
technology databases

  1. Visual Explain

  2. Activity Monitor

  3. SQL Performance Monitor

  4. DB2 Performance Monitor

Show answer
Correct Option: C

A user invoking a User Defined Function (UDF) requires which DB2 Privilege?
technology databases

  1. Call

  2. Usage

  3. Execute

  4. Reference

Show answer
Correct Option: C

Which of the following privileges permit a user to update the comment on sequence?
technology databases

  1. Control

  2. Update

  3. Usage

  4. Later

Show answer
Correct Option: D

Which of the following best describes the age of the data in an OLTP System?
technology databases

  1. Current

  2. Projected

  3. Historical

  4. Current and Projected

Show answer
Correct Option: A

On which of the following database objects may the Select Privilege be controlled?
technology databases

  1. Sequence

  2. Schema

  3. Group

  4. View

Show answer
Correct Option: D

Which of the following describes the model used by the Geodetic Extender?
technology databases

  1. Flat earth

  2. E-D square

  3. Trapezoidal

  4. Round Earth

Show answer
Correct Option: D

Which of the following tools can be used to schedule a backup operation that is to be run on every Saturday?
technology databases

  1. Journal

  2. Task Center

  3. Activity Monitor

  4. Command Line Processor

Show answer
Correct Option: B