If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > questions in database management systems

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-06-05, 02:54
shivashankar shivashankar is offline
Registered User
 
Join Date: Feb 2005
Posts: 1
Thumbs up database management systems

well keep up the good work that u have done with database management system but that isnt any funny thing .
i needed it urgently anyways nevermind for what u have done

Last edited by shivashankar; 02-06-05 at 07:08.
Reply With Quote
  #2 (permalink)  
Old 02-06-05, 03:16
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
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

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #3 (permalink)  
Old 02-06-05, 10:41
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
Quote:
Originally Posted by shivashankar
well keep up the good work that u have done with database management system but that isnt any funny thing .
i needed it urgently anyways nevermind for what u have done
I"m sure that you'll find someone that will do your homework if you look hard enough... I suspect that if you'd actually apply yourself in class instead of dedicating your effort to finding someone that will do your homework that you'd do less total work and you'd actually learn the material which would also give you a way to make a living once you finish school.

As far as Rudy's answers not being funny, that is definitely a matter of opinion. I found them quite amusing!

-PatP
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On