Database Management in Construction Pretest

What is the primary purpose of a Database Management System (DBMS) in construction?

• To create architectural designs

• To manage and store project data efficiently

• To control heavy machinery

• To calculate material tensile strength

Relational databases are widely used in construction due to their ability to:

• Store unstructured text documents only

• Link various pieces of data through common fields

• Process audio files

• Perform complex fluid dynamics simulations

In a relational database, what is a 'table' often referred to as?

• A cell

• A record

• An entity or relation

• A form

What does a 'primary key' uniquely identify within a database table?

• A column

• A row (record)

• Another table

• A database user

A 'foreign key' in a database is used to:

• Encrypt data for security

• Link to a primary key in another table

• Define data types

• Speed up data entry

Which of these software types is a classic example of a DBMS used in construction?

• Adobe Photoshop

• Microsoft Excel (as a simple flat file, not a true DBMS)

• Oracle Database

• AutoCAD

What is the main benefit of centralizing construction project data in a database?

• Increases data redundancy

• Improves data accessibility and consistency

• Makes data harder to back up

• Eliminates the need for data security

Which database concept helps maintain the accuracy and consistency of data over its entire life cycle?

• Data replication

• Data redundancy

• Data integrity

• Data warehousing

BIM (Building Information Modeling) platforms often integrate with databases to manage:

• Only 2D drawings

• Geometric and non-geometric project information

• Social media interactions

• Weather patterns

What does the acronym SQL stand for?

• Simple Query Language

• Structured Question Logic

• Standard Query Link

• Structured Query Language