Tag: 98-364 Exam

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?   varchar nvarchar geography GPS   Correct Answer: C     QUESTION 102 Which of the following statements are correct Read more [...]

EnsurepassQUESTION 91 Which of the following statements are true regarding DML? Each correct answer represents a complete solution. Choose all that apply.   It enables users to access/manipulate data in a database. It is used to specify additional properties of the data. It is used to specify a database schema by a set of definitions. It can be procedural or declarative.   Correct Answer: AD     QUESTION 92 Which of the following is NOT a valid DDL command?   UPDATE Read more [...]

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?   Object identification Requirements collection and analysis Gathering information Application Design   Correct Answer: B     QUESTION 82 Which of the following statements is true regarding a composite key in a table?   It is a primary key. It is a primary or foreign key that consists Read more [...]

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?   Object identification Requirements collection and analysis Gathering information Application Design   Correct Answer: B     QUESTION 82 Which of the following statements is true regarding a composite key in a table?   It is a primary key. It is a primary or foreign key that consists Read more [...]

EnsurepassQUESTION 71 Examine the following table:     What is the degree of this table?   20 25 5 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 in ascending order of sales. Which of the following queries should be issued to get the desired output? Read more [...]

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?   It will not violate any normal form (NF). 1NF 3NF 2NF   Correct Answer: D     QUESTION 62 You Read more [...]