CET_TARDE - MTA Database - DIAGNOSTIC2

Beschreibung

Database Quizzes preparing to certification
Hawerth Castro
Quiz von Hawerth Castro, aktualisiert more than 1 year ago
Hawerth Castro
Erstellt von Hawerth Castro vor fast 7 Jahre
22
0

Zusammenfassung der Ressource

Frage 1

Frage
What command do you use to perform a query in SQL?
Antworten
  • USE
  • SELECT
  • QUERY
  • CHOSE

Frage 2

Frage
What wildcard character retrieves all records with the SELECT command?
Antworten
  • *
  • %
  • $
  • ?

Frage 3

Frage
What would you use to combine two parameters in a query in SQL?
Antworten
  • PLUS
  • BOTH
  • COMBINE
  • AND

Frage 4

Frage
What clause would you use with the SELECT command that would pull records based on a range?
Antworten
  • COMBO
  • BETWEEN
  • OR
  • COMBINE

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?
Antworten
  • AND
  • BETWEEN
  • JOIN
  • COMBINE

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?
Antworten
  • COMBINE
  • AND
  • JOIN
  • PLUS

Frage 9

Frage
What statement would you use to add data to a table?
Antworten
  • ADD
  • INSERT
  • JOIN
  • PRESENT

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
Zusammenfassung anzeigen Zusammenfassung ausblenden

ähnlicher Inhalt

CET_TARDE - MTA Software Development Fundamentals 3
Hawerth Castro
CET_TARDE - MTA Software Development Fundamentals 1
Hawerth Castro
CET_TARDE - MTA Software Development Fundamentals 4
Hawerth Castro
CET_TARDE - MTA Software Development Fundamentals 2
Hawerth Castro
CET_TARDE - MTA Database - DIAGNOSTIC5
Hawerth Castro
CET_TARDE - MTA Windows Server Administration Fundamentals 1
Hawerth Castro
CET_TARDE - MTA Windows Server Administration Fundamentals 0
Hawerth Castro
CET_TARDE - MTA Windows Server Administration Fundamentals 3
Hawerth Castro
CET_TARDE - MTA Windows Server Administration Fundamentals 4
Hawerth Castro
CET_TARDE - MTA Database - INDEX
Hawerth Castro
CET_TARDE - MTA Database - DIAGNOSTIC4
Hawerth Castro