Loading [MathJax]/jax/output/HTML-CSS/fonts/TeX/fontdata.js
Copy and Edit

CET_TARDE - MTA Database - DIAGNOSTIC2

Description

Database Quizzes preparing to certification
Hawerth Castro
Quiz by Hawerth Castro, updated more than 1 year ago
Hawerth Castro
Created by Hawerth Castro almost 8 years ago
32
0
0
1 2 3 4 5 (0)

Resource summary

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
Show full summary Hide full summary

0 comments

There are no comments, be the first and leave one below:

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

CET_TARDE - MTA Software Development Fundamentals 3
Hawerth Castro
CET_TARDE - MTA Software Development Fundamentals 1
Hawerth Castro
CET_TARDE - MTA Software Development Fundamentals 2
Hawerth Castro
CET_TARDE - MTA Windows Server Administration Fundamentals 2
Hawerth Castro
CET_TARDE - MTA Database - E_COMANDS
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
Browse Library