Free TE0-122 Exam Braindumps (page: 13)

Page 12 of 38

A table is created with the following DDL:

CREATE TABLE Test (
Column1 CHAR(2) NOT NULL)
UNIQUE PRIMARY INDEX(Column1);

The data inserted into Column1 looks like the following:
Column1
50
35
79

Which query will have optimal performance, given the data inserted into Column1?

  1. SELECT Column1 FROM Test WHERE Column1=35;
  2. SELECT Column1 FROM Test WHERE Column1='35';
  3. SELECT Column1 FROM Test WHERE Column1(INTEGER)=35;
  4. SELECT Column1 FROM Test WHERE CAST(Column1 AS INTEGER)=35;

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 = 'UT' THEN 4, 2
WHEN state = 'WV' THEN 2, 1
ELSE 10, 5 END ORDER BY 3;

How many rows are returned?

  1. 6
  2. 9
  3. 19
  4. 24
  5. 32

Answer(s): C



Which three requirements result in choosing stored procedures for implementing an application? (Choose three)

  1. recursive processing
  2. USING request modifiers
  3. warning condition handlers
  4. re-scrolling of answer sets

Answer(s): A,B,C



Which three statements are true about the functionality of queue tables? (Choose three.)

  1. A queue table may or may not contain data.
  2. The first column must be a timestamp data type.
  3. A normal SELECT may not be used to read rows in the table.
  4. The definition of a queue table is not stored in the data dictionary.
  5. A SELECT AND CONSUME reads a row and deletes it from the table and queue.

Answer(s): B,D,E






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

TE0-122 Discussions & Posts