Database Final Exam With 100% Correct Solution 2024-2025
One-to-One relationships are converted to Check Constraints in the tables at either end
that have been created for that relationship. True or False? - Answer False
The Oracle Database can implement a many-to-many relationship. You simply create
two foreign keys between the two tables. True or False? - Answer False
When you create a physical design from an arc relationship you need to change the arc
relationships to foreign keys. If you are implementing an Exclusive Design you will have
to add two Unique Key Constraints to ensure the Arc is properly implemented. True or
False? - Answer False
When the ER diagram is transformed into the physical design there are changes in
terminology involved. Secondary Unique Identifiers become:
A. Columns
B. Tables
C. Unique Constraints
D. Primary Key Constraints - Unique Constraints
In a physical data model, an attribute becomes a _____________.
A. Table
B. Foreign Key
,C. Constraint
D. Column - Answer Column
In an Oracle database, why would 1_TABLE not work as a table name?
A. The database does not understand all capital letters.
B. There is no problem here. You can create a table called 1_TABLE.
C. Object names cannot begin with a number. They must start with a letter.
D. TABLE is a reserved word. - Answer Object names cannot begin with a number. They
must start with a letter .
below is a column integrity constraint. True or False? A column must contain only values
consistent with the defined data format of the column. - Answer True
Foreign keys must be null. True or False? - Answer False
A table must have a primary key. True or False? - Answer False
The description here is a User Defined integrity rule and, as such must be hand-coded;
the Database cannot automatically enforce this rule. True or False? A primary key must
be unique and no portion of the primary key can be null. - Answer False
Which of the following constraint types is the text below an example of? If a BORROWER
has more than 5 BOOKS lent to him from the LIBRARY, we need to send him a letter
demanding that he returns the BOOKS; this will have to be implemented with additional
programming.
A. Entity integrity
,B. User-defined integrity
C. Column integrity
D. Referential integrity - Answer User-defined integrity
System Documentation is developed right at the end once the system has gone live and
users have been using it for a little while. You are more likely to get it correct that way.
True or False? - Answer False
In the Analysis phase, the tables are created and populated with test data. True or
False? - Answer False
Once you have defined a table, you cannot change its definition. If you want to add a
column that was not defined when you created the table you must destroy the table
definition and create a new, correct table. True or False? - Answer False
The f_customers table has been populated with the following data:
ID NAME ADDRESS CITY STATE ZIP
1 Cole Bee 123 Main Street Orlando FL 32838
2 Zoe Twee 1009 Oliver Avenue Boston MA 02116
3 Sandra Lee 22 Main Street Tampa FL 32444
If you run the following statement: DELETE FROM F_CUSTOMERS WHERE ID <= 2;
How many records are left in the table?
A. 0
, B. 3
C. 1
D. 2 - Answer 1
The DESCRIBE command returns all rows from a table. True or False? - Answer False
The _______ clause can be added to a SELECT statement to return a subset of the data.
A. ANYWHERE
B. WHICH
C. WHERE
D. EVERY - Answer WHERE
Which of the following commands will retrieve data from the database for you?
A. FETCH
B. GET
C. SELECT
D. RETURN - Answer SELECT
One-to-One relationships are converted to Check Constraints in the tables at either end
that have been created for that relationship. True or False? - Answer False
The Oracle Database can implement a many-to-many relationship. You simply create
two foreign keys between the two tables. True or False? - Answer False
When you create a physical design from an arc relationship you need to change the arc
relationships to foreign keys. If you are implementing an Exclusive Design you will have
to add two Unique Key Constraints to ensure the Arc is properly implemented. True or
False? - Answer False
When the ER diagram is transformed into the physical design there are changes in
terminology involved. Secondary Unique Identifiers become:
A. Columns
B. Tables
C. Unique Constraints
D. Primary Key Constraints - Unique Constraints
In a physical data model, an attribute becomes a _____________.
A. Table
B. Foreign Key
,C. Constraint
D. Column - Answer Column
In an Oracle database, why would 1_TABLE not work as a table name?
A. The database does not understand all capital letters.
B. There is no problem here. You can create a table called 1_TABLE.
C. Object names cannot begin with a number. They must start with a letter.
D. TABLE is a reserved word. - Answer Object names cannot begin with a number. They
must start with a letter .
below is a column integrity constraint. True or False? A column must contain only values
consistent with the defined data format of the column. - Answer True
Foreign keys must be null. True or False? - Answer False
A table must have a primary key. True or False? - Answer False
The description here is a User Defined integrity rule and, as such must be hand-coded;
the Database cannot automatically enforce this rule. True or False? A primary key must
be unique and no portion of the primary key can be null. - Answer False
Which of the following constraint types is the text below an example of? If a BORROWER
has more than 5 BOOKS lent to him from the LIBRARY, we need to send him a letter
demanding that he returns the BOOKS; this will have to be implemented with additional
programming.
A. Entity integrity
,B. User-defined integrity
C. Column integrity
D. Referential integrity - Answer User-defined integrity
System Documentation is developed right at the end once the system has gone live and
users have been using it for a little while. You are more likely to get it correct that way.
True or False? - Answer False
In the Analysis phase, the tables are created and populated with test data. True or
False? - Answer False
Once you have defined a table, you cannot change its definition. If you want to add a
column that was not defined when you created the table you must destroy the table
definition and create a new, correct table. True or False? - Answer False
The f_customers table has been populated with the following data:
ID NAME ADDRESS CITY STATE ZIP
1 Cole Bee 123 Main Street Orlando FL 32838
2 Zoe Twee 1009 Oliver Avenue Boston MA 02116
3 Sandra Lee 22 Main Street Tampa FL 32444
If you run the following statement: DELETE FROM F_CUSTOMERS WHERE ID <= 2;
How many records are left in the table?
A. 0
, B. 3
C. 1
D. 2 - Answer 1
The DESCRIBE command returns all rows from a table. True or False? - Answer False
The _______ clause can be added to a SELECT statement to return a subset of the data.
A. ANYWHERE
B. WHICH
C. WHERE
D. EVERY - Answer WHERE
Which of the following commands will retrieve data from the database for you?
A. FETCH
B. GET
C. SELECT
D. RETURN - Answer SELECT
