QUESTION: 41

What will occur when a row level lock is requested in a macro and the Optimizer determines a table level lock is required?

It will automatically upgrade the lock without warning.
It will automatically upgrade the lock and provide a warning.
It will provide a warning and put the query in the delay queue.
It will send back an error message for the lock to be corrected.

Answer(s): C

Reveal Solution Next Question

Given the following table:

Customer Name Season Purchased
Johnson Fall
Hamilton Summer
Toby Winter
Sinclair Spring
Hall Winter
Trader Fall
Earman Summer

A company wants to send a "Spring" catalog to those customers who have purchased Spring items in the past and a "Fall" catalog to those who have made Fall purchases.
Which CASE expression produces the desired information?

CASEseason_purchased
WHEN "Fall" THEN Customer_Name
WHEN "Spring" THEN Customer_Name
ELSE "Unknown"
END
CASE WHEN "Fall" THENCustomer_Name
WHEN "Spring" THEN Customer_Name
END
CASEseason_purchased
WHEN "Fall" THEN Customer_Name
ELSE WHEN "Spring" THEN Customer_Name
END
CASE WHEN "Fall" THEN Customer_Name
ELSE WHEN "Spring" THEN Customer_Name
END

Answer(s): D

Reveal Solution Next Question

QUESTION: 43

Which data type can be converted to any other data type in the Day-Time interval family?

INTERVAL TIME
INTERVAL DAY
INTERVAL MONTH
INTERVAL DATE

Answer(s): D

Reveal Solution Next Question

QUESTION: 44

Given the following query:

SELECT Name, State
FROM Customers
ORDER BY Name;

The statement returns the following rows (? indicates null):
Name State
Dillon B CA
Newman R ?
Osborne G AR

Given the following additional query:
SELECT Name, State
FROM Employees
ORDER BY Name;

The statement returns the following rows:
Name State
Dillon B CA
Freeman A TN
Newman R TX
Oscar K FL

Given the union of the following two queries:
SELECT Name, State
FROM Customers
UNION
SELECT Name, State
FROM Employees;

How many rows will the union return?

1
5
6
7

Answer(s): A

Reveal Solution Next Question

Free TE0-122 Exam Braindumps (page: 12)

QUESTION: 41

QUESTION: 42

QUESTION: 43

QUESTION: 44

TE0-122 Discussions & Posts