Ujian Tengah Semester Ganjil 2023/2024

DBMS stands for :

• Database Memory System

• Database Management Software

• Database Management System

• Database Manipulation System

Information is the result of combining, comparing and performing calculations on data.

• True

• False

A DBMS comprises of the following elements: (Choose 3)

• Client

• Data Dictionary

• Memory and Storage Management

• Query language

A database interacts with the data and provides the following facilities:

• Retrieving data

• Inserting data

• Deleting data

• All of the above.

The main subject areas taught by the Oracle Academy are:

• Systems programming and computer architecture

• Computer Repairs

• Database performance tuning

• Data Modeling, SQL, and PL/SQL

The technical software requirements for this course include all of the following except:

• Oracle SQL Developer Data Modeler

• Microsoft Access

• Oracle APEX application

• All are requirements.

All Business Rules can be modeled.

• True

• False

Documenting Business Requirements helps developers control the scope of the system and prevents users from claiming that the new system does not meet their business requirements. True or False?

• True

• False

Business rules are important because_________.

• They allow the developer to understand the relationship and constraints of the participating entities

• They can become outdated quickly.

• They can all be incorporated into the database design structure.

• They are complex and difficult to understand.

If information requirements are clearly communicated during conceptual modeling the following will result:

• Some business rules may not be taken into account

• A conceptual model that does not fully reflect the business will be created.

• A well designed conceptual model

• Delays due to reworking model caused by incorrect assumptions