Best Grades | Must Pass | Latest Update | Correct Answers | 2024/ 2025
DatabaseFinal Questions and Correct
Answers | Latest Update
One-to-One relationships are transformed into Check Constraints in the tables created at
either end of that relationship. True or False?
False
The Oracle Database can implement a many-to-many relationship. You simply create two
foreign keys between the two tables. True or False?
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?
False
The transformation from an ER diagram to a physical design involves changing terminology.
Secondary Unique Identifiers become:
A. Columns
B. Tables
~ 1 ~ for inquiry mail me @
, Best Grades | Must Pass | Latest Update | Correct Answers | 2024/ 2025
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
Column
In an Oracle database, why would 1_TABLE not work as a table name?
A. The database does not understand all capital letters.
~ 1 ~ for inquiry mail me @
, Best Grades | Must Pass | Latest Update | Correct Answers | 2024/ 2025
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.
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.
True
Foreign keys must be null. True or False?
False
A table must have a primary key. True or False?
False
~ 1 ~ for inquiry mail me @
, Best Grades | Must Pass | Latest Update | Correct Answers | 2024/ 2025
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.
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
D. Referential integrity
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?
~ 1 ~ for inquiry mail me @
DatabaseFinal Questions and Correct
Answers | Latest Update
One-to-One relationships are transformed into Check Constraints in the tables created at
either end of that relationship. True or False?
False
The Oracle Database can implement a many-to-many relationship. You simply create two
foreign keys between the two tables. True or False?
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?
False
The transformation from an ER diagram to a physical design involves changing terminology.
Secondary Unique Identifiers become:
A. Columns
B. Tables
~ 1 ~ for inquiry mail me @
, Best Grades | Must Pass | Latest Update | Correct Answers | 2024/ 2025
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
Column
In an Oracle database, why would 1_TABLE not work as a table name?
A. The database does not understand all capital letters.
~ 1 ~ for inquiry mail me @
, Best Grades | Must Pass | Latest Update | Correct Answers | 2024/ 2025
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.
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.
True
Foreign keys must be null. True or False?
False
A table must have a primary key. True or False?
False
~ 1 ~ for inquiry mail me @
, Best Grades | Must Pass | Latest Update | Correct Answers | 2024/ 2025
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.
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
D. Referential integrity
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?
~ 1 ~ for inquiry mail me @
