CIS 336 All Assignments CIS 336 All Assignments | Page 15

4NF.
BCNF.
8. (TCO 4) In Oracle, the DEFAULT constraint is used to ____________________. (Points : 4)
define which column is the default primary key if one is not explicitly named
define which column is the default foreign key if on 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
Page 2 - Multiple Choice
1. (TCO 4) Which of the following is not considered a database object? (Points : 4)
a table
a view
a constraint
a sequence
an index
2. (TCO 4) Which of the following SQL statements would you use to create a table named
DEVRY? (Points : 4)
CREATE Devry
(
Student_id NUMBER (12),
Student_name VARCHAR2 (15),
Student_city VARCHAR2 (12)
);
CREATE TABLE Devry
(