New Updated Microsoft MTA 98-364 Real Exam Questions and Answers Download 31-40

Ensurepass

QUESTION 31

Remo works as a Database Designer for Tech Inc. He wants to create a table named Product. He issues the following query to create the Product table:

 

CREATE Product (

ProductID Char (10) NOT NULL,

OrderID Char (10) NULL

ProductName Varchar NOT NULL,

Primary key (OrderID, ProductID))

 

What are the errors in the above query? Each correct answer represents a complete solution. Choose two.

 

  1. An attribute declared as a primary key cannot contain NULL values.

  2. Each attribute should be defined as a primary key separately.

  3. A table cannot have two primary keys.

  4. ProductName is declared as Varchar without specifying the width of the column.

 

Correct Answer: AD

 

 

QUESTION 32

What is the relationship between the foreign key and primary key? Each correct answer represents a complete solution. Choose all that apply.

 

  1. A foreign key constraint works in conjunction with a primary key constraint to enforce referential integrity among related entities.

  2. A foreign key ties attribute(s) of an entity to the primary key of another entity, for the purpose of creating a dependency.

  3. There is no relationship between a primary key and a foreign key.

  4. A foreign key and a primary key create a link between two entities.

 

Correct Answer: AB

 

 

QUESTION 33

Mark works as a Database Administrator for DataWorld Inc. The company has a SQL Server database. Management instructs him to ensure that no inconsistent data is entered in the database. Which of the following will help him to accomplish the task?

 

  1. Referential integrity

  2. Abstraction

  3. Encryption

  4. Authentication

  5. Native auditing

 

Correct Answer: A

 

 

 

 

 

 

QUESTION 34

You work as a Database Designer for Netwell Inc. The database has a table named Project, which is depicted below:

 

ProjectID

ProjectName

TaskID

TaskName

A

Macwell

Design

A

Macwell

Coding

B

Vintech

Design

B

Vintech

Coding

 

Is the table given above in normalized form? If not, then which normal form (NF) is violated?

 

  1. The table is in normal form, as each cell contains only one value.

  2. 3NF

  3. 1NF

  4. 2NF

 

Correct Answer: BD

 

 

QUESTION 35

Which of the following statements about rebuilding an index is true?

 

  1. The NOLOGGING and ONLINE keywords can never be used together.

  2. Without the ONLINE keyword the index is locked for any DML operation.

  3. The NOLOGGING and ONLINE keywords are always used together.

  4. Without the ONLINE keyword the index is locked for the SELECT operation.

 

Correct Answer: B

 

 

 

QUESTION 36

You work as a database developer for www.company.com.com. The company has a database named www.company.com that is hosted on a SQL Server 2008 server. The database includes a table named Employees, which contains the details of the employees. You want to ensure that anytime any data in the Employees table is modified with an UPDATE statement, they are recorded in a table named EmployeeChanges. The EmployeeChanges table includes columns to record what the change was, who made the change, and when they made the change. What should you create to meet this need?

 

  1. A DDL trigger that queries the updated table

  2. A DML trigger that queries the inserted table

  3. A DDL trigger that queries the inserted table

  4. A DML trigger that queries the updated table

 

Correct Answer: B

 

 

QUESTION 37

You want to recover one or more tablespaces to a point in time older than the rest of the database. Which of the following are the recovery situations in which tablespace Point-in-Time Recovery (TSPITR) should be used? Each correct answer represents a part of the solution. Choose all that apply.

 

  1. To recover a tablespace that contains rollback segments.

  2. To recover a table that has become logically corrupted.

  3. To recover a DML statement that has affected only a subset of the database.

  4. To recover a tablespace on a very large database.

 

Correct Answer: ABC

 

 

QUESTION 38

Linda works as a Database Designer for Lion Inc. She has been given an assignment to design the database of a publishing company. The database has a table named Author, which has a composite key, AuthorID and TitleID. Royalty and LiteraryAgent are the other attributes. The functional dependencies are such that AuthorID + TitleID-> Royalty (i.e. Royalty is functionally dependent on AuthorID and TitleID) and AuthorID-> LiteraryAgent (i.e. LiteraryAgent is functionally dependent on AuthorID). Which of the following is true about this table?

 

  1. It violates 4NF.

  2. It violates 2NF.

  3. It violates 1NF.

  4. There is no violation.

Correct Answer: B

 

 

QUESTION 39

Which of the following is a management activity that allows the stages of the database application to be realized as efficiently and effectively as possible?

 

  1. Database planning

  2. Identifying information for objects

  3. Object identification

  4. Requirements collection and analysis

 

Correct Answer: A

 

 

QUESTION 40

You work as a Database Administrator for Bell Ceramics Inc. An employee of the company has fired a query, including a DML statement, such as INSERT, against a table named Sales. You notice that the DML statement has not executed. What will you do to resolve the issue? Each correct answer represents a complete solution. Choose two.

 

  1. Clean up all the uncommitted transactions on the Sales table.

  2. Add more space to the tablespace and increase the users quota on the tablespace.

  3. Provide redundant network paths from the client computer to the server along with additional listener connections on the Oracle server and redundant network cards on the Oracle server.

  4. Provide an appropriate privilege or create views on the Sales table, and grant privileges on the view.

 

Correct Answer: BD

 

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

Try Microsoft MTA 98-364 Free Demo