Exam1Practice - MGIS 3330

What is the primary function of tables in a well-designed Access database?

To hold all the data about a particular subject/entity

A single instance of a table, containing data on all aspects related to that specific instance, is called a _______

Record

Which of the following statements is TRUE about a Primary Key in an Access table?

It uniquely identifies each record.

What is the main role of a Foreign Key in an Access table?

To maintain relationships between tables.

What is the maximum number of characters a field name in Access can consist of?

64 characters

Which of the following is NOT a data type for fields in Access tables?

Picture

Which of the following is true for defining Big Data?

Diverse, high-volume, high-velocity information assets that require new forms of processing.

Which of the following is explicitly stated as a component of Data Management?

Data Governance

Data generated within an organization from systems like sales, finance, HR, and inventory is categorized as what type of data source?

Internal Data Sources

What is Data Governance primarily defined as?

The framework of policies, processes, roles, and standards that ensures data is accurate, consistent, secure, and used responsibly.

What are the "Four Vs" commonly associated with Big Data?

Volume, Velocity, Variety, Veracity

Which type of data source is captured from users' online activity, showing what pages they visit and actions they take on a website?

Clickstream Data

What term describes when data is scattered across different departments, systems, and sources within an organization, hindering a holistic view and effective collaboration?

Data silos

What is the primary purpose of data management?

To ensure data is accurate, accessible, secure, and aligned with organizational goals.

What is the smallest unit of data a computer can process in the data hierarchy?

Bit

Which of the following is NOT listed as a challenge in data management?

Inexpensive Infrastructure

Which term refers to a situation where multiple versions of the same data do not match with each other?

Data inconsistency

Refers to the maintenance and assurance that the data in a database is correct and consistent

Data integrity

Which of the following is NOT a key problem of a traditional file system?

Scalability

Which of the following is a key advantage of the database approach over traditional file systems?

It allows data to be centralized, logically organized, and shared across multiple applications

How does a Database Management System (DBMS) primarily minimize data redundancy?

By centralizing data storage, preventing the same data from being stored in multiple places.

When a DBMS enforces rules, such as restricting entries in a Social Security Number (SSN) field to numeric values, it is maximizing which of the following?

Data integrity

Which layer of data abstraction describes how data is actually stored in the database, covering details of file organization, indexes, and storage blocks?

Physical Layer

Which layer of data abstraction is the highest level, providing different customized views of the same data and hiding much of the complexity of the logical and physical levels?

External Layer

Defines the logical structure of a database and how the data is stored, organized, and manipulated.

Data Model

What database model is characterized by records (nodes) connected to other records through links (pointers), forming a graph-like structure, and supports many-to-many relationships?

Network Model

What is the primary purpose of the Database Development Life Cycle (DDLC)?

To ensure the database meets user needs, supports applications, and can adapt over time.

Which stage of the Database Development Life Cycle (DDLC) involves defining the goals and scope of the database and collecting requirements from users and stakeholders?

Planning & Requirements

During the Operation & Maintenance stage, who typically monitors, backs up, and maintains the database?

Database Administrators (DBAS)

What is Data Modeling essentially creating for an information system?

A visual representation of an information system to illustrate data, its types, relationships, and data organization.

Which of the following is NOT a key goal of data modeling?

To directly build the physical database without prior planning.

In data modeling, which component represents the "real-world objects or concepts" about which you want to store data?

Entities

What are "attributes" in data modeling?

The properties or characteristics of an entity

Which stage of the data modeling process is described as a high-level, business-oriented view of the data, focusing on "What data" needs to be stored, without worrying about technology?

Conceptual Design Model

What does the physical design stage provide for a database?

The specific database implementation details for a chosen Database Management System (e.g., Access)

Which characteristic of relationships refers to the number of entity types involved in a relationship (e.g., Unary, Binary, Ternary)?

Degree

What is an expression in Microsoft Access?

A combination of values, operators, functions, and identifiers that Access evaluates to produce a single result

In Access, what is the primary purpose of a Form?

To provide a user-friendly interface for viewing, entering, and editing data

In Access, which view is considered the "end-user" mode, used for data entry without changing the form's design?

Form View

In Access, if you need to make quick formatting changes to a form while seeing live data, which view should you use?

Layout View

Refers to the symbols that perform calculations or comparisons.

Operators

Refers to any element you place on a form to display, enter, or manipulate data.

Field

Which one of the following controls can be used to show a drop-down list of values?

Sub-Form

An unbounded control refers to

A control that does not have a data source

Which of the following properties of a LIST BOX can be used to provide data to the list box?

Raw Source Type

Which of the following is NOT a raw source type option?

Source List