New Updated Microsoft MTA 98-364 Real Exam Questions and Answers Download 51-60

Ensurepass

QUESTION 51

JDBC API 2.0 defines five levels of transaction isolation for database concurrency control. Which of the following is the lowest level of transaction isolation?

 

  1. TRANSACTION_SERIALIZABLE

  2. TRANSACTION_NONE

  3. TRANSACTION_READ_COMMITTED

  4. TRANSACTION_READ_UNCOMMITTED

  5. TRANSACTION_REPEATABLE_READ

 

Correct Answer: B

 

 

 

QUESTION 52

Which of the following provides reliable units of work that allow correct recovery from failures and keeps a database consistent even in cases of system failure?

 

  1. Database security

  2. Concurrency control

  3. Two-phase commit

  4. Database transaction

 

Correct Answer: D

 

 

QUESTION 53

Which of the following DML SQL statements support usage of correlated sub-queries? Each correct answer represents a complete solution. Choose all that apply.

 

  1. INSERT

  2. UPDATE

  3. DELETE

  4. SELECT

 

Correct Answer: BC

 

 

QUESTION 54

Which of the following are the types of prototyping strategies? Each correct answer represents a complete solution. Choose two.

 

  1. Requirements prototyping

  2. Physical prototyping

  3. Revolutionary prototyping

  4. Evolutionary prototyping

 

Correct Answer: AD

 

 

QUESTION 55

Which of the following commands cannot be rolled back? Each correct answer represents a complete solution. Choose two.

 

  1. DELETE

  2. TRUNCATE

  3. UPDATE

  4. COMMIT

 

Correct Answer: BD

 

 

QUESTION 56

A table named Emp is given below that contains data of an organization.

 

98-364-demo-12

 

How many records will be displayed if the following SQL query is executed?

 

SELECT *

FROM Emp

WHERE Name BETWEEN ‘D’ AND ‘F’

 

  1. 2

  2. A character column cannot be used in the BETWEEN operator.

  3. 3

  4. 4

 

Correct Answer: C

 

 

QUESTION 57

Mark works as a Database Designer for Reon Inc. He is assigned the task to create a database for the company. He issues the following query to create the database.

 

CREATE DATABASE ‘24342’

 

What will be the output of the query?

 

  1. A database will be created.

  2. An error will be generated stating that a database name must begin with an alphabet and all the alphabets should be in uppercase.

  3. An error will be generated stating that a database name must begin with an alphabet.

  4. An error will be generated stating that a database name should be a combination of numerals and alphabets.

 

Correct Answer: A

 

 

QUESTION 58

What is the ideal time to back up dynamic log files?

 

  1. When the server is running.

  2. You can back up dynamic log files any time.

  3. When the server is stopped.

  4. When the server is shut down.

 

Correct Answer: C

 

 

QUESTION 59

You work as a MySQL Database Administrator. Your server crashed and it was recovered and made online within half an hour. What will you do to ensure that the table structure and contents are in a proper state?

 

  1. Perform a table optimization operation.

  2. Perform a table repair operation.

  3. Perform a table analysis operation.

  4. Perform a table check operation.

 

Correct Answer: D

 

 

QUESTION 60

James works as an Administrator for Softech Inc. The company has a SQL Server 2005 computer named SQL1. The company has six departments; Accounting, Sales, Marketing, Manufacturing, Production, and Research. The user accounts of each department are located in a domain group named after the department. James wants to create a separate database on SQL1 for each department which will store the department related information. Users in each department must be able to read and update data in the database belonging to their respective departments. No user must be able to access the database belonging to another department. James wants to configure access to the database to meet these requirements. What should James do to accomplish the task?

 

  1. James should create a Windows Authentication login for each domain group and configure the logins as database users for the appropriate database. Add each database user to the db_ddladmin database role.

  2. James should create a Windows Authentication login for each domain group and configure the logins as database users for the appropriate database. Add each database user to the db_datareader and db_datawriter database roles.

  3. James should create a Windows Authentication login for each domain user and configure the logins as database users for the appropriate database. Add each database user to the db_ddladmin database role.

  4. James should create a Windows Authentication login for each domain user and configure the logins as database users for the appropriate database. Add each database user to the db_datareader and db_datawriter database roles.

 

Correct Answer: B

 

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

Try Microsoft MTA 98-364 Free Demo