Tag: databases

Questions Related to databases

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

Where would the SQL error code (SQLSTATE/SQLCODE) be reported
technology databases

  1. in the SQLDA data structure

  2. in the SQLCA data structure

  3. in the DB configuration file

  4. in the event monitor log

Show answer
Correct Option: B

What does QMF stands for

technology databases

  1. Query Manager Facility

  2. Query Management Factor

  3. Query Management Facility

  4. None of the above

Show answer
Correct Option: C

What does SQLCA stands for

technology databases

  1. SQL Communications Area

  2. SQL Control Area

  3. SQL Connection Area

  4. SQL Control Access

Show answer
Correct Option: A

What does DCLGEN stands for

technology databases

  1. Declaration General

  2. Data Control Language Generator

  3. DB2 Control Region

  4. Declaration Generator

Show answer
Correct Option: D

What does DB2I stands for

technology databases

  1. DB2 Interchange

  2. DB2 Information

  3. DB2 Intercative

  4. DB2 Init

Show answer
Correct Option: C

Which Database Services component manages the physical database

technology databases

  1. DBRM

  2. Buffer Manager

  3. Runtime Supervisor

  4. Data Manager

Show answer
Correct Option: D

A VIEW MAY NOT CONTAIN

technology databases

  1. INDICES

  2. COLUMNS

  3. ROWS

  4. NONE OF THE ABOVE

Show answer
Correct Option: A

TOTAL DATA CAPACITY IN TERADATA

technology databases

  1. 64 GB PER AMP

  2. 120 GB PER AMP

  3. 32 GB PER AMP

  4. 16 GB PER AMP

Show answer
Correct Option: B