Zusammenfassung der Ressource
Frage 1
Frage
What command do you use to perform a query in SQL?
Frage 2
Frage
What wildcard character retrieves all records with the SELECT command?
Frage 3
Frage
What would you use to combine two parameters in a query in SQL?
Frage 4
Frage
What clause would you use with the SELECT command that would pull records based on a range?
Frage 5
Frage
What keyword used with the SELECT statement is used to not output specified records?
Antworten
-
OR
-
DISALLOW
-
DISREGARD
-
NOT
Frage 6
Frage
What would you use to combine columns from two different tables?
Frage 7
Frage
Which clause used with the SELECT command will return values that you want to exclude from the normal parameters?
Antworten
-
EXCEPT
-
INTERSECT
-
SEARCH
-
EXCLUDE
Frage 8
Frage
What clause is used to combine related data from multiple table sources?
Frage 9
Frage
What statement would you use to add data to a table?
Frage 10
Frage
What statement would you use to change data in a table?
Antworten
-
CHANGE
-
MODIFY
-
INSERT
-
UPDATE
Frage 11
Frage
What statement is used to delete one or more rows in a table?
Antworten
-
DELETE
-
REMOVE
-
TRUNCATE
-
CHANGE
Frage 12
Frage
What statement is used to delete a table from a database?
Antworten
-
DELETE
-
DROP
-
REMOVE
-
TRUNCATE
Frage 13
Frage
How can you prevent the accidental loss of an entire table?
Antworten
-
Use the DELETE TRANS command.
-
Use the LOOPBACK command.
-
Use the SAFEDELETE command.
-
Use referential integrity.
Frage 14
Frage
What do you perform when you want to recall specific records from a database?
Antworten
-
recall
-
virtual extraction
-
reach
-
query
Frage 15
Frage
What command would you use to delete a table while leaving the table structure in place for future use?
Antworten
-
DELETE TABLE
-
TRUNCATE TABLE
-
REMOVE TABLE
-
STOP TABLE