98-364 : Database Fundamentals : Part 01

98-364 : Database Fundamentals : Part 01

1. The terms “bitmap,” “b-tree,” and “hash” refer to which type of database structure?

   • View
   • Function
   • Index
   • Stored procedure
   • Trigger

2. One reason to add an index is to:

   • Decrease storage space.
   • Increase database security.
   • Improve performance of select statements.
   • Improve performance of insert statements.

3. You have a table that contains the following data.

   

   You break the table into the following two tables.

   

   This process is referred to as:

   • defragmentation
   • normalization
   • fragmentation
   • denormalization

4. You have a table that contains the following data.

   

   Which database term is used to describe the relationship between ProductID and ProductCategory?

   • Cohort
   • Relationally dependent
   • Deterministic
   • Functionally dependent
   • Compositional

5. Which key uniquely identifies a row in a table?

   • foreiqn
   • primary
   • local
   • superkey

6. Which statement creates a composite key?

   

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

7. At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600 hours), you create a table named Customer and import data into the table. At 5:00 P.M. (1700 hours), your server fails.

   You run a script to apply only the 3:00 P.M. backup to your database. What is the result of the script?

   • The Customer table no longer exists.
   • The Customer table is unaffected.
   • The Customer table exists but has no data.
   • The script fails.

8. In which situation do you need to perform a restore on a database?

   • when data becomes corrupted in the database
   • when you need to roll back a transaction
   • when you encounter an error in your application
   • when data needs to be deleted from the database

9. Which command should you use to give a user permission to read the data in a table?

   • ALLOW SELECT
   • LET READ
   • PERMIT READ
   • GRANT SELECT

10. You need to enable a new employee to authenticate to your database.

    Which command should you use?

    • ALLOW USER
    • CREATE USER
    • ADD USER
    • INSERT USER
    • ALTER USER

11. Which keyword can be used in a create table statement?

    • ORDER BY
    • DISTINCT
    • GROUP BY
    • UNIQUE

12. You need to store product quantities, and you want to minimize the amount of storage space that is used. Which data type should you use?

    • INTEGER
    • DOUBLE
    • COUNT
    • FLOAT

13. Which statement will result in the creation of an index?

    

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

14. You have the following table definition:

    CREATE TABLE Road
    (RoadID INTEGER NOT NULL,
    Distance INTEGER NOT NULL)

    The Road table contains the following data:

    

    You execute the following statement:
    INSERT INTO Road VALUES (1234, 36)

    What is the result?

    • an error stating that NULL values are not allowed
    • a new row in the table
    • an error stating that duplicate IDs are not allowed
    • a syntax error

15. You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used.

    Which data type should you use?

    • VARCHAR (3, 30)
    • CHAR (3, 30)
    • VARCHAR (30)
    • CHAR (30)

16. One reason to create a stored procedure is to:

    • Improve performance.
    • Minimize storage space.
    • Bypass case sensitivity requirements.
    • Give the user control of the query logic.

17. Which permission does a user need in order to run a stored procedure?

    • EXECUTE
    • ALLOW
    • CALL
    • RUN

18. You have a table named Product. You create a view that includes all the products from the Product table that are in the Furniture category.

    You execute a statement on the Product table that deletes all the products in the Furniture category.

    After you execute the statement, the result set of the view is:

    • Empty
    • Deleted
    • Unchanged
    • Archived

19. In SQL, an insert statement is used to add a:

    • User to a database.
    • Row of data to a table.
    • Table to a database.
    • Column to a table definition.

20. You have two tables. Each table has three rows.

    How many rows will be included in the Cartesian product of these two tables?

    • 0
    • 3
    • 6
    • 9