Question 1

What is a view config spec

technology databases

It specifies which versions of the element should appear in the view
It specifies what type of branching logic used.
All the above
None of the above

Answer

Correct Option: A

Question 2

What are the key products of IBM ClearCase Family

technology databases

ClearCase LT
ClearCase
ClearCase MultiSite
All the above

Answer

Correct Option: D

Question 3

What are the different clear case Roles

technology databases

Configuration Manager
Administrator
Tester
a & b

Answer

Correct Option: D

Question 4

What are the responsilibities of a Developer

technology databases

Sets up workspace
Integrates changes
Creates baseline
a & b

Answer

Correct Option: D

Question 5

What is the Lost and Found Directory

technology databases

Contains orphaned elements, which are no longer catalogued in any version of any directory
All the deleted elements will be stored
It the meta directory of the ClearCase
None

Answer

Correct Option: A

Question 6

Given the following scenario: Table TABLE1 needs to hold specific numeric values up to 9999999.999 in column COL1. Once TABLE1 is populated, arithmetic operations will be performed on data stored in col-umn COL1. Which of the following would be the most appropriate DB2 data type to use for column COL1?

technology databases

INTEGER
REAL
NUMERIC (7,3)
DECIMAL(10,3)

Answer

Correct Option: D

Question 7

An application has acquired a Share lock on a row in a table and now wishes to update the row. Which of the following statements is true?

technology databases

The application must release the row-level Share lock it holds and acquire an Update lock on the row
The application must release the row-level Share lock it holds and acquire an Update lock on the table
The row-level Share lock will automatically be converted to a row-level Up-date lock
The row-level Share lock will automatically be escalated to a table-level Up-date lock

Answer

Correct Option: C

Question 8

Which of the following is a NOT a valid reason for defining a view on a table?

technology databases

Restrict users' access to a subset of table data
Ensure that rows inserted remain within the scope of a definition
Produce an action as a result of a change to a table
Provide users with an alternate view of table data

Answer

Correct Option: C

Question 9

When you open a cursor, DB2 will always get all rows that meet the selection criteria and create a result set?

technology databases

Yes
No
It Depends
None of the above

Answer

Correct Option: B

Question 10

Given the following table: TEMP_DATA TEMP DATE _____________ 45 12/25/2006 51 12/26/2006 67 12/27/2006 72 12/28/2006 34 12/29/2006 42 12/30/2006 And the following SQL statement: TE FUNCTION degf_to_c (temp INTEGER) RETURNS INTEGER LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC BEGIN ATOMIC DECLARE newtemp INTEGER; SET newtemp = temp - 32; SET newtemp = newtemp * 5; RETURN newtemp / 9; END Which two of the following SQL statements illustrate the proper way to invoke the calar function DEGF_TO_C?

technology databases

VALUES degf_to_c(32)
SELECT date, degf_to_c(temp) AS temp_c FROM temp_data
CALL degf_to_c(32)
Both a and b

Answer

Correct Option: D

Question 11

Which wildcard character is used for a single character replacement

technology databases

%
&
_
None of the above

Answer

Correct Option: C

Question 12

What is the picture clause of the null indicator variable

technology databases

S9 (4) COMP-3
S9 (4)
9 (4)
S9 (4) COMP

Answer

Correct Option: D

Question 13

_____ is dropped when the table or tablespace is dropped

technology databases

SYNONYM
ALIAS
All of the above
None of the above

Answer

Correct Option: A

Question 14

A collection of named objects is called ______

technology databases

Schema
Table
Alias
Both a & b

Answer

Correct Option: A

Question 15

The maximum number of tables that can be joined is _____________

technology databases

20
10
15
No Limit.

Answer

Correct Option: C

Question 16

When the program name is not in the plan, we get

technology databases

-810
-801
-805
-825

Answer

Correct Option: C

Question 17

B37 abend during SPUFI is due to

technology databases

Space Issues
Data Issues
No records found while querying the table
Both a & b

Answer

Correct Option: A

Question 18

To retrieve data from more than one table we could use

technology databases

Joins
Unions
Nested SELECT
All of the above

Answer

Correct Option: D

Question 19

Which of the following tools can be used to automate table reorganization Operations ?

technology databases

Control Center
Command Center
Command Line Processor
Task Center

Answer

Correct Option: D

Question 20

Given the following statement: CREATE TABLE t1 col1 SMALLINT NOT NULL PRIMARY KEY, col2 VARCHAR(200) NOT NULL WITH DEFAULT NONE, col3 DECIMAL(5,2) CHECK (col3 >= 100.00), col4 DATE NOT NULL WITH DEFAULT) Which of the following definitions will cause the CREATE TABLE statement to fail?

technology databases

COL1
COL2
COL3
COL4

Answer

Correct Option: B

Description: databases Online Quiz - 222
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 222

Find more quizzes from top tags