← Back to exam page

Free 98-364 – Database Fundamentals Practice Test Question

Free demo downloads

Loading demo links...

Showing 10–12 of 15 questions

Question 10

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?

Select an option, then click Submit answer.

  • ○

    INTERSECT
  • ○

    UNION
  • ○

    JOIN
  • ○

    TRUNCATE
Question 11

You have two tables named Salesperson and Sales.

You need to ensure that each record in the Sales table has a valid associated salesperson record in the Salesperson table.

Which database object should you add to the Sales table?

Select an option, then click Submit answer.

  • ○

    Nonclustered index
  • ○

    Primary key
  • ○

    Foreign key
  • ○

    Clustered index
Question 12

You work as a Database Designer for DataOneWorld Inc.

The company has a SQL Server database.

You are assigned the task of creating a data model of an enterprise based on a specific data model. The model to be created should be independent of a particular DBMS.

Which of the following database designs will help you accomplish the task?

Select an option, then click Submit answer.

  • ○

    Logical database design
  • ○

    Conceptual database design
  • ○

    Physical database design
  • ○

    Application design