This topic contains 0 replies, has 0 voices, and was last updated by  EduGorilla 1 year, 11 months ago.

  • Author
    Posts
  • #1440555 Reply
     EduGorilla 
    Keymaster
    Select Question Language :


    Consider the following schema:
    Suppliers (sid: integer, sname: string, address: string)
    Parts (pid: integer, pname: string, color: string)
    Catalog (sid: integer, pid: integer, cost: real)
    The key fields are underlined, and the domain of each field is listed after the field name. Therefore sid is the key for Suppliers, pid is the key for Parts, and sid and pid together form the key for Catalog. The Catalog relation lists the prices charged for parts by Suppliers.
    Which of the following will result into “Name of all the suppliers Who supplies red part which cost less than 100”?
    S1:
    S2:

    Options :-

    1. Only S1
    2. Only S2
    3. Both S1 and S2
    4. None of these
    Post your Training /Course Enquiry
    Are You looking institutes / coaching center for
    • IIT-JEE, NEET, CAT
    • Bank PO, SSC, Railways
    • Study Abroad
    Select your Training / Study category
Reply To: Consider the following schema: Suppliers (sid: integer, sname: string, address: string) Parts (pid: ….
Your information:




Verify Yourself




Log in with your credentials

or    

Forgot your details?

Create Account