QUESTION: 61

Which ANSI SQL-2003 compliant function should be used when determining the length of a string?

COUNT
CHAR_COUNT
CHARACTERS
CHARACTER_LENGTH

Answer(s): B

Given the following definition of a table:

CREATE TABLE trans
( trans_id INTEGER NOT NULL
, unit_price DECIMAL(10, 2)
, qnty INTEGER
, t_time TIMESTAMP(6) NOT NULL)
PRIMARY INDEX (trans_id);

The table has a row that was inserted as follows:
INSERT trans VALUES
(45912, 12.99, NULL, CURRENT_TIMESTAMP);
The following statement is submitted:
SELECT COALESCE(unit_price, 0)*qnty
FROM trans WHERE trans_id=45912 AND unit_price IS NOT NULL;

What is the result?

NULL
0.00
12.99
no rows returned

Answer(s): D

Reveal Solution Next Question

QUESTION: 63

Given the following command:
HELP STATISTICS sales.orders

What is a valid output and what information is provided?

Date Time Unique values Column names
------- ------- -------------- ------------
10/15/09 22:39:08 156798 Order Id
Displays summary attributes for statistics that have been collected in the Data Dictionary for the
specified data table.
Primary
or
Date Time Secondary Unique Values
-------- -------- ---------- --------------
10/15/09 22:39:08 P 16780
Displays the attributes for an index column including whether it is a primary or secondary index and the number of unique values within the column.
Date Time Table/View/JI/HI Kind Unique Values
-------- -------- ---------------- ---- -------------
10/15/09 02:19:22 Product T 2500
10/15/09 02:20:56 Active Orders V 29000
10/15/09 02:23:47 Product_Id JI 17000
10/15/09 02:19:22 Order_Id HI 11409
Displays attributes for statistics collected for all tables, views, Join Indexes and Hash Indexes.
Date Time Column Name Unique Values
-------- -------- ------------ -------------
10/15/09 17:41:54 Order_Number 150986
Displays the attributes for the columns making up the Hash Index.

Answer(s): D

Reveal Solution Next Question

QUESTION: 64

Given the following:

SELECT Department
, Employee_No
, SUM(Sales_Amt)
FROM SALES
WHERE Department IN ('Westcoast', 'Central', 'Eastcoast')

What is needed to make this query run without error?

GROUP BY 1, 2
ORDER BY 1, 2
GROUP BY 1 ORDER BY 1, 2
modify the WHERE clause to includeEmployee_No

Answer(s): C

Reveal Solution Next Question

Free TE0-122 Exam Braindumps (page: 17)

QUESTION: 61

QUESTION: 62

QUESTION: 63

QUESTION: 64

TE0-122 Discussions & Posts