New Updated Microsoft MTA 98-364 Real Exam Questions and Answers Download 91-100

Ensurepass

QUESTION 91

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

 

  1. It enables users to access/manipulate data in a database.

  2. It is used to specify additional properties of the data.

  3. It is used to specify a database schema by a set of definitions.

  4. It can be procedural or declarative.

 

Correct Answer: AD

 

 

QUESTION 92

Which of the following is NOT a valid DDL command?

 

  1. UPDATE

  2. ALTER

  3. DROP

  4. CREATE

 

Correct Answer: A

 

 

QUESTION 93

Peter works as a Database Administrator for UnrealTech Inc. Management instructs him to create a schema that is gradually expanded from one level to another through appropriate modifications. Which of the following approaches will he use to accomplish the task?

 

  1. Top down approach

  2. Bottom up approach

  3. Mixed approach

  4. Inside-out approach

 

Correct Answer: A

 

 

QUESTION 94

You are a database developer for a database named Sales hosted on a SQL Server 2008 server. The Sales database includes the Exams and ExamQuestions tables. If any questions are modified for an exam, you need to ensure that the ExamModifiedDate in the Exams table is updated with the date and time of the update. The ExamQuestions table includes an INSTEAD OF trigger that records when and who last modified each question. Therefore, you decide to create a trigger. You only want the trigger to fire if a constraint violation has not occurred. Which of the following code will create the trigger to meet your goals?

 

  1. CREATE TRIGGER trgExamQuestionsModified

ON dbo.ExamQuestions

INSTEAD OF UPDATE NOT FOR REPLICATION

AS

UPDATE Exams

SET ExamModifiedDate = GetDate()

FROM inserted

WHERE inserted.ExamID = Exams.ExamID

 

  1. CREATE TRIGGER trgExamQuestionsModified

ON dbo.ExamQuestions

AFTER UPDATE NOT FOR REPLICATION

AS

UPDATE Exams

SET ExamModifiedDate = GetDate()

FROM inserted

WHERE inserted.ExamID = Exams.ExamID

 

  1. CREATE TRIGGER trgExamQuestionsModified

ON dbo.ExamQuestions

AFTER UPDATE FOR REPLICATION

AS

UPDATE Exams

SET ExamModifiedDate = GetDate()

FROM inserted

WHERE inserted.ExamID = Exams.ExamID

 

  1. CREATE TRIGGER trgExamQuestionsModified

ON dbo.Exams

AFTER UPDATE NOT FOR REPLICATION

AS

UPDATE Exams

SET ExamModifiedDate = GetDate()

FROM inserted

WHERE inserted.ExamID = Exams.ExamID

 

Correct Answer: B

 

 

QUESTION 95

You are the database administrator of a MySQL database server. Your network contains a combination of new and old (pre-4.1) MySQL clients. You are configuring a new server for testing purposes. You want to allow connections only by the clients that have new-format passwords. Which of the following steps will you take to accomplish the task?

 

  1. Start the server with the –old-password option.

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

  3. Start the server with the –enable-named-pipe option.

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

 

Correct Answer: B

 

 

QUESTION 96

Which of the following commands are used to terminate a transaction? Each correct answer represents a complete solution. Choose all that apply.

 

  1. TRUNCATE

  2. DELETE

  3. ROLLBACK

  4. COMMIT

 

Correct Answer: ACD

 

 

QUESTION 97

Which of the following refers to the system, processes, and procedures that protect a database from unintended activities, such as authenticated misuse, malicious attacks, or inadvertent mistakes made by authorized individuals or processes?

 

  1. Database security

  2. Encryption

  3. Abstraction

  4. Referential integrity

Correct Answer: A

 

 

QUESTION 98

Which of the following is undertaken at any time prior to the logical design, provided that sufficient information is available regarding system requirements?

 

  1. Application design

  2. Prototyping

  3. DBMS selection

  4. Database planning

 

Correct Answer: C

 

 

QUESTION 99

Mark works as a Database Administrator for Techworld Inc. He wants to remove the columns from a table that are not dependent on the primary key. Which of the following normal forms will help him accomplish the task?

 

  1. 4 NF

  2. 6 NF

  3. 5 NF

  4. 3 NF

 

Correct Answer: D

 

 

QUESTION 100

You are a Database Administrator for MySQL database. Users are complaining of slow query execution in a few tables. You need to ensure that contents of those tables are accessed more efficiently. You are sure that the table structure and its contents have no problems. Which of the following steps will you take to accomplish the task? Each correct answer represents a part of the solution. Choose two.

 

  1. Perform a table analysis operation.

  2. Perform a table repair operation.

  3. Perform a table optimization operation.

  4. Perform a table check operation.

 

Correct Answer: AC

 

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

Try Microsoft MTA 98-364 Free Demo