98-364

98-364 practice questions, page 8 of 10, with answer review and explanations.

Question 36

Which command should you use to remove a table from a database?

  1. REMOVE TABLE
  2. UPDATE TABLE
  3. DROP TABLE
  4. DELETE TABLE

Question 37

You need to store the contact information for each student in your school database. You should store each student's information in a:

  1. Stored procedure
  2. Function
  3. Row
  4. Variable

Question 38

Which category of SQL statements is used to add, remove, and modify database structures?

  1. Data access language (DAL)
  2. Data manipulation language (DML)
  3. Data control language (DCL)
  4. Data definition language (DDL)

Question 39

You have a Customer table and an Order table. You join the Customer table with the Order table by using the CusromerID column. The results include: All customers and their orders - ✑ Customers who have no orders Which type of join do these results represent?

  1. Complete join
  2. Partial join
  3. Inner join
  4. Outer join

Question 40

Data in a database is stored in:

  1. Tables
  2. Queries
  3. Data types
  4. Stored procedures