Accounting
Anthropology
Archaeology
Art History
Banking
Biology & Life Science
Business
Business Communication
Business Development
Business Ethics
Business Law
Chemistry
Communication
Computer Science
Counseling
Criminal Law
Curriculum & Instruction
Design
Earth Science
Economic
Education
Engineering
Finance
History & Theory
Humanities
Human Resource
International Business
Investments & Securities
Journalism
Law
Management
Marketing
Medicine
Medicine & Health Science
Nursing
Philosophy
Physic
Psychology
Real Estate
Science
Social Science
Sociology
Special Education
Speech
Visual Arts
Mathematic
Q:
During recovery testing, the analysts try to break the system.
Q:
During beta testing, users test a completed information system using real data in the real user environment.
Q:
During alpha testing, users test a completed information system using simulated data.
Q:
The people who create the test cases should be the same people who have coded and will test the system.
Q:
A test case is a specific scenario of transactions, queries, or navigation paths that represent a typical, critical, or abnormal use of the system.
Q:
System testing is the process of bringing together all of the modules that a program comprises for testing purposes.
Q:
Unit testing is a technique used in examining individual lines of code, where a few lines of code are used to substitute for subordinate modules.
Q:
Integration testing brings together all of the programs that a system comprises for testing purposes.
Q:
A systems analyst or programmer typically does syntax checking.
Q:
Desk checking is a testing technique in which the program code is sequentially executed manually by the reviewer.
Q:
The purpose of a walkthrough is to identify and correct errors found in programming code.
Q:
Walkthroughs are a very effective method for identifying errors in code.
Q:
Unit testing does not require automated code execution.
Q:
During an inspection test, exactly what the code does is investigated.
Q:
Testing specialists are responsible for developing test plans, establishing testing standards, integrating testing and development activities in the life cycle, and ensuring that test plans are completed.
Q:
During systems design, an overall test plan is developed.
Q:
The systems implementation and operation phase of the SDLC is analogous to the maintenance process of implementing changes.
Q:
The systems design phase of the SDLC is analogous to the maintenance process of designing changes.
Q:
The systems analysis phase of the SDLC is analogous to the maintenance process of obtaining maintenance requests.
Q:
The systems planning and selection phase of the SDLC is analogous to the maintenance process of transforming requests into a specific system change.
Q:
Transforming requests into changes is a major maintenance activity.
Q:
Information systems personnel and end users are the two audiences for the final systems documentation.
Q:
The systems administration plan answers such questions as when and where the new system will be installed, what people and resources are required, which data will be converted and cleansed, and how long the installation process will take.
Q:
Analysis is one of the seven major activities associated with systems implementation and operation.
Q:
The implementation and operation phase of the systems development life cycle is the most expensive and time-consuming phase of the entire life cycle.
Q:
Briefly identify the three file organizations.
Q:
Discuss the rules for normalization.
Q:
Identify the five properties of a relation.
Q:
Outline the four key steps in logical database modeling and design.
Q:
A foreign key in a relation that references the primary key values of that same relation is referred to as a:
A) secondary key.
B) recursive foreign key.
C) composite key.
D) complex key.
E) concatenated key.
Q:
Given a FACULTY relation that includes both faculty and faculty sponsors attributes from the same data, this would be considered a:
A) binary relationship.
B) transitive relationship.
C) recursive relationship.
D) dependent relationship.
E) singular relationship.
Q:
For a binary many-to-many relationship existing between entity types A and B:
A) a separate relation C is created; the primary key of relation C is a composite key consisting of the primary key for each of the two entities in the relationship.
B) the primary keys of relation A and relation B become foreign keys in a new relation C.
C) secondary keys are used to establish the relationship.
D) place the primary key of either entity in the relation for the other entity or do this for both entities.
E) Entity A and B are merged into one.
Q:
Another name for a unary relationship is a:
A) recursive relationship
B) composite relationship
C) recovering relationship.
D) partial relationship
E) transitive relationship
Q:
For a binary one-to-one relationship between two entities A and B, the relationship is represented by:
A) adding the primary key of A as a foreign key of B.
B) adding the primary key of C as a foreign key of D.
C) combining the two entities into one relation.
D) creating a third relation to represent the relationship between the two entities.
E) deleting the primary keys.
Q:
A binary one-to-many relationship in an E-R diagram is best represented by:
A) the creation of a separate relation; the primary key of this new relation is a composite key consisting of the primary key for each of the two entities in the relationship.
B) adding the primary key attribute (or attributes) of the entity on the one side of the relationship as a foreign key in the relation that is on the many side of the relationship.
C) adding the primary key attribute (or attributes) of the entity on the many side of the relationship as a foreign key in the relation that is on the one side of the relationship.
D) creating a relation with a composite primary key and nonkey attributes.
E) none of the above.
Q:
An entity whose primary key depends on the primary key of another entity is called a:
A) referential entity.
B) candidate entity.
C) transitive entity.
D) dependent entity.
E) weak entity.
Q:
Which of the following properties should be satisfied when the identifier of the entity type becomes the primary key of the corresponding relation?
A) The value of the key must uniquely identify every row in the relation.
B) The key should serve as a foreign key in at least two other relations.
C) The key must be a composite of a primary key and a secondary key.
D) The key should be an intelligent key.
E) The key should allow for null values.
Q:
When transforming an E-R diagram into normalized relations, the identifier of the entity type becomes:
A) the primary key of the corresponding relation.
B) the foreign key in the corresponding relation.
C) a nonkey attribute in the corresponding relation.
D) a secondary key in the corresponding relation.
E) a homonym in the corresponding relation.
Q:
Each regular entity type in an E-R diagram is transformed into a:
A) row in a relation.
B) column in a relation.
C) relation.
D) tuple in a relation.
E) database.
Q:
Given the relation EMPLOYEE(ID#, LastName, ProjectID, ProjectName) and ProjectID can determine ProjectName, but not last name, the relation violates:
A) 1st normal form.
B) Mills normal form.
C) 2nd normal form.
D) 3rd normal form.
E) Olsen normal form.
Q:
Which is the primary key(s) in the following STUDENT_GRADE(StudentID, CourseID, Grade)?
A) STUDENT_GRADE
B) StudentID
C) CourseID
D) StudentID, CourseID
E) Grade
Q:
The integrity constraint that specifies that the value (or existence) of an attribute in one relation depends on the value (or existence) of the same attribute in another relation is called:
A) foreign integrity.
B) attribute integrity.
C) referential integrity.
D) dependence integrity.
E) join integrity.
Q:
If OrderNumber serves as the primary key in the ORDER relation and also appears as a nonkey attribute in the INVOICE relation, then OrderNumber is said to be a:
A) foreign key.
B) candidate key.
C) pointer.
D) relationship key.
E) marker.
Q:
An attribute that appears as a nonkey attribute in one relation and as a primary key attribute (or part of a primary key) in another relation is a:
A) foreign key.
B) candidate key.
C) pointer.
D) relationship key.
E) marker.
Q:
The dependence of nonprimary key attributes on other nonprimary key attributes best describes a:
A) relationship dependency.
B) transitive dependency.
C) weak attribute.
D) weak entity.
E) weak relationship.
Q:
The relation state specifying that nonprimary key attributes do not depend on other nonprimary key attributes is:
A) first normal form.
B) second normal form.
C) Boyce-Codd normal form.
D) third normal form.
E) fifth normal form.
Q:
For any relation R, if, for every valid instance of A, that value of A uniquely determines the value of B:
A) then a primary dependency exists in the relation.
B) then A is said to be functionally dependent on B.
C) then B is said to be functionally dependent on A.
D) then A and B are candidate keys for the relation.
E) None of the above are true.
Q:
A particular relationship between two attributes best defines:
A) context.
B) functional dependency.
C) normal form.
D) structure.
E) join.
Q:
When each nonprimary key attribute is identified by the whole key, the relation is said to be in at least:
A) second normal form.
B) third normal form.
C) fourth normal form.
D) fifth normal form.
E) a relational form.
Q:
The process of converting complex data structures into simple, stable data structures is referred to as:
A) normalization.
B) simplification.
C) structuring.
D) process modeling.
E) relational conversion.
Q:
A relation that contains a minimum amount of redundancy and allows users to insert, modify, and delete the rows in a table without errors or inconsistencies is a(n):
A) independent relation.
B) simple relation.
C) unnormalized relation.
D) well-structured relation.
E) derived relation.
Q:
Which of the following properties of a relation states that an entry at the intersection of each row and column is single-valued?
A) Entries in cells are simple.
B) Entries in columns are from the same set of values.
C) Each row is unique.
D) The sequence of rows is insignificant.
E) The sequence of columns can be interchanged.
Q:
Assume the structure of a relation is Employee (EmpID, Name, Dept, Salary). The number of attributes for this relation would:
A) be three.
B) be four.
C) be five.
D) be six.
E) vary depending upon the number of employees.
Q:
Which of the following is NOT a true statement regarding a relation?
A) Each relation consists of a set of named columns and an arbitrary number of unnamed rows.
B) Each column in a relation corresponds to an attribute of that relation.
C) An entry at the intersection of each row and column has a single value.
D) The columns may not be interchanged or stored any sequence.
E) The rows may be interchanged or stored in any sequence.
Q:
A named two-dimensional table of data is a(n):
A) network.
B) tree structure.
C) relation.
D) tuple.
E) object.
Q:
A data model that represents data in the form of tables or relations is called a(n):
A) hierarchical database model.
B) network database model.
C) relational database model.
D) hybrid database model.
E) object-oriented database model.
Q:
The primary deliverable from logical database design is:
A) normalized relations.
B) design specifications.
C) an updated Baseline Project Plan.
D) a list of alternatives design strategies.
E) a production system.
Q:
Using the normalized relation notation, an attribute of a relation which is the primary key of another relation is indicated by:
A) an underline.
B) a circle.
C) a dashed underline.
D) italics.
E) a double-lined ellipse.
Q:
Key physical database design decisions typically do not include:
A) choosing the storage format for each attribute from the logical database model.
B) grouping attributes from the logical database model into physical records.
C) arranging related records in secondary memory so that individual and groups of records can be stored, retrieved, and updated rapidly.
D) selecting media and structures for storing data to make access more efficient.
E) conducting requirements structuring.
Q:
During physical design, you typically don't consider:
A) the definitions of each attribute.
B) the descriptions of where and when data are entered, retrieved, deleted, and updated.
C) the expectations for response time and data integrity.
D) the descriptions of the file and database technologies to be used.
E) creating a new set of E-R models.
Q:
Combining all normalized user views into one consolidated logical database model refers to:
A) normalization.
B) requirements structuring.
C) file integration.
D) view integration.
E) logic modeling.
Q:
Which of the following is NOT a key step in logical database design?
A) Combine normalized data requirements from all user interfaces into one consolidated logical database model.
B) Compare the consolidated logical database design with the translated E-R model and produce, through view integration, one final logical database design for the application.
C) Model how data flow through an information system, the relationships among the data flows, and how data come to be stored at specific locations.
D) Translate the conceptual E-R data model for the application into normalized data requirements.
E) Using normalization principles, develop a logical data model for each known user view for the application.
Q:
During logical database design, the work of all systems development team members is coordinated and shared through:
A) the project dictionary.
B) scheduled weekly meetings.
C) the project leader.
D) JAD sessions.
E) walkthroughs.
Q:
The most common style for a logical database model is the:
A) relational database model.
B) hierarchical database model.
C) network database model.
D) object-oriented database model.
E) hybrid database model.
Q:
Which of the following is NOT associated with logical and physical database design?
A) Structure the data in stable structures that are not likely to change over time and that have minimal redundancy.
B) The preparation of a final conceptual model and the implementation of the database.
C) Develop a logical database design from which we can do physical database design.
D) Develop a logical database design that reflects the actual data requirements that exist in the forms and reports of an information system.
E) Translate a relational database model into a technical file and database design.
Q:
Which of the following is a purpose of logical model and physical database design?
A) Structure the data in unstable structures that are likely to change over time and that have extensive redundancy.
B) Develop a logical database to help identify a steering committee.
C) Develop a logical database design from which we can do physical database design.
D) Translate a relational database model into network database models.
E) Develop a marketing plan for both logical and physical database design.
Q:
Designing the database for an Internet-based electronic commerce application differs significantly from the process followed when designing the database for other types of applications.
Q:
Data security can be built into a file through encryption, passwords, or prohibiting users from directly manipulating a file.
Q:
File restoration can be achieved through backup copies of a file, audit trails, and row image files.
Q:
Multiple key retrieval is possible with sequential file organization.
Q:
A primary key is converted in a hashed file organization.
Q:
Sequential retrieval on the primary key is impractical with the hashed file organization.
Q:
The hashed file organization determines the address for each row by using an algorithm.
Q:
Indexes should be used generously for databases that support transaction processing and other applications with heavy updating requirements.
Q:
Indexes should be used generously for databases intended primarily to support data retrievals.
Q:
Sequential files are practical for random row retrievals.
Q:
When using the sequential file organization, the addition of rows requires rewriting the file.
Q:
A data marker is a field of data that can be used to locate a related field or row of data.
Q:
Denormalization is the process of splitting or combining normalized relations into physical tables based on EFFICIENCY of use of rows and fields.
Q:
Denormalization reduces the chance of errors introduced by normalizing relations.