old MTA DAF 3

Question 1

What statement would you use to change data in a table?

Answer 1

UPDATE

Question 2

What command do you use to perform a query in SQL?

Answer 2

SELECT

Question 3

What command would you use to delete a table while leaving the table structure in place for future use?

Answer 3

TRUNCATE TABLE

Question 4

What statement is used to delete a table from a database?

Answer 4

DROP

Question 5

What would you use to combine two parameters in a query in SQL?

Answer 5

AND

Question 6

How can you prevent the accidental loss of an entire table?

Answer 6

Use referential integrity

Question 7

What wildcard character retrieves all records with the SELECT command?

Answer 7

*

Question 8

What do you perform when you want to recall specific records from a database?

Answer 8

query

Question 9

What keyword used with the SELECT statement is used to not output specified records?

Answer 9

NOT

Question 10

Which clause used with the SELECT command will return values that you want to exclude from the normal parameters?

Answer 10

EXCEPT

Question 11

What statement would you use to add data to a table?

Answer 11

INSERT

Question 12

What clause would you use with the SELECT command that would pull records based on a range?

Answer 12

BETWEEN

Question 13

What would you use to combine columns form two different tables?

Answer 13

JOIN

Question 14

What statement is used to delete one or more rows in a table?

Answer 14

DELETE

Question 15

What clause is used to combine related data from multiple table sources

Answer 15

JOIN