98-364 : Database Fundamentals : Part 02

98-364 : Database Fundamentals : Part 02

1. You are writing an SQL statement to retrieve rows from a table.

   Which data manipulation language (DML) command should you use?

   • READ
   • SELECT
   • OUTPUT
   • GET

2. Which constraint ensures a unique value in the ID column for each customer?

   • DISTINCT
   • FOREIGN KEY
   • SEQUENTIAL
   • PRIMARY KEY

3. The component that holds information for a single entry in a table is called a:

   • Data type
   • Row
   • Column
   • View

4. You execute the following statement:

   SELECT EmployeeID, FirstName, DepartmentName
   FROM Employee, Department

   This type of operation is called a/an:

   • Intersection
   • Outer join
   • Equi-join
   • Cartesian product

5. Which command should you use to add a column to an existing table?

   • MODIFY
   • ALTER
   • UPDATE
   • INSERT
   • CHANGE

6. You have the following table definition:

   CREATE TABLE Product
   (ID INTEGER PRIMARY KEY,
   Name VARCHAR(20),
   Quantity INTEGER)

   The Product table contains the following data.

   

   You execute the following statement:

   SELECT Name FROM Product WHERE Quantity IS NOT NULL

   How many rows are returned?

   •  0
   • 1
   • 2
   • 3
   • 4

7. You are writing a select statement to find every product whose name contains a specific character.

   Which keyword should you use in your where clause?

   • FIND
   • BETWEEN
   • INCLUDES
   • LIKE

8. A database contains two tables named Customer and Order.

   You execute the following statement:

   DELETE FROM Order
   WHERE CustomerID = 209

   What is the result?

   • The first order for CustomerID 209 is deleted from the Order table.
   • All orders for CustomerID 209 are deleted from the Order table, and CustomerID 209 is deleted from the Customer table.
   • All orders for CustomerID 209 are deleted from the Order table.
   • CustomerID 209 is deleted from the Customer table.

9. You have a table named Product. The Product table has columns for ProductDescription and ProductCategory.

   You need to change the ProductCategory value for all the spoons in the Product table to 43.

   Which statement should you use?

   

   • Option A
   • Option B
   • Option C
   • Option D

10. You have a table that contains information about all students in your school.

    Which SQL keyword should you use to change a student’s first name in the table?

    • UPDATE
    • CHANGE
    • SELECT
    • INSERT

11. You need to populate a table named EmployeeCopy with data from an existing table named Employee.

    Which statement should you use?

    

    • Option A
    • Option B
    • Option C
    • Option D

12. You execute the following statement:

    

    This statement is an example of a/an:

    • Subquery
    • Union
    • Outer join
    • Cartesian product

13. Which keyword would you use in a select statement to return rows that meet a specific condition?

    • WHERE
    • UNION
    • ORDER BY
    • FROM

14. You have a table named Employee that includes the following columns:

    EmployeeID
    Smp1oyeeName

    Which statement should you use to return the number of rows in the table?

    

    • Option A
    • Option B
    • Option C
    • Option D

15. The Product table contains the following data.

    

    You execute the following statement:

    SELECT COUNT(*)
    FROM Product WHERE Quantity > 18

    What is the value returned by this statement?

    • 1
    • 2
    • 3
    • 4

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

    • REMOVE TABLE
    • UPDATE TABLE
    • DROP TABLE
    • DELETE TABLE

17. You need to store the contact information for each student in your school database.

    You should store each student’s information in a:

    • Stored procedure
    • Function
    • Row
    • Variable

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

    • Data access language (DAL)
    • Data manipulation language (DML)
    • Data control language (DCL)
    • Data definition language (DDL)

19. 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?

    • Complete join
    • Partial join
    • Inner join
    • Outer join

20. Data in a database is stored in:

    • Tables
    • Queries
    • Data types
    • Stored procedures