PT2520 Final Exam A Answers
1) Redundancy refers to what database condition?
2) Which best defines the function of a primary key?
3) What best describes the function of a foreign key?
4) Which best defines the function of SQL in a database?
5) A database entity can best be described as _____.
6) Which best defines the term database requirement?
7) Which of these best defines data integrity?
8) A document that has the primary purpose of summarizing and displaying data is called _____.
9) The focus of a database, the business problem it is designed to solve, is called _____.
10) Observing people at work to see how they interact with the data is called _____.
11) Which of the following best describes an attribute or combination of attributes that could be used as the primary key for an entity?
12) A key that consists of two or more attributes combined to make a unique value is called a ____.
13) Which of the following represents an advantage of a natural key?
14) Which of the following best defines a natural key?
15) Which of the following best defines a security requirement?
16) What types of relationships are depicted in this ERD?
17) When you encounter a many to many relationship, you should always _____.
18) Which of the following is a term for an entity that resolves a many to many relationship?
19) What term best describes the type of entity shown here?
20) What term best describes the entity EmployeeDependent?
21) Which of the following best defines the term normalization?
22) Which of the following is the normal form that removes all repeating groups and arrays?
23) Which of the following is the normal form that removes all transient dependencies?
24) A deletion anomaly occurs _____.
25) Which of the following is the term for database design adapted to the features and limitations of the database management system?
26) Which of the following is the term for database design adapted to the features and limitations of the database management system?
27) Which of the following best defines the term data type?
28) Which of the following is a variable character type?
29) In the following entity, what would be the best data type for BuildingAddress?
30) Which of the following best defines the term null?
31) Which of the following best defines the term referential integrity?
32) You cannot enter data into a foreign key table unless it is related to an existing record in the primary key table. Which action is most affected by this rule?
33) Which of the following describes some of the advantages of enforcing referential integrity?
34) When you design a table, you should allow nulls if _____.
35) In the SQL Management Studio, you can create relationships by dragging between entities in the _____.
36) Which of the following is the portion of SQL used to select and edit data?
37) Which of the following best describes the use of the * in SELECT *?
38) Which of the following is not acceptable of aliasing a column called CustomerFirstName?
39) Which of the following best describes what would be returned by a query with the following criteria?
41) Which of the following best defines the term aggregate function?
42) What is the error in the following SQL statement?
43) What would be the effect of this UPDATE statement?
44) Which of the following is the type of join that only returns related records from the joined tables?
45) Which of the following is the type of join that uses the where clause with an equal sign to relate tables?
46) Which of the following is the term for determining if a user is who he or she claims to be?
47) Which of the following is the best definition for the term permission?
48) Which of the following is a server level account?
49) A collection of related permissions is called a _____.
50) Which of the following is a built in database role that allows a user control over the database?
No comments:
Post a Comment