BMGT 301 Exam 2 questions correctly
answered 2025/2026 latest update
Is data a source of competitive Advantage - correct answer ✔✔Yes and No
Answers become a commodity with data (cannot differentiate). Real value comes with asking good
questions.
Combining big data and effect analytics gives the company a key competitive advantage
VRIS
When might data not yield sustainable advantage? - correct answer ✔✔Others can get access to data, in
public domain
When data becomes a commodity and unable to differentiate
Define database - correct answer ✔✔A single table or a collection of related tables.
Centralizes data
Controls redundant data
Define a DBMS - correct answer ✔✔software for creating, maintaining, and manipulating data
o Known as database software
o Interfaces between applications and physical data files
o Separates logical and physical views of data
o Solves problems of traditional file environment
Example: SQL
o Structured query language used to create and manipulate databases.
o Non-procedural
o Declarative
bit - correct answer ✔✔either 0 or 1
, Byte - correct answer ✔✔8 bits
Field - correct answer ✔✔Collection of bytes, describes an entity with an attribute
Record - correct answer ✔✔A row in excel, a collection of related fields
File - correct answer ✔✔collection of related records
Database - correct answer ✔✔A collection of related files
What are relational databases? - correct answer ✔✔Represent data as two-dimensional tables called
relations or files
Each table contains data on entity and attributes
Table: grid of columns and rows - correct answer ✔✔-Rows (tuples): Records for different entities
-Fields (columns): Represents attribute for entity
-Key field: Field used to uniquely identify each record
-Primary key: Field in table used for key fields
-Foreign key: Primary key used in second table as look-up field to identify records from original table
DBMS (Database Management System) - correct answer ✔✔Data definition Language
Data Dictionary
Data Manipulation Language
Data Definition Language (DDL) - correct answer ✔✔Specifies structure of database content, used to
create tables and define characteristics of fields
data dictionary - correct answer ✔✔automated or manual file storing definitions of data elements and
their characteristics
answered 2025/2026 latest update
Is data a source of competitive Advantage - correct answer ✔✔Yes and No
Answers become a commodity with data (cannot differentiate). Real value comes with asking good
questions.
Combining big data and effect analytics gives the company a key competitive advantage
VRIS
When might data not yield sustainable advantage? - correct answer ✔✔Others can get access to data, in
public domain
When data becomes a commodity and unable to differentiate
Define database - correct answer ✔✔A single table or a collection of related tables.
Centralizes data
Controls redundant data
Define a DBMS - correct answer ✔✔software for creating, maintaining, and manipulating data
o Known as database software
o Interfaces between applications and physical data files
o Separates logical and physical views of data
o Solves problems of traditional file environment
Example: SQL
o Structured query language used to create and manipulate databases.
o Non-procedural
o Declarative
bit - correct answer ✔✔either 0 or 1
, Byte - correct answer ✔✔8 bits
Field - correct answer ✔✔Collection of bytes, describes an entity with an attribute
Record - correct answer ✔✔A row in excel, a collection of related fields
File - correct answer ✔✔collection of related records
Database - correct answer ✔✔A collection of related files
What are relational databases? - correct answer ✔✔Represent data as two-dimensional tables called
relations or files
Each table contains data on entity and attributes
Table: grid of columns and rows - correct answer ✔✔-Rows (tuples): Records for different entities
-Fields (columns): Represents attribute for entity
-Key field: Field used to uniquely identify each record
-Primary key: Field in table used for key fields
-Foreign key: Primary key used in second table as look-up field to identify records from original table
DBMS (Database Management System) - correct answer ✔✔Data definition Language
Data Dictionary
Data Manipulation Language
Data Definition Language (DDL) - correct answer ✔✔Specifies structure of database content, used to
create tables and define characteristics of fields
data dictionary - correct answer ✔✔automated or manual file storing definitions of data elements and
their characteristics
