Chapter 3 PHYSICAL DATABASE DESIGN AND IMPLEMENTATION 187
Chapter 3 PHYSICAL DATABASE DESIGN AND IMPLEMENTATION 187 APPLY YOUR KNOWLEDGE 12. You are the database developer for a leasing company. Your database includes a table that is defined as follows: CREATE TABLE Lease (Id Int IDENTITY NOT NULL CONSTRAINT pk_lesse_id PRIMARY KEY .NONCLUSTERED, Lastname varchar(50) NOT NULL, FirstName varchar(50) NOT NULL, SSNo char(9) NOT NULL, Rating char(10) NULL, Limit money NULL) Each SSNo must be unique. You want the data to be physically stored in SSNo sequence. Which constraint should you add to the SSNo column on the Lease table? A. UNIQUE CLUSTERED constraint B. UNIQUE UNCLUSTERED constraint C. PRIMARY KEY CLUSTERED constraint D. PRIMARY KEY UNCLUSTERED constraint 13. You are building a database and you want to eliminate duplicate entry and minimize data storage wherever possible. You want to track the following information for employees and managers: First name, middle name, last name, employee identification number, address, date of hire, department, salary, and name of manager. Which table design should you use? A. Table1: EmpID, MgrID, Firstname, Middlename, Lastname, Address, Hiredate, Dept, Salary. Table2: MgrID, Firstname, Middlename, Lastname. B. Table1: EmpID, Firstname, Middlename, Lastname, Address, Hiredate, Dept, Salary. Table2: MgrID, Firstname, Middlename, Lastname. Table3: EmpID, MgrID. C. Table1: EmpID, MgrID, Firstname, Middlename, Lastname, Address, Hiredate, Dept, Salary. D. Table1: EmpID, Firstname, Middlename, Lastname, Address, Hiredate, Dept, Salary. Table2: EmpID, MgrID Table3: MgrID. 14. You are developing an application and need to create an inventory table on each of the databases located in New York, Detroit, Paris, London, Los Angeles, and Hong Kong. To accommodate a distributed environment, you must ensure that each row entered into the inventory table is unique across all locations. How can you create the inventory table? A. Supply Identity columns using a different sequential starting value for each location and use an increment of 6. B. Use the identity function. At first location, use IDENTITY(1,1), at second location use IDENTITY(100000,1), and so on. C. Use a Uniqueidentifier as the key at each location. D. Use TIMESTAMP column as the key at each location. 15. You are building a new database for a company with ten departments. Each department contains multiple employees. In addition, each employee might work for several departments. How should you logically model the relationship between the department entity and the employee entity? A. A mandatory one-to-many relationship between department and employee. B. An optional one-to-many relationship between department and employee.
For reliable and cheap web hosting services please check tomcat web hosting website.