98-364 : Database Fundamentals : Part 06

98-364 : Database Fundamentals : Part 06

1. This question requires that you evaluate the underlined text to determine if it is correct.

   Use indexing to create, remove, or change database objects.

   Instructions: Review the underlined text. If it makes the statement correct, select “No change is needed.” If the statement is incorrect, select the answer choice that makes the statement correct.

   • No change is needed.
   • Data manipulation language (DML) statements
   • Data definition language (DDL) statements
   • A unique constraint

2. You need to add rows to a database table.

   Which Structured Query Language (SQL) keyword should you use?

   • JOIN
   • INSERT
   • CREATE
   • UPDATE

3. You need to retrieve data from two related database tables based on a column that exists in both tables.

   Which command should you use in a query?

   • INTERSECT
   • UNION
   • JOIN
   • TRUNCATE

4. You have a database table that contains the following columns:

   

   You must insert the following record into the table:

   

   Which two Structured Query Language (SQL) statements can you use? (Choose two.)

   

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

5. This question requires that you evaluate the underlined text to determine if it is correct.

   The JOIN keyword combines the results of two queries and returns only rows that appear in both result sets.

   Instructions: Review the underlined text. If it makes the statement correct, select “No change is needed.” If the statement is incorrect, select the answer choice that makes the statement correct

   • No change is needed
   • INTERSECT 
   • ALL
   • UNION
   Explanation:
   INTERSECT returns rows that are common to both queries

6. You work at a restaurant and they ask you to help them with a data issue.

   They provide you with the following recipe data:

   

   You need to normalize the data to third normal form.

   How many tables should you create?

   • 1
   • 2
   • 3
   • 4

7. You accept an IT internship at a local charity. The charity has two tables in their data model named Chapter and Language, as defined below:

   

   You create a third table named ChapterLanguage to relate the Chapter table and the Language table.

   You need to select columns from the Chapter and Language tables to create a composite primary key for the ChapterLanguage table.

   Which two columns should you select? (Choose two.)

   • ChapterId 
   • LanguageId
   • Country
   • Region
   • City
   • LanguageName

8. HOTSPOT

   Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

   

   

9. This question requires that you evaluate the underlined text to determine if it is correct.

   You combine data from three tables into one table. The new table includes redundancy to optimize read performance.

   The data in the new table has been denormalized.

   Instructions: Review the underlined text. If it makes the statement correct, select “No change is needed.” If the statement is incorrect, select the answer choice that makes the statement correct.

   • No change is needed
   • Normalized
   • Truncated
   • Indexed

10. You need to delete a database table.

    Which data definition language (DDL) keyword should you use?

    • ALTER
    • DELETE
    • DROP
    • TRUNCATE

11. This question requires that you evaluate the underlined text to determine if it is correct.

    Create a query that returns a set of table data by using the UPDATE statement.

    Instructions: Review the underlined text. If it makes the statement correct, select “No change is needed.” If the statement is incorrect, select the answer choice that makes the statement correct.

    • No change is needed
    • INSERT
    • REPLACE
    • SELECT

12. Your class project requires that you help a charity to create a website that registers volunteers.

    The website must store the following data about the volunteers:
    – Given name
    – Surname
    – Telephone number
    – Email address

    You need to recommend a correct way to store the data.

    What do you recommend?

    • Create a table that contains columns that are named given name, surname, phone number, and email.
    • Create a table that contains rows that are named given name, surname, phone number, and email.
    • Create a view that contains columns that are named given name surname, phone number, and email.
    • Create a view that contains rows that are named given name surname, phone number, and email

13. This question requires that you evaluate the underlined text to determine if it is correct.

    Truncate is a database term used to describe the process of applying a backup to a damaged or corrupt database.

    Instructions: Review the underlined text. If it makes the statement correct, select “No change is needed.” If the statement is incorrect, select the answer choice that makes the statement corrector.

    • Change is needed
    • Commit
    • Attach
    • Restore

14. This question requires that you evaluate the underlined text to determine if it is correct.

    Use the ALLOW SELECT command to give a user permission to read the data in a table.

    Instructions: Review the underlined text. If it makes the statement correct, select “No change is needed.” If the statement is incorrect, select the answer choice that makes the statement correct

    • No change is needed
    • GRANT SELECT 
    • LET HEAD
    • PERMIT READ

15. HOTSPOT

    You have a user that has server roles as defined below:

    

    Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.

    

    

16. HOTSPOT

    The following illustration shows backup strategies that use the simple recovery model and the full recovery model:

    

    Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.

    

    

17. HOTSPOT

    Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

    

    

18. This question requires that you evaluate the underlined text to determine if it is correct.

    Views are database objects that contain all of the data in a database.

    Instructions: Review the underlined text. If it makes the statement correct, select “No change is needed.” If the statement is incorrect, select the answer choice that makes the statement correct

    • No change is needed
    • Queries
    • Stored procedures
    • Tables

19. You have two tables named Cars and Color as defined below. The two tables are related by ColorId.

    

    You run the following SQL statement: select:

    

    How many rows does the SQL statement return?

    • 0
    • 2
    • 3
    • 6

20. You accept an IT internship at a local charity. The charity asks you to keep a record of its volunteers by using a database table named Volunteer.

    When volunteers ask to be removed from mailing lists, the table must be updated.

    You need to use a transaction to ensure that the database has data integrity and referential integrity.

    Which statement should you use?

    

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