Database Sql Server
PT2520
Instructor: Mounir Berrada
Assignment 2
Unit 2 True/False Questions
Indicate whether the following statements are true or false on the student answer sheet.
1) A requirement is something a database needs to do in order to fulfill its purpose. True 2) You only need to include the most important stakeholders in the database discussions. False 3) Forms are used for gathering input. True 4) A transaction database is optimized to track transactions in real time. True 5) Data mining uses business intelligence tools and techniques on a variety of data sources brought together in a data warehouses. true 6) The domain is the focus or knowledge area of a database. True 7) Interviews are good for asking open ended questions.True 8) Open ended question are questions that don't have fixed answers. True 9) Questionnaires are good for asking open ended questions. False 10) Job shadowing is a good way to observe exceptions to the usual procedures and rules. True 11) A report requirement refers to the need to store data necessary to generate desired reports. True 12) User access refers to what objects and data in a database a user has permissions to use. True 13) Update permission is the permission to make changes to the database. False 14) Delete permission is the permission to remove records from database tables. False 15) A business rule is a rule that covers how data are acquired, stored or processed. True 16) User access refers to what objects and data in a database a user has permissions to use. True 17) Attributes are general headings and not the data itself. True 18) A candidate key is any attribute or combination of attributes that might make a primary key.True 19) A natural key is a key that consists of one or more attributes that naturally belongs to the entity. False 20) A composite key is a key that consists of a
Instructor: Mounir Berrada
Assignment 2
Unit 2 True/False Questions
Indicate whether the following statements are true or false on the student answer sheet.
1) A requirement is something a database needs to do in order to fulfill its purpose. True 2) You only need to include the most important stakeholders in the database discussions. False 3) Forms are used for gathering input. True 4) A transaction database is optimized to track transactions in real time. True 5) Data mining uses business intelligence tools and techniques on a variety of data sources brought together in a data warehouses. true 6) The domain is the focus or knowledge area of a database. True 7) Interviews are good for asking open ended questions.True 8) Open ended question are questions that don't have fixed answers. True 9) Questionnaires are good for asking open ended questions. False 10) Job shadowing is a good way to observe exceptions to the usual procedures and rules. True 11) A report requirement refers to the need to store data necessary to generate desired reports. True 12) User access refers to what objects and data in a database a user has permissions to use. True 13) Update permission is the permission to make changes to the database. False 14) Delete permission is the permission to remove records from database tables. False 15) A business rule is a rule that covers how data are acquired, stored or processed. True 16) User access refers to what objects and data in a database a user has permissions to use. True 17) Attributes are general headings and not the data itself. True 18) A candidate key is any attribute or combination of attributes that might make a primary key.True 19) A natural key is a key that consists of one or more attributes that naturally belongs to the entity. False 20) A composite key is a key that consists of a