Question 1. 1. (TCO 3) Normalization works through a series of stages called nor

Question

Question 1.1. (TCO 3) Normalization works through a series of stages called normal forms. Typically, _____ stages must be completed before a table can be considered normalized. (Points : 3)        one
       two
       three
       four
       five Question 2.2. (TCO 3) The conflicts between design efficiency, information requirements, and processing speed are often resolved through _____ (Points : 3)        conversion from 1NF to 2NF.
       conversion from 2NF to 3NF.
       compromises that include denormalization.
       conversion from 3NF to 4NF. Question 3.3. (TCO 3) What is the principle purpose of the primary key? (Points : 3)        Primary keys uniquely identify a row of data within a database table.
       Keys used in first normal form are known as primary keys. Second normal form keys are known as secondary keys, and 3NF keys are called tertiary keys.
       Primary keys uniquely identify a column of data within a database table.
       The primary key secures the table by locking it against unauthorized access. Question 4.4. (TCO 9) All of following are examples of DML commands except _____ (Points : 3)        INSERT.
       SELECT.
       DROP. Question 5.5. (TCO 4) Which of the following is not considered a database object? (Points : 3)        A table
       A view
       A constraint
       A sequence
       An index Question 6.6. (TCO 4) In Oracle, the CONSTRAINT is used to _____ (Points : 3)        create only referential integrity.
       to impose business rules or otherwise constrain the use of a table.
       create a short cut.
       create only entity integrity. Question 7.7. (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;
       SHOW * FROM devry; Question 8.8. (TCO 9) Which of the following SQL statements will insert a new row into the table? (Points : 3)        INSERT INTO promotion (gift, minretail, maxretail)
VALUES (FREE BOOK, 75.01, 89.99);
       INSERT INTO promotion (gift, minretail, maxretail)
VALUES ('FREE BOOK', 75.01, 89.99);
       INSERT INTO promotion VALUES (FREE BOOK, 75.01, 89.99);
       INSERT INTO promotion (gift, minretail)
VALUES (FREE BOOK, 75.01, 89.99); Question 1.1. (TCO 3) Normalization works through a series of stages called normal forms. Typically, _____ stages must be completed before a table can be considered normalized. (Points : 3)        one
       two
       three
       four
       five

Explanation / Answer

Q1.

ans. two

Q2.

ans.conversion from 3NF to 4NF

Q3.

ans.Primary keys uniquely identify a column of data within a database table

Q4.

ans. INSERT

Q5.

ans.A sequence

Q6.

ans.create only entity integrity

Q7.

ans.SELECT * FROM devry;

Q8.

ans.INSERT INTO promotion (gift, minretail, maxretail)
VALUES ('FREE BOOK', 75.01, 89.99);

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.