CIS 106 Chapter 2 Relational Databases and Queries Multiple Choice Questions http://homeworktimes.com/downloads/cis-106-chapter-2-relational-databases-queries-multiplechoice-questions/
1.) When entering, deleting, or editing table data: A.) The table must be in Design View B.) The table must be in Datasheet View C.) The table may be in either Datasheet or Design View D.) Data may be entered only in a form 2.) Which of the following is true for the Query Wizard? A.) You can only select tables as a source B.) No criteria can be added C.) Fields from multiple tables are not allowed D.) You do not need a summary 3.) Which of the following was not a suggested guideline for designing a table? A.) Include all necessary data B.) Store data in its smallest parts C.) Avoid calculated fields D.) Link tables using common fields
4.) A query’s specifications providing instructions about which records to include must be entered: A.) On the Show row of the query design grid B.) On the Sort row of the query design grid C.) On the Criteria row of the query design grid D.) On the Table row of the query design grid 5.) An illustration of a one-to-many relationship would be: A.) A person changes his/her primary address B.) A customer may have multiple orders C.) A branch location has an internal branch ID code D.) A balance field is totaled for all accounts for each person 6.) When adding criteria to the query design view: