← Back to exam page

98-364 – Database Fundamentals

Loading demo links...

Showing 13–15 of 15 questions

Question 13

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

Select an option, then click Submit answer.

  • ○

    No change is needed
  • ○

    INTERSECT

  • ○

    ALL
  • ○

    UNION
Question 14

You have a table named Employee that includes four columns. You execute the following statement:

SELECT *

FROM Employee

Which columns are returned?

Select an option, then click Submit answer.

  • ○

    all columns
  • ○

    only the last column
  • ○

    only the first column
  • ○

    only the first and last columns
Question 15

You manage a SQL Server 2008 server that hosts a database named Sales.

Unauthorized modifications to some tables within the Sales database have resulted in some views no longer working.

You need to implement a method that will ensure that all modifications to any objects with the Sales database are logged.

What should you do?

Select an option, then click Submit answer.

  • ○

    Create a DDL trigger with database scope.
  • ○

    Create a DML trigger with database scope.
  • ○

    Create a DML trigger with server scope.
  • ○

    Create a DDL trigger with server scope.