[Free] Download New Latest (January 2016) Microsoft 98-364 Real Exam 111-120

Ensurepass

QUESTION 111

You work as an Application Developer for Nero Inc. You want to instruct the DBMS to set the transaction isolation level so that when a user updates a table in the database, other users cannot read the value at the same time. Which of the following methods will you use to define the transaction level?

 

A.     setTransactionIsolation()

B.     isClosed()

C.     getTransactionIsolation()

D.     supportsTransactions()

 

Correct Answer: A

 

QUESTION 112

You work as a Database Designer for Realtech Inc. You want to create two tables, Product and Order, such that a row in the Order table does not exist without a corresponding row in the Product table. The structure of the Product and Order tables with their respective columns is given below:

 

Ÿ   Product

Ÿ   ProductID

Ÿ   ProductNumber

Ÿ   Date_of_manufacturing

Ÿ   SupplierID

Ÿ   ProductPrice

Ÿ   ProductQty

Ÿ   Order

Ÿ   OrderID

Ÿ   OrderDate

Ÿ   OrderQuantity

Ÿ   OrderPrice

 

Based on this information, while maintaining the integrity of this rule, what will you do to accomplish the task?

 

A. 
   
Create the Product table, and then create the Order table. Create a third table that will be used to join the Product and Order tables by using FOREIGN KEY constraints.

B.     Create the Product table, and then create the Order table that has a primary key referenced by the foreign key in the Product table.

C.     Create the Product table, and then create the Order table. Create a primary key in both the tables and form a one-to-one relationship.

D.     Create the Product table, and then create the Order table that has a foreign key constraint that references the primary key in the Product table.

 

Correct Answer: D

 

 

QUESTION 113

Which of the following are the correct statements of using the Flashback Query feature in Oracle? Each correct answer represents a complete solution. Choose all that apply.

 

A.     CREATE TABLE AS SELECT AS OF

B.     SELECT AS OF

C.     CREATE TABLE AS SELECT

D.     INSERT INTO (SELECT)

 

Correct Answer: AB

QUESTION 114

Which of the following are the steps of database planning life cycle? Each correct answer represents a part of the solution. Choose three.

 

A.     Application Design

B.     Data conversion and loading

C.     Conceptual database design

D.     Operational Maintenance

 

Correct Answer: ABD

 

 

QUESTION 115

You manage a SQL Server 2008 server that hosts a database named Sales. Unauthorized modifications to some tables within the Sales database have resulted in some views no longer working. You need to implement a method that will ensure that all modifications to any objects with the Sales database are logged. What should you do?

 

A.     Create a DDL trigger with database scope.

B.     Create a DML trigger with database scope.

C.     Create a DML trigger with server scope.

D.     Create a DDL trigger with server scope.

 

Correct Answer: A

 

 

QUESTION 116

Which of the following are considered limitations of the legacy LOB implementation?

 

A.     Legacy LOBs are not available in a RAC environment.

B.     DML access is multi-threaded.

C.     User-defined version control

D.     Randomly writing data to LOBs was preferable to reading LOB data.

 

Correct Answer: C

 

 

QUESTION 117

Which of the following properties of the database transaction has been defined in the given statement: “Either all the changes or no changes have been made in the database.”

 

A.       Durability

B.       Atomicity

C.       Consistency

D.       Isolation

 

Correct Answer: B

 

 

QUESTION 118

You work as a Database Designer for Allen Inc. You are designing the database of a company that has several divisions (e.g. Spare Parts division). Each division has several departments (e.g. Quality Control department), and every department has several employees. What will be the relationship between the two entities, namely, division and employee, if you model the database?

 

A.     No direct relationship

B.     One-to-one

C.     Many-to-many

D.     One-to-many

 

Correct Answer: A

 

 

QUESTION 119

Roger is the HR Manager of Neon Inc. He wants to generate a report of all the employees working in Department ID 30 from the Emp table on the following attributes:

 

Ÿ   Fname

Ÿ   Lname

Ÿ   Salary

 

All the records should be sorted in ascending order of the Lname attribute. Which of the following queries will he use to get the required output?

 

A.     SELECT Fname Lname Salary FROM Emp WHERE DeptId=30 ORDER BY Lname

B.     SELECT Fname, Lname, Salary FROM Emp ORDER BY Lname WHERE DeptId=30

C.     SELECT Fname Lname Salary FROM Emp ORDER BY Lname WHERE DeptId=30

D.     SELECT Fname, Lname, Salary FROM Emp WHERE DeptId=30 ORDER BY Lname

 

Correct Answer: D

 

 

QUESTION 120

Merlyn works as a Database Administrator for DOW Inc. She is currently designing a database. She wants to break down the preliminary specifications into smaller components so that each component describes a basic fragment of the specifications. Which of the following approaches is she using?

 

A.     Inside-out approach

B.     Top-down approach

C.     Mixed approach

D.     Bottom-up approach

 

Correct Answer: D

 

Free VCE & PDF File for Microsoft 98-364 Real Exam

Instant Access to Free VCE Files: MCSE|MCSA|MCITP…
Instant Access to Free PDF Files: MCSE|MCSA|MCITP…