1.
Aggregate operators are used on __________ no of rows
data mining (watch out for the data slurry)
2.
A DDL command among these is__________
DELETE (DDL = delete dat line)
3.
LOCK is a command from __________
Star Trek (as in "lock phasers")
4.
Data redundancy can be found advantageous in_________
applications where you need to find the data via several query paths
5.
The table called DUAL will have _________no of rows
as many as you have inserted, plus one
6.
Identify the conversion function________
US$ = Cdn$ * 1.33
7.
The query below belong to _______datamodel
{<C/<B,L,A>C<B,L,C,A>EBORROW^A>1200)}
loan shark model
8.
Remaining operator is applicable for ______________
modulus calculation
9.
Identifying the key as no duplicate values?
call the locksmith, i can't get into my car again!!
10.
To find the AVG account balance at each branch we need to use one of the clause as
AVG(LMSIA) = Account Very Good (Lotsa Money, Spread It Around)
11.
In E-RMODEL E primary key is identified by ________
the white key between the two black ones on the piano keyboard (right next to the D sharp key)
12.
The syntax for del is delete__________
delete please (delete alone only removes one row, delete please removes them all)
13.
Dispaly last name and salary of all the employees working in dept no 40?
Fred $9370, Joe $10500, Mary $12000, Bob $8700
see also
database brain teasers
