new MTA DAF 3

Question 1

Please order the following elements from a select query:
INTO
SELECT
HAVING
WHERE
ORDER BY
GROUP BY
FROM

Answer 1

SELECT
INTO
FROM
WHERE
GROUP BY
HAVING
ORDER BY

Question 2

What wildcard character can used in the SELECT command?

Answer 2

• or % or ?

Question 3

Which keywords are necessary to add data into a table?

Answer 3

INSERT, VALUES

Question 4

What key is replicated from the primary key of one table to a secondary table, and then all the key attributes get duplicated from the primary table?

Answer 4

Foreign key

Question 5

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

Answer 5

AND

Question 6

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

Answer 6

DROP

Question 7

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

Answer 7

query

Question 8

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

Answer 8

AND

Question 9

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

Answer 9

Use referential integrity.

Question 10

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

Answer 10

SELECT

Question 11

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

Answer 11

INSERT

Question 12

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

Answer 12

JOIN

Question 13

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

Answer 13

EXCEPT

Question 14

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

Answer 14

NOT

Question 15

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

Answer 15

TRUNCATE TABLE