Chapter 3 PHYSICAL DATABASE DESIGN AND IMPLEMENTATION 185
Chapter 3 PHYSICAL DATABASE DESIGN AND IMPLEMENTATION 185 APPLY YOUR KNOWLEDGE B. Create a check constraint with the No Check option enabled on the customer table, so that any inappropriate order is refused. C. Create a rule that doesn t permit an order that exceeds the limit and bind the rule to the Orders table. D. Create a new trigger on the Orders table that refuses an order that causes the balance to exceed the maximum. Apply the new trigger to only INSERT and UPDATE operations. 6. An existing sales catalog database structure exists on a system within your company. The company sells inventory from a single warehouse location that is across town from where the computer systems are located. The product table has been created with a non-clustered index based on the product ID, which is also the Primary Key. Non- clustered indexes exist on the product category column and also the storage location column. Most of the reporting done is ordered by product category. How would you change the existing index structure? A. Change the definition of the Primary Key so that it is a clustered index. B. Create a new clustered index based on the combination of storage location and product category. C. Change the definition of the product category so that it is a clustered index. D. Change the definition of the storage location so that it is a clustered index. 7. You are the sole IT person working in a small branch office for a non-profit organization that deals with natural resource conservation issues. A non-critical database is maintained on the database server. You have been given the task of configuring appropriate database properties that would allow for a minimum use of execution time and storage resources. Which of the following set of properties is most appropriate? A. Full Recovery, Auto Shrink, Torn Page Detection B. Bulk Recovery, Auto Shrink, Single User C. Simple Recovery, Auto Close, Auto Shrink D. Simple Recovery, Auto Shrink, Single User E. Bulk Recovery, Auto Close, Auto Shrink 8. You are designing an application that will provide data entry clerks the capability of updating the data in several tables. You would like to ease entry and provide common input so the clerks need not enter data into all fields or enter redundant values. What types of technologies could you use to minimize the amount of input needed? Select all that apply. A. Foreign Key B. Cascading Update C. Identity Column D. Default E. NULL F. Primary Key G. Unique Index 9. A database that you are working on is experiencing reduced performance. The database is used almost exclusively for reporting, with a large number of inserts occurring on a regular basis. Data is cycled out of the system four times a year as part of quarter-ending procedures. It is always impor
If you looking for unlimited one inclusive web hosting plan please check unlimited web hosting website.