QUESTION: 37

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

return code
activity count
boundary conditions
informative error message
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?

8 6
8 8
5 6
7 6

Answer(s): C

Reveal Solution Next Question

QUESTION: 39

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?

7
14
16
17
21

Answer(s): E

Reveal Solution Next Question

QUESTION: 40

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?

2
6
8
14
17

Answer(s): A

Reveal Solution Next Question

Free TE0-122 Exam Braindumps (page: 11)

QUESTION: 37

QUESTION: 38

QUESTION: 39

QUESTION: 40

TE0-122 Discussions & Posts