old MTA DAF 3 Flashcards Preview

AS (MTA DAF) > old MTA DAF 3 > Flashcards

Flashcards in old MTA DAF 3 Deck (15)
Loading flashcards...
1
Q

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

A

UPDATE

2
Q

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

A

SELECT

3
Q

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

A

TRUNCATE TABLE

4
Q

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

A

DROP

5
Q

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

A

AND

6
Q

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

A

Use referential integrity

7
Q

What wildcard character retrieves all records with the SELECT command?

A

*

8
Q

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

A

query

9
Q

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

A

NOT

10
Q

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

A

EXCEPT

11
Q

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

A

INSERT

12
Q

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

A

BETWEEN

13
Q

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

A

JOIN

14
Q

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

A

DELETE

15
Q

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

A

JOIN