9635425
Descrição
Quiz por Hawerth Castro, atualizado more than 1 year ago
|
Criado por Hawerth Castro
mais de 7 anos atrás
|
|
Questão 1
Questão
What command do you use to perform a query in SQL?
Responda
-
USE
-
SELECT
-
QUERY
-
CHOSE
Questão 2
Questão
What wildcard character retrieves all records with the SELECT command?
Responda
-
*
-
%
-
$
-
?
Questão 3
Questão
What would you use to combine two parameters in a query in SQL?
Responda
-
PLUS
-
BOTH
-
COMBINE
-
AND
Questão 4
Questão
What clause would you use with the SELECT command that would pull records based on a range?
Responda
-
COMBO
-
BETWEEN
-
OR
-
COMBINE
Questão 5
Questão
What keyword used with the SELECT statement is used to not output specified records?
Responda
-
OR
-
DISALLOW
-
DISREGARD
-
NOT
Questão 6
Questão
What would you use to combine columns from two different tables?
Responda
-
AND
-
BETWEEN
-
JOIN
-
COMBINE
Questão 7
Questão
Which clause used with the SELECT command will return values that you want to exclude from the normal parameters?
Responda
-
EXCEPT
-
INTERSECT
-
SEARCH
-
EXCLUDE
Questão 8
Questão
What clause is used to combine related data from multiple table sources?
Responda
-
COMBINE
-
AND
-
JOIN
-
PLUS
Questão 9
Questão
What statement would you use to add data to a table?
Responda
-
ADD
-
INSERT
-
JOIN
-
PRESENT
Questão 10
Questão
What statement would you use to change data in a table?
Responda
-
CHANGE
-
MODIFY
-
INSERT
-
UPDATE
Questão 11
Questão
What statement is used to delete one or more rows in a table?
Responda
-
DELETE
-
REMOVE
-
TRUNCATE
-
CHANGE
Questão 12
Questão
What statement is used to delete a table from a database?
Responda
-
DELETE
-
DROP
-
REMOVE
-
TRUNCATE
Questão 13
Questão
How can you prevent the accidental loss of an entire table?
Responda
-
Use the DELETE TRANS command.
-
Use the LOOPBACK command.
-
Use the SAFEDELETE command.
-
Use referential integrity.
Questão 14
Questão
What do you perform when you want to recall specific records from a database?
Responda
-
recall
-
virtual extraction
-
reach
-
query
Questão 15
Questão
What command would you use to delete a table while leaving the table structure in place for future use?
Responda
-
DELETE TABLE
-
TRUNCATE TABLE
-
REMOVE TABLE
-
STOP TABLE
Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.