Title: Competency 1 Assessment
Course: Introduction to Database (TEMPLATE)

Q: From a structural point of view, 1NF is better than 2NF.
- True
- False
A: False
If right: Correct

Q: In order to meet performance requirements  you may have to denormalize portions of the database design.
- True
- False
A: True
If right: Correct

Q: A relational table must not contain repeating groups.
- True
- False
A: True
If right: Correct

Q: To create a 1NF table, repeating groups must be eliminated and a primary key defined.
- True
- False
A: True

Q: Dependencies can be identified with the help of the dependency diagram.
- True
- False
A: True

Q: Because a partial dependency can exist only if a table's primary key is composed of several attributes, a table whose primary key consists of only a single attribute must automatically be in 2NF it it is in 1NF.
- True
- False
A: True

Q: A table is in Second Normal Form (2NF) if it is in 1NF and it includes no partial dependencies.
- True
- False
A: True

Q: It is possible for a table in Second Normal Form (2NF) to exhibit transitive dependency, where one or more attributes may be functionally dependent on nonkey attributes.
- True
- False
A: True

Q: A table is in Third Normal Form (3NF) if it is in 2NF and it includes no transitive dependencies.
- True
- False
A: True

Q: Normalization should be part of the design process.
- True
- False
A: True

Q: Database designers traditionally relied on good judgement to help them develop a good design.
- True
- False
A: True

Q: Knowing the minimum and maximum number of entity occurrences is very useful at the application software level.
- True
- False
A: True

Q: Business rules are derived from detailed descriptions of an organization's data, environment, transactions,and information requirements.
- True
- False
A: True

Q: Designing databases without first constructing carefully considered data models that are represented by ERDs is inadvisable.
- True
- False
A: True

Q: Data management is a discipline that focuses on
- the management of end users.
- The proper generation, storage, and retrieval of data.
- the help items to be used by end users.
- the proper generation, storage, and retrieval of information.
A: The proper generation, storage, and retrieval of data.

Q: DBMSs are important because
- we need good ways of managing such data.
- they contain a query language that makes it possible to produce ad hoc queries.
- they help create an environment for end users to have access to more data.
- all of the above.
A: all of the above.

Q: A database is an efficient way to __________________  related data.
- enter
- maintain
- retrieve
- all of the above
A: all of the above

Q: The Access DBMS allows you to create structure containing
- fields.
- tables.
- relationships.
- all of the above.
A: all of the above.

Q: A relational database is a group of
- common fields.
- field values
- records
- related tables.
A: related tables.

Q: The content of any given field is the
- database
- field value
- entity
- table
A: field value

Q: A foreign key must
- be numeric
- be unique
- be defined in all tables within the database
- match the field value of a primary key in a related table
A: match the field value of a primary key in a related table

Q: Of the following, what is NOT considered a software?
- System administrators
- Data Base Management System
- Operating Systems
- Application and Utilities
A: System administrators

Q: Of the database system environment which of the following is not considered part of the people component?
- Salesman
- Administrators
- Designers
- End Users
A: Salesman

Q: DBMS performs several important functions to guarantee the integrity and consistency of the data in the database.  Which of the following is NOT one of those functions?
- Multiuser access control
- Data integrity management
- Database access languages
- End of month reports
A: End of month reports

Q: A database model is a collection of logical constructs used to represent the data structure and relationship. Data models are
- conceptual
- conceptual and Relationship
- conceptual and Implementation
- implementation and relationship
A: conceptual and Implementation

Q: A relational database model
- does not require substantial hardware and system software overhead.
- does not promote "islands of information" problems
- allows trained people to use a good system poorly.
- improves implementation and management simplicity.
A: improves implementation and management simplicity.

Q: The entity relationship model
- has unlimited constraint representation.
- has unlimited relationship representation.
- has data manipulation language.
- has visual representation that makes it an effective communications tool.
A: has unlimited constraint representation.

Q: An ad hoc query is
- a pre-scheduled question
- a spur of the moment question
- a pre-planned question
- none of the above
A: a spur of the moment question

Q: Database models were developed to
- address the file system's inherent weaknesses.
- deposit data within a single file.
- keep data within multiple data repository.
- allow DBMS to maintain loose control over the database activities.
A: address the file system's inherent weaknesses.

Q: A table's contentes are displayed as rows and columns in
- a datasheet view.
- a database form.
- the query windows.
- the export window.
A: a datasheet view.

Q: The entity integrity rule requires that
- all entries are unique.
- a part of the key may be null.
- foreign key values do not reference primary key values.
- duplicate object values are allowed.
A: all entries are unique.

Q: Data are classified according to their format and function and consist of
- Numeric, Date, and Alphanumeric
- Numeric, Date, Alphanumeric, and Logical
- Numeric, Character, and Date
- Numeric, Character, Date, and Logical
A: Numeric, Character, Date, and Logical

Q: Each table is perceived as
- a flat structure.
- a two-dimensional structure.
- a linked structure.
- none of the above.
A: a two-dimensional structure.

Q: Each table must have
- a primary key.
- a secondary key.
- a foreign key.
- a logical key.
A: a primary key.

Q: A table can be logically connected to another table by defining a
- hyperlink
- common field
- primary key
- foreign key
A: common field

Q: In general terms, the _____ key is an attribute (or combination of attributes) that uniquely identifies any given entity.
- indexed
- primary
- foreign
- redundant
A: primary

Q: Within a table, the primary key must be unique so that it will identify each row.  When this is the case, the table is said to exhibit _________.
- referential integrity
- entity integrity
- enforced integrity
- all of the above
A: entity integrity

Q: In a sophisticated application development software, nulls can create problems when using functions such as
- count
- average
- sum
- all of the above
A: all of the above

Q: If a foreign key contains either matching values or nulls, the table(s) that make use of such a foreign key is/are said to exhibit _____ integrity.
- referential
- restrictive
- secondary
- redundant
A: referential

Q: A _____ key is defined as a key that is used strictly for data retrieval purposes.
- primary
- foreign
- secondary
- data
A: secondary

Q: A ___ key's effectiveness in narrowing down a search depends on how restrictive it is.
- primary
- foreign
- secondary
- search
A: secondary

Q: Database designers emply data models as communications tools to facilitate the interaction among
- the designers
- the applications programmers
- the users
- all of the above
A: all of the above

Q: A derived attribute
- must be stored physically withiin the database.
- need not be physically stored within the database.
- is derived by using an algorithm.
- b and c
A: b and c

Q: Normalization works through a series of stages called normal forms.  There are ___ stages generally used in business applications.
- 2
- 3
- 4
- 5
A: 3

Q: The conflicts between design efficiency, information requirements, and processing speed are often resolved through
- conversion from 1NF to 2NF
- conversion from 2NF to 3NF
- compromises that include normalization
- conversion from 3NF to 4NF
A: compromises that include normalization

Q: The performance of an information system depends on
- database design and implementation.
- application design and implementation.
- administrative procedures
- all of the above.
A: all of the above.

Q: The user requirements, Existing system evaluation, and Logical system design are part of the
- planning phase
- analysis phase
- detail System Design phase
- implementation phase
A: analysis phase

Q: Duriing the initial stages of the implementaton phase, the system enters into a cycle of
- coding
- testing
- debugging
- all of the above
A: all of the above

Q: During the Entity-Relationship modeling process, the designer must
- define entities, attributes, primary keys, and foreign keys.
- make decisions about adding new primay key attributes.
- make decisions about the treatment of multivalued attributes.
- all of the above.
A: all of the above.

Q: During the Entity-Relationship modeling process, the designer must
- draw corresponding Entity Relationship diagram.
- normalize the data model.
- make decisions about standard naming conventions.
- all of the above.
A: all of the above.