Database Final Exam Practice Newest Edition

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