Study CCNA, CCNP, Azure, A+, Network+ for free!
Here you can find articles and questons that will help you to pass 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 […]
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. […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 directly to a computer. If a printer is a universal serial bus (USB) model, Windows […]
EnsurepassQUESTION 101 DRAG DROP A company’s environment includes an Active Directory Domain Services (AD DS) domain. The print server runs Windows Server 2008 R2 and all printers are networked by using TCP/IP. Only domain users have permissions to access the print server and printers published in AD DS. A visitor is connected to the network […]