13841237
Beschreibung
Quiz von Brandon Gagon, aktualisiert more than 1 year ago
|
Erstellt von Brandon Gagon
vor etwa 6 Jahre
|
|
Frage 1
Frage
The SQL command that enables you to make changes in the data is ____.
Antworten
-
INSERT
-
SELECT
-
COMMIT
-
UPDATE
Frage 2
Frage
To list all the contents of the PRODUCT table, you would use ____.
Antworten
-
LIST * FROM PRODUCT
-
SELECT * FROM PRODUCT
-
DISPLAY * FROM PRODUCT
-
SELECT ALL FROM PRODUCT
Frage 3
Frage
Which command would you use when making corrections to the PRODUCT table?
Antworten
-
CHANGE PRODUCT SET P_INDATE = '01/18/2004' WHERE P_CODE = '13-Q2/P2';
-
ROLLBACK PRODUCT SET P_INDATE = '01/18/2004' WHERE P_CODE = '13-Q2/P2';
-
EDIT PRODUCT SET P_INDATE = '01/18/2004' WHERE P_CODE = '13-Q2/P2';
-
UPDATE PRODUCT SET P_INDATE = '01/18/2004' WHERE P_CODE = '13-Q2/P2';
Frage 4
Frage
Which command is used to select partial table contents?
Antworten
-
SELECT <column(s)> FROM <Table name> WHERE <Item>;
-
LIST <column(s)> FROM <Table name> WHERE <Conditions>;
-
SELECT <column(s)> FROM <Table name> WHERE <Conditions>;
-
LIST<column(s)> FROM <Table name> WHERE <Item>;
Frage 5
Frage
Which query will output the table contents when the value of V_CODE is less than or equal to 21344?
Antworten
-
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <> 21344;
-
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <=21344;
-
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE => 21344;
-
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344;
Frage 6
Frage
What is the SQL syntax requirement to list the table contents for either V_CODE = 21344 or V_CODE = 24288?
Antworten
-
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE <= 24288
-
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE => 24288
-
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE > 24288
-
SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE = 24288
Frage 7
Frage
What 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?
Antworten
-
SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT SEQUENCE BY P_PRICE;
-
SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT LIST BY P_PRICE;
-
SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ORDER BY P_PRICE;
-
SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ASCENDING BY P_PRICE;
Frage 8
Frage
The basic SQL aggregate function that gives the number of rows containing not null values for the given column is ____.
Antworten
-
COUNT
-
MIN
-
MAX
-
SUM
Frage 9
Frage
What 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?
Antworten
-
SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <> VENDOR.V_CODE;
-
SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;
-
SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <= VENDOR.V_CODE;
-
SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE => VENDOR.V_CODE;
Frage 10
Frage
What 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?
Antworten
-
SELECT 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;
-
SELECT 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;
-
SELECT 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;
-
SELECT 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;
Frage 11
Frage
To delete a row from the PRODUCT table, use the ____ command.
Antworten
-
KILL
-
DELETE
-
COMMIT
-
ERASE
Frage 12
Frage
ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check whether an attribute value is null is ____.
Antworten
-
BETWEEN
-
IS NULL
-
LIKE
-
IN
Frage 13
Frage
The ____ command is used to modify the table by deleting a column.
Antworten
-
DROP
-
ALTER
-
DELETE
-
ERASE
Frage 14
Frage
The ____ function is used to find the highest value in a table column.
Antworten
-
MAX
-
TOTAL
-
SUM
-
TOP
Frage 15
Frage
UPDATE tablename
*****
[WHERE conditionlist];
What command replaces the ***** in the above statement?
Antworten
-
SET columnname = expression
-
columnname = expression
-
expression = columnname
-
LET columnname = expression
Frage 16
Frage
If you wish to perform an inner join based on only one common attribute, you might use the ____ clause.
Antworten
-
OF
-
USING
-
HAS
-
JOIN ON
Frage 17
Frage
In a subquery, which query is executed first?
Antworten
-
Leftmost
-
Rightmost
-
Innermost
-
Outermost
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.