1. (TCO 3) The term first normal form (1NF) describes the tabular format in whic

Question

1. (TCO 3) The term first normal form (1NF) describes the tabular format in which all of the following are true except ______________ (Points : 2)
all the key attributes are defined.
there are no repeating groups in the table.
all attributes are dependent on the primary key.
no attributes are dependent on the primary key.


2. (TCO 3) A table that is in 1NF and includes no partial dependencies only is said to be in _________ (Points : 2)
1NF.
2NF.
3NF.
4NF.
BCNF.


3. (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 : 2)
null
1:1
1:M
M:N


4. (TCO 9) All of following are examples of DML commands except _________. (Points : 2)
INSERT
SELECT
DROP


5. (TCO 4) Which command is used to restore the table's contents to their default values? (Points : 2)
COMMIT; RESTORE;
COMMIT; BACKUP;
COMMIT; ROLLBACK;
ROLLBACK;


6. (TCO 4) In Oracle, the DEFAULT constraint is used to ____________________. (Points : 2)
define which column is the default primary key if one is not explicitly named
define which column is the default foreign key if one is not explicitly named
assign a value to an attribute when a new row is added and a value is not defined
validate data when a value is added to an attribute


7. (TCO 4) Which of the following SQL statements would remove the DEVRY table from the schema it had been created in? (Points : 2)
DROP devry;
DELETE TABLE devry;
DELETE devry;
DROP TABLE devry;


8. (TCO 9) Which of the following SQL statements would insert a line of data into the DEVRY table and supply a NULL value for the Student_city column? (Points : 2)
INSERT into DEVRY VALUES
(012393, 'Jimmey Jones', 'NULL');
INSERT into DEVRY VALUES
(012393, 'Jimmey Jones', " ");
INSERT into DEVRY VALUES
(012393, 'Jimmey Jones', NULL);
INSERT into DEVRY VALUES
(012393, 'Jimmey Jones', ' ');


9. (TCO 3) Explain the term "second normal form". (Points : 14)

Explanation / Answer

1.      no attributes are dependent on the primary key.

2.      2NF

3.      M:N

4.      DROP

5.      ROLLBACK

6.      assign a value to an attribute when a new row is added and a value is not defined

7.      DROP TABLE devry;

8.      INSERT into DEVRY VALUES (012393, 'Jimmey Jones', NULL);

9.      The term second normal form defines a relation that is in first normal form and includes no partial dependencies. That means all of the attributes of an entity depend on the primary key.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

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