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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
Read more
EnsurepassQUESTION 91 Fill in the blank with the appropriate word. A ____________ printer is a type of printer that is connected directly to a computer. Correct Answer: local Explanation: A local printer is a type of printer that is connected…
Read more