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

EnsurepassQUESTION 161 This question requires that you evaluate the underlined text to determine if it is correct.   A view can be used to ensure referential integrity.   Review the underlined text. If it makes the statement correct, select “No change is needed.” If the statement is incorrect, select the answer choice that makes the statement correct   A. No change is needed. B. Save an extra copy of data stored in a separate table. C. Limit access to specific rows or columns Read more […]

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

EnsurepassQUESTION 141 You have a table named Product. The Product table has columns for ProductDescription and ProductCategory.   You need to change the ProductCategory value for all the spoons in the Product table to 43.   Which statement should you use?     A. Option A B. Option B C. Option C D. Option D   Correct Answer: A     QUESTION 142 This question requires that you evaluate the underlined text to determine if it is correct.   A row Read more […]

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

EnsurepassQUESTION 151 You need to store the first name, last name, and student ID for 100 students. This information will be stored in a table as:   A. 100 items and three cells. B. 100 rows and three columns. C. three rows and 100 columns. D. three items and 100 cells.   Correct Answer: B     QUESTION 152 The terms “bitmap,” “b-tree,” and “has h” refer to which type of database structure?   A. View B. Function C. Index D. Stored procedure E. Read more […]

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

EnsurepassQUESTION 131 Which database term is used to describe the process of applying a backup to a damaged or corrupt database?   A. Recover B. Restore C. Commit D. Attach   Correct Answer: B             QUESTION 132 Which statement deletes the rows where the employee’s phone number is not entered?     A. Option A B. Option B C. Option C D. Option D   Correct Answer: A     QUESTION 133 You develop a database Read more […]

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

EnsurepassQUESTION 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.     Read more […]

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

EnsurepassQUESTION 121 John works as a Database Administrator for DataOneWorld Inc. The company has a SQL Server database. John wants to insert records in a table where the database is structured in a fixed format. Which of the following data models will he use to accomplish the task?   A.     Object relational data model B.     Entity-Relationship Model C.     Network data model D.     Relational model   Correct Read more […]

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

EnsurepassQUESTION 101 You are modifying a database that is used as a backend for a web site. The web site developers want to include positional data that can be used by the web site users to determine store locations information that is stored in the Stores table of the database. You are asked to add a column to the Stores table. What data type should you use?   A.     varchar B.     nvarchar C.     geography D.     Read more […]

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

EnsurepassQUESTION 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?   A.     Object identification B.     Requirements collection and analysis C.     Gathering information D.     Application Design   Correct Answer: B     QUESTION 82 Which of the following statements is true regarding Read more […]

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

EnsurepassQUESTION 91 Which of the following statements are true regarding DML? Each correct answer represents a complete solution. Choose all that apply.   A.     It enables users to access/manipulate data in a database. B.     It is used to specify additional properties of the data. C.     It is used to specify a database schema by a set of definitions. D.     It can be procedural or declarative.   Correct Read more […]

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

EnsurepassQUESTION 71 Examine the following table:     What is the degree of this table?   A.     20 B.     25 C.     5 D.     4   Correct Answer: D     QUESTION 72 A company named Rel Inc. has many authorized dealers across the country who sell their products. The Sales Manager of the company wants to see the details of the authorized dealers, including the name, region, and total sales Read more […]

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

EnsurepassQUESTION 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?   A.     TRANSACTION_SERIALIZABLE B.     TRANSACTION_NONE C.     TRANSACTION_READ_COMMITTED D.     TRANSACTION_READ_UNCOMMITTED E.      TRANSACTION_REPEATABLE_READ   Correct Answer: B     QUESTION Read more […]

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

EnsurepassQUESTION 61 Two tables, namely, OrderItem and Item are depicted below in which all attributes mentioned therein respectively, refer to column heading labels.     If the ItemName attribute is moved from the Item table to the OrderItem table, then will it violate any normalization form? If yes, then which of the following normalization forms will be violated?   A.     It will not violate any normal form (NF). B.     1NF C.     Read more […]

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

EnsurepassQUESTION 21 You work as the Database Administrator for www.company.com. All servers on the www.company.com network run Windows Server 2003 and Windows Server 2000, and all client computers run Windows XP professional and Windows Vista. The www.company.com network area consists of a single Active Directory domain named www.company.com. The www.company.com network contains a Microsoft SQL Server 2005 database server named COMPANY-DB111, which you administer at a regular interval of time. Read more […]

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

EnsurepassQUESTION 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.   A.     An attribute declared as a primary key cannot Read more […]

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

EnsurepassQUESTION 41 You work as a Database Developer for GraySoft Inc. You are designing a database to record information about potential customers. You create a table named ProductInquiry for the database. The table is given below:     You want to uniquely identify the product in which a customer is interested. Choose the columns on which a PRIMARY KEY constraint needs to be created to accomplish this.   Select and Place:   Correct Answer:     QUESTION 42 Which Read more […]

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

EnsurepassQUESTION 11 You are a Database Administrator of MySQL database. Few days back, your server crashed. Now, it is up and online. You need to check the integrity of various tables used in the database. You need to issue the CHECK TABLE command. For which of the following tables will this command work? Each correct answer represents a complete solution. Choose two.   A.     FEDERATED B.     MyISAM C.     MERGE D.     Read more […]

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

EnsurepassQUESTION 1 John works as a Database Administrator for Bluewell Inc. The company has a SQL Server database. A table in the database has a candidate key and an attribute that is not a constituent of the candidate key. The non-key attribute depends upon the whole of the candidate key rather than just a part of it. Which of the following normal forms is represented in the scenario?   A.     4 NF B.     2 NF C.     1 NF D.     Read more […]