BCIS 3610 EXAM 2 ADVANCED PREP
MATERIAL QUESTIONS WITH ACCURATE
SOLUTIONS
●● Which of the following defines data?
a) Data is organized and processed information used for decision making
b) Data is a collection of facts, such as numbers, letters, and images
c) Data is a set of organized records stored in a database
d) Data is knowledge that has been processed and is useful for decision
making.
Answer: b) Data is a collection of facts, such as numbers, letters, and
images
●● What does information refer to in the context of data management?
a) A random set of data elements
b) A collection of data that is organized and has value beyond the raw
facts
c) Data stored in a database without any specific use
d) Knowledge gained through intuition and understanding.
Answer: b) A collection of data that is organized and has value beyond
the raw facts
●● Which of the following best describes an attribute in a database?
, a) A unique identifier for a record
b) A characteristic of an entity for which data is collected and stored
c) A collection of entities in a database
d) A set of related records that make up a file.
Answer: b) A characteristic of an entity for which data is collected and
stored
●● What is the function of a primary key in a relational database?
a) It connects two tables to create relationships between them
b) It stores data in a foreign table
c) It uniquely identifies each record in a table
d) It defines the format and type of data in a column.
Answer: c) It uniquely identifies each record in a table
●● What is data normalization in the context of a relational database?
a) Combining multiple records into one
b) Eliminating data redundancy by organizing data into tables
c) Creating foreign key relationships between tables
d) Encrypting data to ensure privacy and security.
Answer: b) Eliminating data redundancy by organizing data into tables
●● What does Data-as-a-Service (DaaS) offer as an advantage?
MATERIAL QUESTIONS WITH ACCURATE
SOLUTIONS
●● Which of the following defines data?
a) Data is organized and processed information used for decision making
b) Data is a collection of facts, such as numbers, letters, and images
c) Data is a set of organized records stored in a database
d) Data is knowledge that has been processed and is useful for decision
making.
Answer: b) Data is a collection of facts, such as numbers, letters, and
images
●● What does information refer to in the context of data management?
a) A random set of data elements
b) A collection of data that is organized and has value beyond the raw
facts
c) Data stored in a database without any specific use
d) Knowledge gained through intuition and understanding.
Answer: b) A collection of data that is organized and has value beyond
the raw facts
●● Which of the following best describes an attribute in a database?
, a) A unique identifier for a record
b) A characteristic of an entity for which data is collected and stored
c) A collection of entities in a database
d) A set of related records that make up a file.
Answer: b) A characteristic of an entity for which data is collected and
stored
●● What is the function of a primary key in a relational database?
a) It connects two tables to create relationships between them
b) It stores data in a foreign table
c) It uniquely identifies each record in a table
d) It defines the format and type of data in a column.
Answer: c) It uniquely identifies each record in a table
●● What is data normalization in the context of a relational database?
a) Combining multiple records into one
b) Eliminating data redundancy by organizing data into tables
c) Creating foreign key relationships between tables
d) Encrypting data to ensure privacy and security.
Answer: b) Eliminating data redundancy by organizing data into tables
●● What does Data-as-a-Service (DaaS) offer as an advantage?
