New Updated Microsoft MTA 98-364 Real Exam Questions and Answers Download 41-50

Ensurepass

QUESTION 41

You work as a Database Developer for GraySoft Inc. You are designing a database to record information about potential customers. You create a table named ProductInquiry for the database. The table is given below:

 

98-364-demo-5

 

You want to uniquely identify the product in which a customer is interested. Choose the columns on which a PRIMARY KEY constraint needs to be created to accomplish this.

 

Select and Place:

98-364-demo-6

 

Correct Answer:

98-364-demo-7

 

 

QUESTION 42

Which of the following is the process of extracting trails on a regular basis so that they can be transferred to a designated security system where the database administrators do not have access?

 

  1. Native auditing

  2. Abstraction

  3. Database security

  4. Encryption

 

Correct Answer: A

 

 

QUESTION 43

You manage a large database named Sales. The Sales database contains a table named OrderDetails, which is a heavily transacted table with frequent inserts. Indexes in the table often become fragmented due to excessive page splitting. You want to minimize the amount of fragmentation due to page splits. What should you do?

 

  1. Update the statistics on the indexes.

  2. Change the fillfactor for the indexes to 100.

  3. Change the fillfactor for the indexes to 60.

  4. Change the fillfactor for the indexes to 0.

 

Correct Answer: C

 

 

QUESTION 44

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?

 

  1. Start the server with the –disable-networking option.

  2. Start the server with the –shared-memory option.

  3. Start the server with the –skip-networking option.

  4. Start the server with the –secure-auth option.

 

Correct Answer: C

 

 

QUESTION 45

Consider the case of an organization having many departments. Each department has a department head known as senior manager. Several employees are working in a department under the senior manager. Identify the most appropriate ER-diagram that represents the relationship between department and employees.

 

  1.  

98-364-demo-8

 

  1.  

98-364-demo-9

 

  1.  

98-364-demo-10

 

  1.  

98-364-demo-11

 

Correct Answer: D

 

 

QUESTION 46

Which of the following statements is true about referential integrity?

 

  1. It checks that no component of a primary key can have a null value and no duplicate entries can exist.

  2. It checks that the value of a primary key must be consistent throughout the life of an instance.

  3. It distinguishes between null values and zero entries.

  4. It checks that no record in a child table can exist if its corresponding record is not available in the parent table.

 

Correct Answer: D

 

 

QUESTION 47

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

 

  1. SELECT INTO

  2. DELETE

  3. UPDATE

  4. ALTER

  5. SELECT

  6. INSERT

Correct Answer: ABCF

 

 

QUESTION 48

Which of the following commands can be used to change the authorization type in DB2 9? Each correct answer represents a complete solution. Choose all that apply.

 

  1. UPDATE DATABASE CONFIGURATION

  2. SET AUTHORISATION

  3. RESET DATABASE CONFIGURATION

  4. UPDATE DBM CFG

 

Correct Answer: AD

 

 

QUESTION 49

Smith works as a Database Administrator for DWorlds Inc. The management instructs him to plan a database where identifying the key objects or entities for database management is important. Which of the following database planning steps will help him to accomplish the task?

 

  1. Object identification

  2. Gathering information

  3. Identifying the relationships between objects

  4. Object modeling

 

Correct Answer: A

 

 

QUESTION 50

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.

 

  1. CREATE TRIGGER trgDeleteCustomer

ON dbo.Customers

BEFORE DELETE

AS

RAISERROR (‘Customers cannot be deleted. An error has been logged’, 16, 10) WITH LOG ROLLBACK TRANSACTION

 

  1. CREATE TRIGGER trgDeleteCustomer

ON dbo.Customers

AFTER DELETE

AS

RAISERROR (‘Customers cannot be deleted. An error has been logged’, 16, 10) WITH LOG ROLLBACK TRANSACTION

 

  1. CREATE TRIGGER trgDeleteCustomer

ON dbo.Customers

AFTER DELETE

AS

IF (SELECT COUNT(*) FROM DELETED) > 1

BEGIN

RAISERROR (‘Customers cannot be deleted. An error has been logged’, 16, 10) WITH LOG ROLLBACK TRANSACTION

END

 

  1. CREATE TRIGGER trgDeleteCustomer

ON dbo.Customers

AFTER DELETE

AS

IF (SELECT COUNT(*) FROM DELETED) > 0

BEGIN

RAISERROR (‘Customers cannot be deleted. An error has been logged’, 16, 10) WITH LOG ROLLBACK TRANSACTION

END

 

Correct Answer: BD

 

Instant Access to Download Latest Complete Collection of Microsoft MTA 98-364 Real Exam

Try Microsoft MTA 98-364 Free Demo