GoConqr hat ein neues Design! Sag uns, wie es dir gefällt.

Kostenlos registrieren

Quiz

C192 SQL

Brandon Gagon 17 Fragen

Quiz starten

Fragen in diesem 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;

Informationen

Beschreibung
Quiz am C192 SQL, erstellt von Brandon Gagon am 29/11/2020.
Sprache
English
Aufrufe
0
Bewertung
Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck