New Updated Microsoft MTA 98-364 Real Exam Questions and Answers Download 81-90

Ensurepass

QUESTION 81

Which of the following is the process of collecting and analyzing information about the part of the organization that is to be supported by the database application?

 

1. Object identification

2. Requirements collection and analysis

3. Gathering information

4. Application Design

 

Correct Answer: B

 

 

QUESTION 82

Which of the following statements is true regarding a composite key in a table?

 

1. It is a primary key.

2. It is a primary or foreign key that consists of two or more attributes of the table.

3. It is a combination of the primary key and the foreign key.

4. It is a foreign key.

 

Correct Answer: B

 

 

QUESTION 83

Which of the following approaches begins with the identification of only a few important concepts and, based on these, the design proceeds, spreading outward ‘radially’?

 

1. Inside-out approach

2. Bottom-up approach

3. Mixed approach

4. Top-down approach

 

Correct Answer: A

 

 

QUESTION 84

You have created a database for employee management. The database has a table named Employees. The table has the following attributes:

 

• Name

• Address

• Contact Number

• Designation

 

You want to store the salary information for each employee. The database should also store salary history. How will you design the database so that you can query the last increment given to a particular employee?

 

1. Create a new table that includes the EmployeeSalary and DateOfIncrement columns. Create a one-to-one relationship with the Employees table.

2. Create a new table that includes the EmployeeID, EmployeeSalary, and DateOfIncrement columns. Create a one-to-many relationship with the Employees table.

3. Add the EmployeeSalary and DateOfIncrement columns to the Employees table.

4. Create a new table that includes the EmployeeSalary and DateOfIncrement columns. Create a many-to-many relationship with the Employees table using the new table.

 

Correct Answer: B

 

 

QUESTION 85

Mark works as a Database Administrator for DataOneWorld Inc. The company has a SQL Server database. Mark has to change the properties of an object inside the database. Which of the following statements will he use to accomplish the task?

 

1. DROP

2. UPDATE

3. CREATE

4. ALTER

 

Correct Answer: D

 

 

 

QUESTION 86

Mark works as the Database Administrator for DataWorld Inc. The company has a SQL server 2008 database. Mark wants to protect the database from unintended activities made by authorized individuals or processes such as authenticated misuse, malicious attacks, or inadvertent mistakes. Which of the following should he use to accomplish the task?

 

1. Native auditing

2. Abstraction

3. Referential integrity

4. Database security

 

Correct Answer: D

 

 

QUESTION 87

Rick works as a database administrator for a MySQL server. The server uses the InnoDB storage engine. Rick finds that a table’s performance is inconsistent. He wants to bring the table to a consistent state without shutting down the server. Choose the required steps to accomplish the task.

 

Select and Place:

 

Correct Answer:

 

 

 

 

QUESTION 88

Examine the following table:

 

 

In the table, you deleted the record of Mark Smith. Which of the following will change as a result?

 

1. Degree of the table

2. Cardinality of the table

3. Domain of the table

4. Attribute of the table

 

Correct Answer: B

 

 

QUESTION 89

Which of the following files contain configuration information that must be restored after a MySQL database server has crashed? Each correct answer represents a complete solution. Choose two.

 

1. My.ini

2. My.cnf

3. Master.info

4. Binary log files

 

Correct Answer: AB

 

 

QUESTION 90

John works as a Database Administrator in www.company.com Inc. The company has a SQL Server database. John wants to create a table named employees in the database. The table will have the id, firstname, lastname, and dateofbirth columns. John has to ensure that the lastname column does not allow null values. Which of the following queries will he use to accomplish the task?

 

1. CREATE TABLE employees (id INTEGER PRIMARY KEY, firstname CHAR(50)NULL, lastname CHAR (75)NOT NULL, dateofbirth DATE NULL);

2. CREATE TABLE employees (id INTEGER PRIMARY KEY, firstname CHAR(50)NULL, lastname CHAR (75), dateofbirth NULL);

3. CREATE TABLE employees (id INTEGER PRIMARY KEY, firstname CHAR(50)NULL, lastname CHAR (75) NOT NULL);

4. CREATE TABLE employees (id INTEGER PRIMARY KEY, firstname CHAR(50)NULL, lastname CHAR (75), dateofbirth DATE NULL);

 

Correct Answer: A

 

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

Try Microsoft MTA 98-364 Free Demo