Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2004
    Posts
    23

    Thumbs up Unanswered: Answers Needed For Questions In Database Management Systems

    Hi all .This is for experts in basic database management systems.Here follows few questions with options below.Answers needed for those.It is urgent and i request u to give the exact and confident answers.Thank u.


    1.Aggregate operators are used on __________ no of rows
    (A)SINGLE (B)MULTIPLE (C)DOUBLE (D)QUADRAPLE

    2.A DDL command among these is__________
    (A)DELETE (B)DROP (C)SELECT (D)FROM

    3.LOCK is a command from __________

    (A)DDL (B)DCL (C)DML (D)NONE OF THE ABOVE

    4.Data redundancy can be found advantageous in_________
    (A)FILESYSTEM (B)DBMS (C)OS (D)NONE OF THE ABOVE

    5.The table called DUAL will have _________no of rows

    (A)2 (B)1 (C)4 (D)3

    6.Identify the conversion function________

    (A)LOWER (B)TO-NUMBER (C)IN (D)SYSDATE

    7.The query below belong to _______datamodel {<C/<B,L,A>C<B,L,C,A>EBORROW^A>1200)}

    (A)DOMAIN RELATION CALCULUS (B)TUPLE RELATIONAL CALCULUS (C)E-R MODEL (D)NETWORK MODEL

    8.Remaining operator is applicable for ______________

    (A)CARTESIAN PRODUCT (B)SELECTION OPERATOR (C)NATURAL JOIN (D)OUTER JOIN

    9.Identifying the key as no duplicate values?

    (A)PRIMARY KEY (B)UNIQUE KEY (C)REFERENTIAL KEY (D)ALL THE ABOVE

    10.To find the AVG account balance at each branch we need to use one of the clause as
    (A)HAVING (B)GROUPBY (C)SELECT (D)EXISTS

    11.In E-RMODEL E primary key is identified by ________

    (A)UNDERLINING (B)CIRCLING (C)DIAMOND (D)NONE OF THE ABOVE

    12.The syntax for del is delete__________
    (A)FROM CLAUSES FOLLOWED BY WHERE CLAUSE (B)WHERE CLAUSE FOLLOWED BY FROM CLAUSE (C)USE OF SET COMMAND (D)NONE OF THE ABOVE

    13.Dispaly last name and salary of all the employees working in dept no 40?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    all of these questions have been answered already, in this thread
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Dude, this is like Oracle/SQL 101 stuff.

    NeverMind, HA HA HA HA HA

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    The people on the forum will not generally help people answer their homework, however they might give clues. My Clue is to use google (for example "ORACLE LOCK") or another clue is to RTFM. If we help you with the answers, all you will do is give our answers and you will never learn the information. You might get away with cheating in school, but believe me when I say that you will NOT be able to cheat when you get your first job. If you don't know the systems cold, you will not be hired or you will be fired.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •