Design

Q: Assuming the JobID is the primary key in JobClient table, which of the following normal forms is violated with respect to Name field.a) 1NFb) 2NFc) 3NFd) BCNF

Q: Assuming the JobID-ClientID is a primary key in JobClient table, which of the following normal forms is violated with respect to DateTimeStart field? a) 1NF b) 2NF c) 3NF d) BCNF

Q: Having multiple phone numbers in a Phone field violates which of the following normal forms? a) 1NF b) 2NF c) 3NF d) BCNF

Q: In tables with concatenated keys, which of the following normal form violation has a potential for occurring? a) 2NF b) BCNF c) 4NF d) All of the above

Q: Boyce-Codd Normal Form (BCNF) states which of the following? a) A part of the primary key may not determine a non-key field. b) A non-key field may not determine another non-key field. c) A part of a non-key field may not determine the primary key field. d) The primary key may not determine a non-key field.

Q: Having a part of CustomerID primary key come from customer's email address, violates which of the following normal forms? a) 1NF b) 2NF c) 3NF d) BCNF

Q: In the JobClient table, the presence of ClientID violates which of the following normal forms? a) 1NF b) 2NF c) 3NF d) 4NF

Q: Which of the following fields in JobClient table violates 3NF? a) JobID b) ClientID c) Name d) Phone

Q: Which of the following is the reason(s) ClientID field in the JobClient table violates 3NF? a) ClientID determines Name field. b) ClientID determines Phone field. c) ClientID determines both Name and Phone field. d) ClientID does not violate 3NF.

Q: After correcting 2NF error for JobClient table, which of the following would be true of the new table? a) ClientID would be the primary key and JobID the foreign key. b) ClientID would be the primary key and Phone the foreign key. c) JobID would be the primary key and ClientID the foreign key. d) JobID would be the primary key and Phone the foreign key.

Q: Correcting 2NF violation in JobClient table would involve which of the following? a) Just deleting one of the inconsistent records b) Creating Job table with a record for each job date/time c) Creating a Phone table with a record for each phone d) Doing nothing at all

Q: After correcting the 2NF violation, the primary keys would act as a) determinants. b) foreign keys. c) non-key fields. d) concatenations.

Q: JobID-ClientID is not a determinant for JobClient table because of which of the following records? a) Records with JobIDs 1 and 2 b) Records with JobIDs 3 and 4 c) Records with JobIDs 6 and 7 d) Records with JobIDs 10 and 11

Q: JobClient table violates 1NF on which of the following fields? a) Name b) Phone c) DateTimeStart d) DateTimeEnd

Q: Which of the following would be true of the new table with phone client's phone numbers? a) ClientID would be the primary key and Phone the foreign key. b) Phone would be the primary key and ClientID the foreign key. c) ClientID and Phone would combine to form a primary key. d) ClientID and Phone would combine to form a foreign key.

Q: Normalized design would do which of the following with the client's work, home, and cell phone numbers? a) Place them in another database on the database server. b) Place them in a separate table in the same database. c) Place them in separate fields in the same table. d) Keep all the phone numbers in a single field.

Q: Removing a record for a particular job in a normalized design would result in which of the following? a) Loss of the job information b) Loss of the client information c) Loss of both job and client information d) Loss of employee information

Q: Deleting the record with JobID 7 in the JobClient table would result in which of the following? a) Loss of the job information b) Loss of the client information c) Loss of the job and client information d) Loss of the employee information

Q: Inserting new client information into the JobClient table is not possible without specifying which of the following? a) JobID b) ClientID c) DateTimeStart d) DateTimeEnd

Q: When updating JobClient table, which of the following would not present a problem due to denormalized design? a) Updating ClientID field b) Updating Name field c) Updating Phone field d) Updating DateTimeStart field

Q: In normalized design of QuickTax database, changing Mountain Coffee's phone number would have to be done how many times exactly?a) Only onceb) Two timesc) As many times as there are old Mountain Coffee phone numbersd) The change would not be possible to make.

Q: Changing Mountain Coffee's phone number in the first record and failing to do the same in the ninth record is an example of which of the following? a) Insert problem b) Update problem c) Delete problem d) Typing problem

Q: Which of the following fields in JobClient table would most likely be split into two fields? a) ClientID b) Name c) Phone d) DateTimeStart

Q: Which of the following statements about foreign key in JobClient table is true? a) JobID is the foreign key. b) ClientID is the foreign key. c) Phone number is the foreign key. d) There is no foreign key.

Q: For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep track of clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers, and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, the company needs to be able to keep track of the data on each job an employee performs for each of their clients. JobClient table design is which of the following?a) Normalizedb) Denormalizedc) Centralizedd) Decentralized

Q: First normal form (4NF) states which of the following?a) All fields must contain single values only.b) Part of the primary key may not determine a non-key field.c) A non-key field may not determine a non-key field.d) In an all-key table, part of the key can determine multiple values of, at most, one other field.

Q: First normal form (3NF) states which of the following? a) All fields must contain single values only. b) Part of the primary key may not determine a non-key field. c) A non-key field may not determine a non-key field. d) In an all-key table, part of the key can determine multiple values of, at most, one other field.

Q: First normal form (2NF) states which of the following? a) All fields must contain single values only. b) Part of the primary key may not determine a non-key field. c) A non-key field may not determine a non-key field. d) In an all-key table, part of the key can determine multiple values of, at most, one other field.

Q: First normal form (1NF) states which of the following? a) All fields must contain single values only. b) Part of the primary key may not determine a non-key field. c) A non-key field may not determine a non-key field. d) In an all-key table, part of the key can determine multiple values of, at most, one other field.

Q: Which of the following is true for duplicate data in the database? a) Errors occur when records are inserted. b) Errors occur when records are updated. c) Errors occur when records are deleted. d) All of the above.

Q: A multivalued determinant is a field or group of fields that determines multiple values of another field.

Q: 4NF applies to any database table.

Q: Boyce-Codd normal form (BCNF) a non-key field cannot determine a part of the primary key.

Q: 3NF violation can never present a problem when updating a record.

Q: 3NF states that none of the non-key fields can determine another non-key field.

Q: 2NF states that each non-key field must be determined by the whole primary key.

Q: 2NF violation can only occur on tables that have primary keys defined using a single field.

Q: In JobClient table, JobID-ClientID is a determinant.

Q: Normalized design would place client's work, home, and cell phone numbers in a separate table together with the ClientID.

Q: More than one phone number in the Phone field of the JobClient table would violate 1NF.

Q: If a field contains more than one single value, the design is in violation of 2NF.

Q: Normal forms allow us to systematically detect duplicate data.

Q: Inserting new client information without an actual job assignment is possible in the normalized design.

Q: Inserting new client information without an actual job assignment is possible in the denormalized design.

Q: Inserting new client information into the JobClient table is possible without an actual job assignment.

Q: Updating DateStartTime field in JobClient table could cause the problem due to denormalized design.

Q: With normalized design, updating records is not a problem.

Q: Updating records could be a problem caused by denormalized design.

Q: Name field in JobClient table could be split into two single value fields.

Q: DateTimeStart field in JobClient table could be split into two single value fields.

Q: For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep track of clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers, and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, the company needs to be able to keep track of the data on each job an employee performs for each of their clients.JobClient TableThe JobClient table shown above is normalized.

Q: First normal form (1NF) states that fields must contain multiple values.

Q: There are six normal forms, with each of the lower normal forms encompassing the higher normal forms.

Q: Denormalized table designs contain duplicate data.

Q: Tables designed to be free of duplicate data are called association tables.

Q: Database normalization is about checking the accuracy of database design.

Q: In an ER diagram, two tables are connected by a __.

Q: More than one instance of an entity warrants a __ table.

Q: Tables are graphically represented as __ in an ER diagram.

Q: In a relational database, entities are represented as __.

Q: Which of the following is the foreign key in job table in a relationship with client table?a) Employee social security numberb) Job unique IDc) Client unique IDd) Client phone number

Q: Field value 5/23/2005 most likely belongs to which of the following? a) Employee birth date b) Job unique ID c) Job date d) Client unique ID

Q: Which of the following is an associative table? a) Client b) Employee c) Job d) QuickTax

Q: Which of the following is the most appropriate candidate for primary key in job table? a) Job unique ID b) Job date c) Job description d) Employee social security number

Q: Most appropriate data type for a client's phone number would be which of the following? a) CHAR(7) b) CHAR(13) c) NUMBER d) DATE

Q: Most appropriate data type for an employee's social security number would be which of the following? a) CHAR(5) b) NUMBER c) CHAR(11) d) DATE

Q: Which of the following is the most appropriate candidate for primary key in client table? a) Client unique ID b) Client phone number c) Client address d) Client email address

Q: Which of the following is the foreign key in job table in a relationship with employee table? a) Employee social security number b) Job unique ID c) Client unique ID d) Employee birth date

Q: The relationship between employees and clients is which of the following? a) One-to-one b) One-to-many c) Many-to-many d) Many-to-one

Q: The relationship between clients and jobs is which of the following? a) One-to-one b) One-to-many c) Many-to-many d) Many-to-one

Q: The relationship between employees and jobs is which of the following? a) One-to-one b) One-to-many c) Many-to-many d) Many-to-one

Q: Which of the following are employees attributes? a) Social security number b) Name c) Birth date d) All of the above

Q: For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep track of clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers, and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, the company needs to be able to keep track of the data on each job an employee performs for each of their clients.For questions 44 - 56, please refer to the preceding paragraph.Which of the following is an entity that belongs to this database?a) Client addressb) Job performedc) Employee named) QuickTax business

Q: Each field in a table takes values from a certain permissible set of values. This set is often referred to asa) data type.b) cardinality.c) foreign key.d) domain.

Q: Social security number is an example of a) char/text data type. b) number data type. c) date/time data type. d) primary key data type.

Q: The size of character (text) data type is measured in a) number of significant digits. b) number of decimal places. c) number of characters. d) number of words.

1 2 3 … 68 Next »

Subjects