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 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 [...]
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?   TRANSACTION_SERIALIZABLE TRANSACTION_NONE TRANSACTION_READ_COMMITTED TRANSACTION_READ_UNCOMMITTED TRANSACTION_REPEATABLE_READ   Correct Answer: B       QUESTION 52 Which of the following provides reliable units of work that allow correct recovery from failures and keeps a database consistent Read more [...]
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 [...]
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.   An attribute declared as a primary key cannot contain NULL values. Each Read more [...]
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 [...]
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.   FEDERATED MyISAM MERGE InnoDB   Correct Answer: BD     QUESTION 12 Which of the following can be used Read more [...]
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?   4 NF 2 NF 1 NF 3 NF   Correct Answer: B     QUESTION 2 You work as a Database Designer Read more [...]