98-364 무료 덤프문제 온라인 액세스

HOTSPOT
You have two database tables as defined below. The StateID column is unique in the State table. The AddressID column is unique in the Address table. The two tables are related by the StateID column.

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

정답:

You execute the following statement:

This statement is an example of a/an:

• A.Subquery
• B.Cartesian product
• C.Outer join
• D.Union

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?

• A.LIKE
• B.BETWEEN
• C.FIND
• D.INCLUDES

Which statement should you use to remove a foreign key?

• A.ALTER FOREIGN KEY
• B.DELETE FOREIGN KEY
• C.DELETE TABLE
• D.ALTER TABLE

HOTSPOT
You have the following table:

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

정답: