Free TE0-122 Exam Braindumps (page: 11)

Page 10 of 38

Which two parameters should be included as OUT parameters to assist with debugging in a stored procedure? (Choose two.)

  1. return code
  2. activity count
  3. boundary conditions
  4. informative error message
  5. check SQL argument result

Answer(s): A,E



The columns in a Trans table are defined as:

acctid INTEGER
amount DECIMAL(8, 2)

The values for these columns are the following (? indicates null):

Trans table
acctid amount
220532 55.38
227638 21.73
? 34.14
228326 ?
223961 20.74
220794 15.47
227638 ?
228326 47.21

Given the following SQL statement:
SELECT COUNT(*)
, COUNT(amount)
FROM Trans;

What is the result?

  1. 8 6
  2. 8 8
  3. 5 6
  4. 7 6

Answer(s): C



The stores table contains the following data:

store_id city state
----------- ------------------------- -----
1 Big Sur CA
2 Monterey CA
3 Napa CA
4 Oceanside CA
5 Rancho Bernardo CA
6 Sonoma CA
7 Algiers Point LA
8 New Orleans LA
9 Charlotte NC
10 North Wilkesboro NC
11 Midway UT
12 Moab UT
13 Park City UT
14 Springdale UT
15 Charleston WV
16 White Sulfur Springs WV

Given the following SQL statement:

SELECT city
, state
, SAMPLEID
FROM stores
SAMPLE WITH REPLACEMENT
WHEN state = 'LA' THEN 4, 1
WHEN state = 'CA' THEN 8, 4
WHEN state = 'CO' THEN 2, 2
END
ORDER BY 3;

How many rows are returned?

  1. 7
  2. 14
  3. 16
  4. 17
  5. 21

Answer(s): E



The stores table contains the following data:

store_id city state
----------- ------------------------- -----
1 Big Sur CA
2 Monterey CA
3 Napa CA
4 Oceanside CA
5 Rancho Bernardo CA
6 Sonoma CA
7 Algiers Point LA
8 New Orleans LA
9 Charlotte NC
10 North Wilkesboro NC
11 Midway UT
12 Moab UT
13 Park City UT
14 Springdale UT
15 Charleston WV
16 White Sulfur Springs WV
Given the following SQL statement:
SELECT city
, state
, SAMPLEID
FROM stores
SAMPLE WITH REPLACEMENT RANDOMIZED ALLOCATION
WHEN state = 'LA' THEN 5
WHEN state = 'CA' THEN 5
ELSE 7
END
ORDER BY 3;

How many rows are returned?

  1. 2
  2. 6
  3. 8
  4. 14
  5. 17

Answer(s): A






Post your Comments and Discuss TeraData TE0-122 exam with other Community members:

TE0-122 Discussions & Posts