1. Using the XML Document below, with the URI “recipe.xml”
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
two of our famous Belgian Waffles with plenty of real
<name>Strawberry Belgian Waffles</name>
light Belgian waffles covered with strawberries and
<name>Berry-Berry Belgian Waffles</name>
light Belgian waffles covered with an assortment of
fresh berries and whipped cream
thick slices made from our homemade sourdough bread
two eggs, bacon or sausage, toast, and our
ever-popular hash browns
How to use timestamp datatypes
Explain about query and reporting.
A) Which two are benefits of Teradata's support for ANSI
Standard SQL? (Choose two.)
1.data is distributed automatically
2.queries get optimized to better plans
3.submit queries from other database systems
4.can interface with BI tools
B) Which statement is true when comparing the advantages of
third normal form to star schema?
1.Star schema tends to have fewer entities.
2.Star schema requires additional data storage.
3.Third normal form tends to have fewer entities.
4.Third normal form requires additional data storage.
C)Which two sets of functions does the Parsing Engine (PE)
perform? (Select two.)
1.sorting, formatting, and aggregating of the final answer
2.flow control of the data to and from the participating
3.SQL statement interpretation, syntax validation, and
4.dispatching the step execution sequence to the AMP via
D) Which two can be achieved with Teradata Active System
Management (TASM)? (Choose two.)
2.react to hardware failure
3.influence response times
E) Which three mechanisms can be used to ensure security
within the Teradata Database? (Choose three.)
How to read and create .LDC data files which are used by
What is normalization? Explain different levels of
How to replace not in with not exist?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON
COL B? PLS SEND ME THE ANS
How to use online Backups?
Can you have a nested transaction?
When installing the datastage7.5x2 edtion iam getting
aproblem i.e the cpu count is 2 but the cpu count in
installation is one . how can i install in my p.c (system
is dual core).
Any sample or model question of punjab national bank for
deputy manger IT
or any sample of PNB.any1 plz do send on
my program is accesing data from two db2 databases.what
is the bind card for this program to genarate plan? how to
specify the two owners and two qualifiers in bind card
In which table collections errors are stored.
There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better?