Final exam with pix - Copy

Final exam with pix - Copy - TCO 1 The American National...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
TCO 1 - The American National Standards Institute (ANSI) Standards Planning  and Requirements Committee defines _____ different data models. (Points: 3) two three four five 2. TCO 1 - A Batch Update Routine pools the transactions into a single "batch" to  update a master table field in a(n) _____________________ operation. (Points: 3) single user modern automatic 3. TCO 1 - The Data Base Management System makes data management more  ____________. (Points: 3) efficient rigid universal fascinating 4. TCO 1 - The DBMS allows you to extrapolate information from your data by  using a (Points: 3) query language table generator security system access control 5. TCO 2 - Each entity set has certain characteristics known as  ______________________ that help to describe that entity set. (Points: 3) attributes variables tables
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
rules 6. TCO 2 - Which of the following types of columns will automatically right-align  the data when it is displayed? (Points: 3) character date alphanumeric numeric 7. TCO 2 - In a relational database, each table must have (Points: 3) a primary key a secondary key a foreign key a logical key 8. TCO 2 - In a relationship, when a primary key from one table is also defined in  a second table, the field is referred to as a ____________ in the second table.  (Points: 3) combined key redundant field primary key foreign key 9. TCO 2 - The most widely used conceptual model is the ______________.  (Points: 3) E-R model Chen model External model Attribute model 10. TCO 3 - A ____ occurs when a relationship is improperly or incompletely  identified and, therefore, is represented in a way that is not consistent with the  real world. (Points: 3) surrogate primary keys
Background image of page 2
time-variant data design trap fan trap 11. TCO 3 - Composite primary keys are particularly useful as identifiers of  composite entities, where each primary key combination is allowed only once in  the ____ relationship. (Points: 3) null 1:1 1:M M:N 12. TCO 3 - A table that has all key attributes defined, has no repeating groups.  and all its attributes are dependent on the primary key, is said to be in (Points: 3) 1NF. 2NF. 3NF. 4NF. BCNF. 13. TCO 3 - When designing a database, you should ____. (Points: 3) make sure entities are in normal form before table structures are created create table structures then normalize the database only normalize the database when performance problems occur consider more important issues such as performance before  normalizing 1. TCO 4 - Which of the following SQL statements would select data from all of  the rows and columns in the DEVRY table? (Points: 3) SELECT all FROM devry; SELECT * FROM devry; SELECT devry;
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 06/24/2011.

Page1 / 17

Final exam with pix - Copy - TCO 1 The American National...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online