Kopieren und bearbeiten

Chapter 7 (Multiple Choice CIS 3365)

Beschreibung

asdf Quiz am Chapter 7 (Multiple Choice CIS 3365), erstellt von . . am 22/09/2016.
. .
Quiz von . ., aktualisiert more than 1 year ago
. .
Erstellt von . . vor fast 8 Jahre
636
3
0

Zusammenfassung der Ressource

Frage 1

Frage
1. The most recent fully approved version of standard SQL prescribed by the ANSI is ____.
Antworten
  • a. SQL-99
  • b. SQL-2003
  • c. SQL-4
  • d. SQL-07

Frage 2

Frage
2. The SQL character data format(s) is(are) ____.
Antworten
  • a. CHAR and VARCHAR
  • b. VARCHAR only
  • c. Alphanumeric
  • d. CHAR only

Frage 3

Frage
3. The SQL command that lets you insert rows into a table is ____.
Antworten
  • a. INSERT
  • b. SELECT
  • c. COMMIT
  • d. UPDATE

Frage 4

Frage
4. The SQL command that lets you permanently save data changes is ____.
Antworten
  • a. INSERT
  • b. SELECT
  • c. COMMIT
  • d. UPDATE

Frage 5

Frage
5. The SQL command that lets you select attributes from rows in one or more tables is ____.
Antworten
  • a. INSERT
  • b. SELECT
  • c. COMMIT
  • d. UPDATE

Frage 6

Frage
6. To list all the contents of the PRODUCT table, you would use ____.
Antworten
  • a. LIST * FROM PRODUCT;
  • b. SELECT * FROM PRODUCT;
  • c. DISPLAY * FROM PRODUCT;
  • d. SELECT ALL FROM PRODUCT;

Frage 7

Frage
7. In Oracle, the ____ command is used to change the display for a column, for example, to place a $ in front of a numeric value.
Antworten
  • A) DISPLAY
  • B) FORMAT
  • C) CHAR
  • D) CONVERT

Frage 8

Frage
8. The SQL command that modifies an attribute’s values in one or more table’s rows is ____.
Antworten
  • A) INSERT
  • B) SELECT
  • C) COMMIT
  • D) UPDATE

Frage 9

Frage
9. UPDATE table name*****[WHERE condition list];The ____ command replaces the ***** in the syntax of the UPDATE command, shown above.
Antworten
  • a. SET columnname = expression
  • b. columnname = expression
  • c. expression = columnname
  • d. LET columnname = expression

Frage 10

Frage
10. An example of a command you would use when making changes to a PRODUCT table is ____.
Antworten
  • a. CHANGE PRODUCTSET P_INDATE = '18-JAN-2004'WHERE P_CODE = '13-Q2/P2';
  • b. ROLLBACK PRODUCTSET P_INDATE = '18-JAN-2004'WHERE P_CODE = '13-Q2/P2';
  • c. EDIT PRODUCTSET P_INDATE = '18-JAN-2004'WHERE P_CODE = '13-Q2/P2';
  • d. UPDATE PRODUCTSET P_INDATE = '18-JAN-2004'WHERE P_CODE = '13-Q2/P2';

Frage 11

Frage
11. The ____ command is used to restore the table’s contents to their previous values.
Antworten
  • a. COMMIT; RESTORE;
  • b. COMMIT; BACKUP;
  • c. COMMIT; ROLLBACK;
  • d. ROLLBACK;

Frage 12

Frage
12. Some RDBMSs, such as Oracle, automatically ____ data changes when issuing data definition commands.
Antworten
  • a. COMMIT
  • b. ROLLBACK
  • c. UNSAVE
  • d. UPDATE

Frage 13

Frage
13. To delete a row from the PRODUCT table, use the ____ command.
Antworten
  • a. COMMIT
  • b. DELETE
  • c. ERASE
  • d. KILL

Frage 14

Frage
14. When you issue the DELETE FROM table name command without specifying a WHERE condition,____.
Antworten
  • a. no rows will be deleted
  • b. the first row will be deleted
  • c. the last row will be deleted
  • d. all rows will be deleted

Frage 15

Frage
15. Which of the following is used to select partial table contents?
Antworten
  • a. SELECT <column(s)>FROM <Table name>BY <Conditions>;
  • b. LIST <column(s)>FROM <Table name>BY <Conditions>;
  • c. SELECT <column(s)>FROM <Table name>WHERE <Conditions>;
  • d. LIST<column(s)>FROM <Table name>WHERE <Conditions>;

Frage 16

Frage
16. The ____ command would be used to delete the table row where the P_CODE is 'BRT-345'.
Antworten
  • a. DELETE FROM PRODUCTWHERE P_CODE = 'BRT-345';
  • b. REMOVE FROM PRODUCTWHERE P_CODE = 'BRT-345';
  • c. ERASE FROM PRODUCTWHERE P_CODE = 'BRT-345';
  • d. ROLLBACK FROM PRODUCTWHERE P_CODE = 'BRT-345';

Frage 17

Frage
17. A(n) ____ is a query that is embedded (or nested) inside another query.
Antworten
  • a. alias
  • b. operator
  • c. subquery
  • d. view

Frage 18

Frage
18. Which query will output the table contents when the value of V_CODE is equal to 21344?
Antworten
  • a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE V_CODE <> 21344;
  • b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE V_CODE <= 21344;
  • c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE V_CODE = 21344;
  • d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE V_CODE => 21344;

Frage 19

Frage
19. Which query will output the table contents when the value of V_CODE is not equal to 21344?
Antworten
  • a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE V_CODE <> 21344;
  • b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE V_CODE <= 21344;
  • c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE V_CODE = 21344;
  • d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE V_CODE => 21344;

Frage 20

Frage
20. Which query will output the table contents when the value of P_PRICE is less than or equal to 10?
Antworten
  • a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE P_PRICE <> 10;
  • b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE P_PRICE <= 10;
  • c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE P_PRICE => 10;
  • d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE P_PRICE = 10;

Frage 21

Frage
21. Which query will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?
Antworten
  • a. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICEFROM PRODUCT WHERE P_CODE <'1558-QW1';
  • b. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICEFROM PRODUCTWHERE P_CODE = [1558-QW1]
  • c. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICEFROM PRODUCTWHERE P_CODE = (1558-QW1)
  • d. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICEFROM PRODUCTWHERE P_CODE = {1558-QW1}

Frage 22

Frage
22. Which query will list all the rows in which the inventory stock dates occur on or after January 20, 2010?
Antworten
  • a. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATEFROM PRODUCTWHERE P_INDATE >= '20-JAN-2010'
  • b. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATEFROM PRODUCTWHERE P_INDATE >= $20-JAN-2010$
  • c. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATEFROM PRODUCTWHERE P_INDATE <= '20-JAN-2010'
  • d. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATEFROM PRODUCTWHERE P_INDATE >= {20-JAN-2010}

Frage 23

Frage
23. Which query will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand?
Antworten
  • a. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICEFROM PRODUCT;
  • b. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICEFROM PRODUCT;
  • c. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICEFROM PRODUCT;
  • d. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICEFROM PRODUCT;

Frage 24

Frage
24. A(n) ____ is an alternate name given to a column or table in any SQL statement.
Antworten
  • a. alias
  • b. data type
  • c. stored function
  • d. Trigger

Frage 25

Frage
25. Which query will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand and display the results in a column labeled TOTVALUE?
Antworten
  • a. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE AS TOTVALUEFROM PRODUCT;
  • b. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICE AS TOTVALUEFROM PRODUCT;
  • c. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICE AS TOTVALUEFROM PRODUCT;
  • d. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICE AS TOTVALUEFROM PRODUCT;

Frage 26

Frage
26. Which query uses the correct SQL syntax to list the table contents for either V_CODE = 21344 or V_CODE = 24288?
Antworten
  • a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE V_CODE = 21344OR V_CODE <= 24288
  • b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE V_CODE = 21344OR V_CODE => 24288
  • c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE V_CODE = 21344OR V_CODE > 24288
  • d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE V_CODE = 21344OR V_CODE = 24288

Frage 27

Frage
27. The special operator used to check whether an attribute value is within a range of values is ____.
Antworten
  • a. BETWEEN
  • b. NULL
  • c. LIKE
  • d. IN

Frage 28

Frage
28. The ____ special operator is used to check whether an attribute value is null.
Antworten
  • a. BETWEEN
  • b. IS NULL
  • c. LIKE
  • d. IN

Frage 29

Frage
29. The special operator used to check for similar character strings is ____.
Antworten
  • a. BETWEEN
  • b. IS NULL
  • c. LIKE
  • d. IN

Frage 30

Frage
30. The special operator used to check whether a subquery returns any rows is ____.
Antworten
  • a. BETWEEN
  • b. EXISTS
  • c. LIKE
  • d. IN

Frage 31

Frage
31. The ____ command is used with the ALTER TABLE command to modify the table by deleting a column.
Antworten
  • a. DROP
  • b. REMOVE
  • c. DELETE
  • d. ERASE

Frage 32

Frage
32. A table can be deleted from the database by using the ____ command.
Antworten
  • a. DROP TABLE
  • b. DELETE TABLE
  • c. MODIFY TABLE
  • d. ERASE TABLE

Frage 33

Frage
33. The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the PRODUCT table in ascending order by P_PRICE is ____.
Antworten
  • a. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICEFROM PRODUCTSEQUENCE BY P_PRICE;
  • b. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICEFROM PRODUCTLIST BY P_PRICE;
  • c. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICEFROM PRODUCTORDER BY P_PRICE;
  • d. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICEFROM PRODUCTASCENDING BY P_PRICE;

Frage 34

Frage
34. The SQL query to output the contents of the EMPLOYEE table sorted by last name, first name, and initial is ____.
Antworten
  • a. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE,EMP_PHONEFROM EMPLOYEELIST BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
  • b. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE,EMP_PHONEFROM EMPLOYEEORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
  • c. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE,EMP_PHONEFROM EMPLOYEEDISPLAY BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
  • d. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE,EMP_PHONEFROM EMPLOYEESEQUENCE BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;

Frage 35

Frage
35. Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?
Antworten
  • a. SELECT ONLY V_CODEFROM PRODUCT;
  • b. SELECT UNIQUE V_CODEFROM PRODUCT
  • c. SELECT DIFFERENT V_CODEFROM PRODUCT
  • d. SELECT DISTINCT V_CODEFROM PRODUCT;

Frage 36

Frage
36. The SQL aggregate function that gives the number of rows containing non-null values for the given column is ____.
Antworten
  • a. COUNT
  • b. MIN
  • c. MAX
  • d. SUM

Frage 37

Frage
37. The SQL aggregate function that gives the total of all values for a selected attribute in a given column is ____.
Antworten
  • a. COUNT
  • b. MIN
  • c. MAX
  • d. SUM

Frage 38

Frage
38. The SQL aggregate function that gives the average for the specific column is ____.
Antworten
  • a. COUNT
  • b. AVG
  • c. MAX
  • d. SUM

Frage 39

Frage
39. The query 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 values of V_CODE match is ____.
Antworten
  • a. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE,V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE <> VENDOR.V_CODE;
  • b. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE,V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE = VENDOR.V_CODE;
  • c. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE,V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE <= VENDOR.V_CODE;
  • d. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE,V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE => VENDOR.V_CODE;

Frage 40

Frage
40. The query 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 values of V_CODE match and the output is ordered by the price is ____.
Antworten
  • a. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE,V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE <> VENDOR.V_CODE;ORDER BY P_PRICE;
  • b. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE,V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE => VENDOR.V_CODE;ORDER BY P_PRICE;
  • c. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE,V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE <= VENDOR.V_CODE;ORDER BY P_PRICE;
  • d. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE,V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE = VENDOR.V_CODE;ORDER BY P_PRICE;
Zusammenfassung anzeigen Zusammenfassung ausblenden

Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.

ähnlicher Inhalt

El Perdón
Alonso Linares
Investiga las transformaciones de la cultura y de la vida cotidiana a lo largo del tiempo.
Sherlyn Muñoz
Irene
i.biza
Sean doce balines (a,b,c,d,e,f,g,h,i,j,k,l)
andres parra
Funciones Polinomiales
Julieta Maya
10.THE VALUATION PROCESS AND PRICING PROPERTIES
Brigita Safyra
Effective Citizens
Lauren Petrouleas
asdfas
bevan7
S C I E X
guohao.lam
Perspectives of learning
nilemon
Mind Idea
rodrigo.cespedes
Bibliothek durchsuchen