GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

C192 / SQL

Craig Willey 17 questions Updated 4 Jul 2020

Take the quiz

Questions in this quiz (17)

  1. 1The SQL command that enables you to make changes in the data is ____.
    1. AINSERT
    2. BSELECT
    3. CCOMMIT
    4. DUPDATE
  2. 2To list all the contents of the PRODUCT table, you would use ____.
    1. ALIST * FROM PRODUCT;
    2. BSELECT * FROM PRODUCT;
    3. CDISPLAY * FROM PRODUCT;
    4. DSELECT ALL FROM PRODUCT;
  3. 3Which command would you use when making corrections to the PRODUCT table?
    1. ACHANGE PRODUCT
      SET P_INDATE = '01/18/2004'
      WHERE P_CODE = '13-Q2/P2';
    2. BROLLBACK PRODUCT
      SET P_INDATE = '01/18/2004'
      WHERE P_CODE = '13-Q2/P2';
    3. CEDIT PRODUCT
      SET P_INDATE = '01/18/2004'
      WHERE P_CODE = '13-Q2/P2';
    4. DUPDATE PRODUCT
      SET P_INDATE = '01/18/2004'
      WHERE P_CODE = '13-Q2/P2';
  4. 4Which command is used to select partial table contents?
    1. ASELECT <column(s)>
      FROM <Table name>
      WHERE <Item>;
    2. BLIST <column(s)>
      FROM <Table name>
      WHERE <Conditions>;
    3. CSELECT <column(s)>
      FROM <Table name>
      WHERE <Conditions>;
    4. DLIST<column(s)>
      FROM <Table name>
      WHERE <Item>;
  5. 5Which query will output the table contents when the value of V_CODE is less than or equal to 21344?
    1. ASELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
      FROM PRODUCT
      WHERE V_CODE <> 21344;
    2. BSELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
      FROM PRODUCT
      WHERE V_CODE <=21344;
    3. CSELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
      FROM PRODUCT
      WHERE V_CODE => 21344;
    4. DSELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
      FROM PRODUCT
      WHERE V_CODE = 21344;
  6. 6What is the SQL syntax requirement to list the table contents for either V_CODE = 21344 or V_CODE = 24288?
    1. ASELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
      FROM PRODUCT
      WHERE V_CODE = 21344
      OR V_CODE <= 24288
    2. BSELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
      FROM PRODUCT
      WHERE V_CODE = 21344
      OR V_CODE => 24288
    3. CSELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
      FROM PRODUCT
      WHERE V_CODE = 21344
      OR V_CODE > 24288
    4. DSELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
      FROM PRODUCT
      WHERE V_CODE = 21344
      OR V_CODE = 24288
  7. 7What is the command used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the Product table in ascending order by P_PRICE?
    1. ASELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
      FROM PRODUCT
      SEQUENCE BY P_PRICE;
    2. BSELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
      FROM PRODUCT
      LIST BY P_PRICE;
    3. CSELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
      FROM PRODUCT
      ORDER BY P_PRICE;
    4. DSELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
      FROM PRODUCT
      ASCENDING BY P_PRICE;
  8. 8The basic SQL aggregate function that gives the number of rows containing not null values for the given column is ____.
    1. ACOUNT
    2. BMIN
    3. CMAX
    4. DSUM
  9. 9What is the command to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE, and V_CONTACT fields from the VENDOR table where the value of V_CODE match?
    1. ASELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
      FROM PRODUCT, VENDOR
      WHERE PRODUCT.V_CODE <> VENDOR.V_CODE;
    2. BSELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
      FROM PRODUCT, VENDOR
      WHERE PRODUCT.V_CODE = VENDOR.V_CODE;
    3. CSELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
      FROM PRODUCT, VENDOR
      WHERE PRODUCT.V_CODE <= VENDOR.V_CODE;
    4. DSELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
      FROM PRODUCT, VENDOR
      WHERE PRODUCT.V_CODE => VENDOR.V_CODE;
  10. 10What is the command to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE and V_CONTACT fields from the VENDOR table, where the value of V_CODE match and the output is ordered by the Price?
    1. ASELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
      FROM PRODUCT, VENDOR
      WHERE PRODUCT.V_CODE <> VENDOR.V_CODE;
      ORDER BY P_PRICE;
    2. BSELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
      FROM PRODUCT, VENDOR
      WHERE PRODUCT.V_CODE => VENDOR.V_CODE;
      ORDER BY P_PRICE;
    3. CSELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
      FROM PRODUCT, VENDOR
      WHERE PRODUCT.V_CODE <= VENDOR.V_CODE;
      ORDER BY P_PRICE;
    4. DSELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
      FROM PRODUCT, VENDOR
      WHERE PRODUCT.V_CODE = VENDOR.V_CODE;
      ORDER BY P_PRICE;

Information

Description
College C192 Databases Quiz on C192 / SQL , created by Craig Willey on 30/06/2020.
Language
English
Views
17
History
Created on 30 Jun 2020 · updated on 4 Jul 2020
Rating
No ratings yet
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?