9635425
Description
Quiz by Hawerth Castro, updated more than 1 year ago
|
Created by Hawerth Castro
over 7 years ago
|
|
Question 1
Question
What command do you use to perform a query in SQL?
Answer
-
USE
-
SELECT
-
QUERY
-
CHOSE
Question 2
Question
What wildcard character retrieves all records with the SELECT command?
Answer
-
*
-
%
-
$
-
?
Question 3
Question
What would you use to combine two parameters in a query in SQL?
Answer
-
PLUS
-
BOTH
-
COMBINE
-
AND
Question 4
Question
What clause would you use with the SELECT command that would pull records based on a range?
Answer
-
COMBO
-
BETWEEN
-
OR
-
COMBINE
Question 5
Question
What keyword used with the SELECT statement is used to not output specified records?
Answer
-
OR
-
DISALLOW
-
DISREGARD
-
NOT
Question 6
Question
What would you use to combine columns from two different tables?
Answer
-
AND
-
BETWEEN
-
JOIN
-
COMBINE
Question 7
Question
Which clause used with the SELECT command will return values that you want to exclude from the normal parameters?
Answer
-
EXCEPT
-
INTERSECT
-
SEARCH
-
EXCLUDE
Question 8
Question
What clause is used to combine related data from multiple table sources?
Answer
-
COMBINE
-
AND
-
JOIN
-
PLUS
Question 9
Question
What statement would you use to add data to a table?
Answer
-
ADD
-
INSERT
-
JOIN
-
PRESENT
Question 10
Question
What statement would you use to change data in a table?
Answer
-
CHANGE
-
MODIFY
-
INSERT
-
UPDATE
Question 11
Question
What statement is used to delete one or more rows in a table?
Answer
-
DELETE
-
REMOVE
-
TRUNCATE
-
CHANGE
Question 12
Question
What statement is used to delete a table from a database?
Answer
-
DELETE
-
DROP
-
REMOVE
-
TRUNCATE
Question 13
Question
How can you prevent the accidental loss of an entire table?
Answer
-
Use the DELETE TRANS command.
-
Use the LOOPBACK command.
-
Use the SAFEDELETE command.
-
Use referential integrity.
Question 14
Question
What do you perform when you want to recall specific records from a database?
Answer
-
recall
-
virtual extraction
-
reach
-
query
Question 15
Question
What command would you use to delete a table while leaving the table structure in place for future use?
Answer
-
DELETE TABLE
-
TRUNCATE TABLE
-
REMOVE TABLE
-
STOP TABLE
Want to create your own Quizzes for free with GoConqr? Learn more.