C192 / SQL

Descrição

College C192 Databases Quiz sobre C192 / SQL , criado por Craig Willey em 30-06-2020.
Craig Willey
Quiz por Craig Willey, atualizado more than 1 year ago
Craig Willey
Criado por Craig Willey mais de 4 anos atrás
8
0

Resumo de Recurso

Questão 1

Questão
The SQL command that enables you to make changes in the data is ____.
Responda
  • INSERT
  • SELECT
  • COMMIT
  • UPDATE

Questão 2

Questão
To list all the contents of the PRODUCT table, you would use ____.
Responda
  • LIST * FROM PRODUCT;
  • SELECT * FROM PRODUCT;
  • DISPLAY * FROM PRODUCT;
  • SELECT ALL FROM PRODUCT;

Questão 3

Questão
Which command would you use when making corrections to the PRODUCT table?
Responda
  • 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';

Questão 4

Questão
Which command is used to select partial table contents?
Responda
  • 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>;

Questão 5

Questão
Which query will output the table contents when the value of V_CODE is less than or equal to 21344?
Responda
  • 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;

Questão 6

Questão
What is the SQL syntax requirement to list the table contents for either V_CODE = 21344 or V_CODE = 24288?
Responda
  • 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

Questão 7

Questão
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?
Responda
  • 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;

Questão 8

Questão
The basic SQL aggregate function that gives the number of rows containing not null values for the given column is ____.
Responda
  • COUNT
  • MIN
  • MAX
  • SUM

Questão 9

Questão
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?
Responda
  • 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;

Questão 10

Questão
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?
Responda
  • 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;

Questão 11

Questão
To delete a row from the PRODUCT table, use the ____ command.
Responda
  • KILL
  • DELETE
  • COMMIT
  • ERASE

Questão 12

Questão
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 ____.
Responda
  • BETWEEN
  • IS NULL
  • LIKE
  • IN

Questão 13

Questão
The ____ command is used to modify the table by deleting a column.
Responda
  • DROP
  • ALTER
  • DELETE
  • ERASE

Questão 14

Questão
The ____ function is used to find the highest value in a table column.
Responda
  • MAX
  • TOTAL
  • SUM
  • TOP

Questão 15

Questão
UPDATE tablename ***** [WHERE conditionlist]; What command replaces the ***** in the above statement?
Responda
  • SET columnname = expression
  • columnname = expression
  • expression = columnname
  • LET columnname = expression

Questão 16

Questão
If you wish to perform an inner join based on only one common attribute, you might use the ____ clause.
Responda
  • OF
  • USING
  • HAS
  • JOIN ON

Questão 17

Questão
In a subquery, which query is executed first?
Responda
  • Leftmost
  • Rightmost
  • Innermost
  • Outermost

Semelhante

Paulo Freire Pedagogia da Autonomia
lb.roberto
Combate a incêndio - Capítulo dois
willian reis
Todos os verbos irregulares em inglês com tradução
Luiz Fernando
HISTÓRIA REVOLUÇÃO FRANCESA
neusamiotto
EA-HSG-2011 Questões achadas no app QUIZADA na playstore
carloshenriquetorrez .
EA-HSG-2014 Questões achadas no app QUIZADA na playstore
carloshenriquetorrez .
FCE masterclass Unit 1 - seeing verbs
Rosana Cabral
Tabela Periódica
Fael Berranteiro
Mapa Mental - Fungos
Leonardo Bermudes
SISTEMA ENDÓCRINO
STELA FAUSTINO
A Célula
Nathalia - GoConqr