04 - 4572 Words

Chapter 4: Constraints TRUE/FALSE 1. Constraints are rules used to enforce business rules, practices, and policies. ANS: T PTS: 1 REF: 91 2. Constraints are used to ensure the accuracy and integrity of the data contained in the database. ANS: T PTS: 1 REF: 91 3. A constraint can only be created as part of the CREATE TABLE command. ANS: F PTS: 1 REF: 93 4. A constraint name can consist of up to 10 characters. ANS: F PTS: 1 REF: 93 5. A primary key is usually given the abbreviation _pk in the constraint name if the name is assigned by the user. ANS: T PTS: 1 REF: 93 6. Any constraint can be created at the table or the column level. ANS: F PTS: 1 REF: 94 7. A foreign key constraint can only be created at the column†¦show more content†¦_________________________ ANS: T PTS: 1 REF: 93 5. A NOT NULL constraint can only be created at the table level. _________________________ ANS: F, column PTS: 1 REF: 94 6. Any type of constraint for a single column can be created at the column level. _________________________ ANS: T PTS: 1 REF: 94 7. If a data value violates a(n) constraint, the entire row is prevented from being added to the table. _________________________ ANS: T PTS: 1 REF: 95 8. If a(n) FOREIGN KEY constraint has been created for a table, it means the data values in that column must be unique and cannot contain NULL values. _________________________ ANS: F PRIMARY PRIMARY KEY PTS: 1 REF: 95 9. The ADD clause of the ALTER TABLE command is used to add a PRIMARY KEY constraint to an existing table. _________________________ ANS: T PTS: 1 REF: 95 10. A(n) FOREIGN KEY constraint is used to ensure that referential integrity exists between tables. _________________________ ANS: T PTS: 1 REF: 98-99 11. When a FOREIGN KEY constraint is being created, the REFERENTIAL keyword is used to indicate the table being referenced. _________________________ ANS: F, REFERENCES PTS: 1 REF: 99 12. The FOREIGN KEY constraint is usually placed on the one side of a one-to-many relationship. _________________________ ANS: F, many PTS: 1 REF: 92 | 99 | 116 13. If the ON DELETE CASCADE keywords areShow MoreRelatedChapter 04 Homework Questions5593 Words   |  23 PagesName: ________________________ Class: ___________________ Date: __________ ID: A Chapter 04 True/False Indicate whether the statement is true or false. ____ 1. Section 351 (which permits transfers to controlled corporations to be tax deferred) can be justified under the wherewithal to pay concept. ____ 2. Similar to like-kind exchanges, the receipt of â€Å"boot† under  § 351 can cause loss to be recognized. ____ 3. Tina incorporates her sole proprietorship with assets having aRead MoreCase 4-04683 Words   |  3 PagesTrueBlood Case 04-4 - Inventory The FASB Codification provides guidance on how developing animals and animals available and held for sale are to be valued. Section 905-330-35-2 states that developing animals are to be valued at the lower of cost or market. Section 05-330-32-3 states that animals available and held for sale are to be valued: a. The lower of cost or market †¨ b. At sales price less estimated costs of disposal, if all the following conditions exist: †¨ 1. The productRead MoreCase 04-7: Lighthouse773 Words   |  4 PagesCase 04-7: Lighthouse I. Summary The Lighthouse Company is dedicated to offer services to marine or shipping companies. Their services are based on the tracking and location of the boats of their clients. In order to offer the service, Lighthouse must install an equipment of tracking boats which will have a cost of sale of $10.000,00 dollars, no reimbursable and a tracking system with a monthly cost of sale of $300,00 dollars. This way their clients will continuously receive the data on theRead MoreTest 04 05 061644 Words   |  7 Pagesï » ¿Test 04 Question 1 5 out of 5 points If the subcontractor to whom a struck company has contracted work is unionized, its employees legally can refuse to perform the work. Such refusals are allowed under the Selected Answer: ally doctrine. Question 2 5 out of 5 points Which strike occurs when one union strikes to support another union s strike? Selected Answer: Sympathy Question 3 5 out of 5 points All of the following observations are true of fact-finding except Read MoreChapter 04: the Procurement Process Exercise 04-02: Review Procurement Master Data3738 Words   |  15 PagesChapter 04: Procurement Process Exercise 04-02: Basic Procurement Process Multi Company Code Rev: 01/17/2011 Introduction General Notes and Information It is strongly recommended that you read through the entire exercise prior to starting. Not all instructions can be provided in a linear manner. The following symbols are used to indicate important information, as described below: An arrow highlights an important instruction that must not be overlooked. A pencil prompts you to writeRead MoreCase 04-7 Lighthouse3548 Words   |  15 PagesI. Succint Lighthouse provides a ship tracking service for shipping companies to locate their ships at sea, as well as knowing their speed and the weather they are facing. Lighthouse does a contract for the delivery and installation of the physical device that is capable of achieving this through a tracking service that calls for a second contract. The price for the dedicated hardware (exclusive to Lighthouse services) and installation is a single nonrefundable amount of $10,000 payable at completionRead More03 06 04 Essay892 Words   |  4 Pagesï » ¿Lesson 06: Prepping Your Sources Annotated Bibliography Note-Taking Guide Fill in the notes for the amendment and for each of the three categories (multi-media, contemporary cases, advocacy documents). If you need support for the citation, consult the MLA Formatting Guide you printed from the lesson. Amendment for your topic (from the Bill of Rights) Citation: http://www.law.cornell.edu/constitution/fourth_amendment What information from this source seems the most important? Note key points mentionedRead MoreCmi Level 5 Unit 043137 Words   |  13 PagesLeadership and Management Development Programme Assessment Module 02 Michael Harman Curriculum Leader (Engineering and Motor Vehicle YCC) Performance Management Assignment (Unit 5003) Michael Harman Contents Introduction 3 Identifying and agreeing Performance Objectives 4 - 5 Assessing performance and provide feedback 6 Understanding Performance improvement 7 - 10 Applying Discipline and Grievance Procedures 11 - 12 Summary 13 Reference 14 Read More2007 04 06 163146 Chapter 7 1 956 Words   |  4 PagesHint: Use tables in text.) Description Debit Credit Note Receivable 1,101,460 Land 590,000 Discount on Note Receivable 401,460 Gain on Sale 110,000 Note Receivable1,987.07 Service Revenue Discount on Note Receivable 7/1/04 Notes Receivable $400,000.00 Discount on Notes Receivable $178,836.32 Service Revenue $221,163.68 To calculate the Discount on Notes Receivable: PV of $400,000 due in 8 years at 12% = $400,000*0.40388 = $161,552 PV of $12,000 payable annuallyRead Moreemazariegos case study 04 030115 Essay1458 Words   |  6 Pagesï » ¿Module 08 Case Study: Urinary System and Electrolyte/Acid-Base/pH Balance Each question is worth 1 point, unless otherwise noted. I Got To Micturate: Part I—Mini Case Studies Questions Case 1: Frank Johnson 1. How does the urinary system relate to sexual function in males? How does the prostate relate to the bladder infections in males? The reproductive system in the male is closely intertwined with the urinary system, both functionally and anatomically. The male reproductive system is so