QUESTION: 49

Company Z wants to identify the highest salaried employee in each department for a possible mentoring program.
Which query will generate the desired results?

SELECT last_name
, department_number AS deptno
, salary_amount
FROM employee ee
WHERE salary_amount =
(SELECT MAX (salary_amount)
FROM employee em);
SELECT last_name
, department_number AS deptno
, salary_amount
FROM employee ee
WHERE salary_amount =
(SELECT MAX (salary_amount)
FROM employee em
WHERE ee.department_number = em.department_number);
SELECT last_name
, department_number AS deptno
, salary_amount
FROM employee ee
WHERE salary_amount =
(SELECT MAX (salary_amount)
FROM employee em
WHERE ee.employee = salary_amount);
SELECT last_name
, department_number AS deptno
, salary_amount
FROM employee ee
WHERE salary_amount =
(SELECT MAX (salary_amount)
FROM employee em
WHERE ee.salary_amount = em.salary_amount);

Answer(s): D

Reveal Solution Next Question

QUESTION: 50

Why would adding a debug variable be useful when writing a stored procedure?

It reduces the number of SET statements.
It provides information on the compiler.
It decreases the frequency of recompilation.
It simplifies usage of various levels of tracing.

Answer(s): C

Reveal Solution Next Question

A user wants to create two copies of the following table:

CREATE TABLE table_1(
column1 INTEGER NOT NULL
, column2 INTEGER NOT NULL
, column3 DATE FORMAT 'YYYY-MM-DD'
, column4 INTEGER DEFAULT 1000
, FOREIGN KEY (column2) REFERENCES WITH NO CHECK OPTION Parent_table1(column1))
PRIMARY INDEX (column1)
PARTITION BY RANGE_N(column3
BETWEEN DATE '2009-01-01' AND DATE '2011-12-31' EACH INTERVAL '1' DAY);
COLLECT STATISTICS ON table_1 INDEX (column1);
COLLECT STATISTICS ON table_1 COLUMN PARTITION;
CREATE TABLE table_2 AS table_1 WITH DATA AND STATISTICS;
CREATE TABLE table_3 AS (SELECT * FROM table_1) WITH DATA AND STATISTICS;

Which two statements are true about these two CREATE TABLE AS statements? (Choose two.)

table_3 will not be partitioned.
table_3 will have the DEFAULT column attribute from table_1.
table_2 will have the referential integrity column from table_1.
table_2 will have statistics on the system-derived PARTITION column from table_1.

Answer(s): A,C

Reveal Solution Next Question

QUESTION: 52

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 store_id
, city
, state
, SAMPLEID
FROM stores
SAMPLE 0.50, 0.25, 0.25
ORDER BY 4;

How many rows are returned?

1
4
5
15
16

Answer(s): B

Reveal Solution Next Question

Free TE0-122 Exam Braindumps (page: 14)

QUESTION: 49

QUESTION: 50

QUESTION: 51

QUESTION: 52

TE0-122 Discussions & Posts