ExamDumpster

Free 98-364 sample questions

Each free 98-364 sample question below tests database basics and comes with an answer and an explanation. Topics include normalization, primary and foreign keys, and simple SELECT, INSERT and UPDATE statements. Use them to find gaps in your SQL.

Try them in the simulator Same questions, with study, timed and flashcard modes.

Showing 6 of 12 free sample questions.

Question 1Choose 2

Which of the following statements are correct regarding recovery of the InnoDB tables after a server crash? Each correct answer represents a complete solution. (Choose all that apply.)

Question 2Choose 2

You are a database developer for a database named Customers hosted on a SQL Server 2008 server. Recently, several customers were deleted from the Customers database. To ensure this is not repeated in future, you have decided to create a DML trigger to prevent it. What code will create the trigger to meet your goals? Each correct answer represents a complete solution. (Choose all that apply.)

Question 3Choose 4

Which of the following are DML commands? Each correct answer represents a complete solution. (Choose all that apply.)

Question 4Choose one

You are the database administrator of a MySQL server that runs on a Windows server. All clients are local clients. For security, you want to disable connections from the remote clients. Which of the following steps will you take to accomplish the task?

Question 5Choose one

Which of the following are the correct statements of using the Flashback Query feature in Oracle? Each correct answer represents a complete solution. (Choose all that apply.)

Question 6Choose one

You work as a Database Administrator for InfoTech Inc. The company has a database and they want you to create a design for a database that will support the enterprise’s operations and objectives. Which of the following will you use to accomplish the task?

6 more free samples are waiting

Create a free account to unlock the whole 98-364 sample bank, or get full access to all 95 practice questions in the simulator.

Create account