Database Final Exam Practice Newest Edition 2025-2026.Questions &
Correct Answers.Graded A, Exams of Database Management Systems
(DBMS)
When building a model in Oracle SQL Data Modeler you begin in the
________ tab.
- Relational
- Physical
- Conceptual
- Logical - ANSWERLogical
In Oracle SQL Data Modeler, the attribute that you assign as primary UID is
automatically set to a mandatory attribute and will be engineered to a
primary key in the relational model.
- True
- False - ANSWERTrue
The steps to convert a Relational model to a Logical model using the Oracle
SQL Developer Data Modeler are:
- Select the Relational model, Accept defaults, Click the Engineer to Logical
Model icon, Click Engineer
- Click the Engineer to Relational Model icon, Select the Logical model, Click
Engineer, Accept defaults.
- Select the Relational model, Click the Engineer to Logical Model icon, Accept
defaults, Click Engineer
,- None of the above. - ANSWERSelect the Relational model, Click the Engineer
to Logical Model icon, Accept defaults, Click Engineer
Top-Down Modeling is the approach taken for designing a new database.
- True
- False - ANSWERTrue
To define naming templates in Oracle SQL Data Modeler:
- Right click the name of the design in object browser.
- Select properties, select template.
- Edit the template to use abbreviations.
- Do all of these steps. - ANSWERDo all of these steps.
Foreign key constraints are named using the ______________ of both tables.
- Full table name
- UID suffix
- Foreign key name
- Short table name - ANSWERShort table name
The glossary can be used as the naming standard for your Logical Model.
- True
- False - ANSWERTrue
, A ___________ model is the blue print to the actual database
implementation and can be used as the basis for implementing any type of
Database Management System (DBMS).
- Database
- Logical
- Relational
- Conceptual - ANSWERRelational
A join between two tables that returns the results of the INNER join as well as
the unmatched rows from the left (or right) table is called a left (or right)
OUTER join.
- True
- False - ANSWERTrue
A(n) _______ clause creates an equijoin between two tables using one
column from each table regardless of the name or data type.
- CROSS JOIN
- NATURAL JOIN
- ON
- USING - ANSWERON
What type of join is the following statement?
SELECT e.EMPLOYEE_ID, e.LAST_NAME, d.DEPARTMENT_ID,
d.DEPARTMENT_NAME, d.LOCATION_ID
FROM EMPLOYEES e, DEPARTMENTS d;
- CROSS JOIN
Correct Answers.Graded A, Exams of Database Management Systems
(DBMS)
When building a model in Oracle SQL Data Modeler you begin in the
________ tab.
- Relational
- Physical
- Conceptual
- Logical - ANSWERLogical
In Oracle SQL Data Modeler, the attribute that you assign as primary UID is
automatically set to a mandatory attribute and will be engineered to a
primary key in the relational model.
- True
- False - ANSWERTrue
The steps to convert a Relational model to a Logical model using the Oracle
SQL Developer Data Modeler are:
- Select the Relational model, Accept defaults, Click the Engineer to Logical
Model icon, Click Engineer
- Click the Engineer to Relational Model icon, Select the Logical model, Click
Engineer, Accept defaults.
- Select the Relational model, Click the Engineer to Logical Model icon, Accept
defaults, Click Engineer
,- None of the above. - ANSWERSelect the Relational model, Click the Engineer
to Logical Model icon, Accept defaults, Click Engineer
Top-Down Modeling is the approach taken for designing a new database.
- True
- False - ANSWERTrue
To define naming templates in Oracle SQL Data Modeler:
- Right click the name of the design in object browser.
- Select properties, select template.
- Edit the template to use abbreviations.
- Do all of these steps. - ANSWERDo all of these steps.
Foreign key constraints are named using the ______________ of both tables.
- Full table name
- UID suffix
- Foreign key name
- Short table name - ANSWERShort table name
The glossary can be used as the naming standard for your Logical Model.
- True
- False - ANSWERTrue
, A ___________ model is the blue print to the actual database
implementation and can be used as the basis for implementing any type of
Database Management System (DBMS).
- Database
- Logical
- Relational
- Conceptual - ANSWERRelational
A join between two tables that returns the results of the INNER join as well as
the unmatched rows from the left (or right) table is called a left (or right)
OUTER join.
- True
- False - ANSWERTrue
A(n) _______ clause creates an equijoin between two tables using one
column from each table regardless of the name or data type.
- CROSS JOIN
- NATURAL JOIN
- ON
- USING - ANSWERON
What type of join is the following statement?
SELECT e.EMPLOYEE_ID, e.LAST_NAME, d.DEPARTMENT_ID,
d.DEPARTMENT_NAME, d.LOCATION_ID
FROM EMPLOYEES e, DEPARTMENTS d;
- CROSS JOIN
