©BRAINBARTER 2024/2025
Database Final Exam Questions With 100%
Verified Answers
One-to-One relationships are transformed into Check Constraints in the tables created at either
end of 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 translating an arc relationship to a physical design, you must turn the arc relationships into
foreign keys. Assuming you are implementing an Exclusive Design, you must also create two
Unique Key Constraints to ensure the Arc is implemented correctly. True or False? -
answer✔False
The transformation from an ER diagram to a physical design involves changing terminology.
Secondary Unique Identifiers become:
A. Columns
B. Tables
C. Unique Constraints
D. Primary Key Constraints - answer✔Unique Constraints
In a physical data model, an attribute becomes a _____________.
A. Table
B. Foreign Key
C. Constraint
, ©BRAINBARTER 2024/2025
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 must not start with a number. They must begin with a letter.
D. TABLE is a reserved word. - answer✔Object names must not start with a number. They must
begin with a letter.
The explanation 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 explanation below is a User Defined integrity rule and must, therefore, be manually coded;
the Database cannot enforce this rule automatically. True or False? A primary key must be
unique, and no part of the primary key can be null. - answer✔False
The text below is an example of what constraint type? If the number of BOOKS lent to a
BORROWER in the LIBRARY exceeds 5, then we must send him a letter requesting the return
of the BOOKS; this will require extra programming to enforce.
A. Entity integrity
B. User-defined integrity
C. Column integrity
, ©BRAINBARTER 2024/2025
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 created a table, it is not possible to alter the definition of it. If you need to add a
new column you must delete the table definition and create a new, correct table. True or False? -
answer✔False
The f_customers table contains 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 rows will be 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
, ©BRAINBARTER 2024/2025
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
What command will return data from the database to you?
A. FETCH
B. GET
C. SELECT
D. RETURN - answer✔SELECT
When you use the SELECT clause to list one or two columns only from a table and no WHERE
clause, which SQL capability is used?
A. Joining only
B. Selection only
C. Projection only
Database Final Exam Questions With 100%
Verified Answers
One-to-One relationships are transformed into Check Constraints in the tables created at either
end of 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 translating an arc relationship to a physical design, you must turn the arc relationships into
foreign keys. Assuming you are implementing an Exclusive Design, you must also create two
Unique Key Constraints to ensure the Arc is implemented correctly. True or False? -
answer✔False
The transformation from an ER diagram to a physical design involves changing terminology.
Secondary Unique Identifiers become:
A. Columns
B. Tables
C. Unique Constraints
D. Primary Key Constraints - answer✔Unique Constraints
In a physical data model, an attribute becomes a _____________.
A. Table
B. Foreign Key
C. Constraint
, ©BRAINBARTER 2024/2025
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 must not start with a number. They must begin with a letter.
D. TABLE is a reserved word. - answer✔Object names must not start with a number. They must
begin with a letter.
The explanation 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 explanation below is a User Defined integrity rule and must, therefore, be manually coded;
the Database cannot enforce this rule automatically. True or False? A primary key must be
unique, and no part of the primary key can be null. - answer✔False
The text below is an example of what constraint type? If the number of BOOKS lent to a
BORROWER in the LIBRARY exceeds 5, then we must send him a letter requesting the return
of the BOOKS; this will require extra programming to enforce.
A. Entity integrity
B. User-defined integrity
C. Column integrity
, ©BRAINBARTER 2024/2025
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 created a table, it is not possible to alter the definition of it. If you need to add a
new column you must delete the table definition and create a new, correct table. True or False? -
answer✔False
The f_customers table contains 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 rows will be 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
, ©BRAINBARTER 2024/2025
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
What command will return data from the database to you?
A. FETCH
B. GET
C. SELECT
D. RETURN - answer✔SELECT
When you use the SELECT clause to list one or two columns only from a table and no WHERE
clause, which SQL capability is used?
A. Joining only
B. Selection only
C. Projection only
