DATABASE FINAL EXAM PRACTICE
2025/2026 QUESTIONS AND ANSWERS
100% PASS
When building a model in Oracle SQL Data Modeler you begin in the ________ tab.
- Relational
- Physical
- Conceptual
- Logical - ANS Logical
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 - ANS True
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.
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED
,- Select the Relational model, Click the Engineer to Logical Model icon, Accept defaults, Click
Engineer
- None of the above. - ANS Select 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 - ANS True
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. - ANS Do 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 - ANS Short table name
The glossary can be used as the naming standard for your Logical Model.
- True
- False - ANS True
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
2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED
, - Logical
- Relational
- Conceptual - ANS Relational
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 - ANS True
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 - ANS ON
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
- NATURAL JOIN
- INNER JOIN
- OUTER JOIN - ANS CROSS JOIN
Will the following statement execute successfully?
SELECT employee_id, city, department_name
FROM employees e JOIN departments d
3 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED
2025/2026 QUESTIONS AND ANSWERS
100% PASS
When building a model in Oracle SQL Data Modeler you begin in the ________ tab.
- Relational
- Physical
- Conceptual
- Logical - ANS Logical
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 - ANS True
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.
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED
,- Select the Relational model, Click the Engineer to Logical Model icon, Accept defaults, Click
Engineer
- None of the above. - ANS Select 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 - ANS True
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. - ANS Do 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 - ANS Short table name
The glossary can be used as the naming standard for your Logical Model.
- True
- False - ANS True
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
2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED
, - Logical
- Relational
- Conceptual - ANS Relational
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 - ANS True
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 - ANS ON
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
- NATURAL JOIN
- INNER JOIN
- OUTER JOIN - ANS CROSS JOIN
Will the following statement execute successfully?
SELECT employee_id, city, department_name
FROM employees e JOIN departments d
3 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED
