ISTM 210 EXAM 2 Curtsinger TAMU QUESTIONS AND
ANSWERS WITH COMPLETE SOLUTIONS 100% VERIFIED
Question 1
Which of the following is a collection of related data organized in a way that
makes it easy to store, manage, and retrieve?
A) Spreadsheet
B) Word document
C) Database
D) Presentation file
E) Operating system
Correct Answer: C) Database
Rationale: A database is an organized collection of structured
information, or data, typically stored electronically in a computer
system, designed for efficient storage and retrieval.
Question 2
In a relational database, a "record" is also commonly referred to as a:
A) Field
B) Table
C) File
D) Row
E) Column
Correct Answer: D) Row
Rationale: In a relational database, a row (or tuple) represents a
single, complete record of information about an entity.
Question 3
A "field" in a database table represents:
A) A complete record about an entity.
B) A single category of information.
C) The entire collection of data.
D) A relationship between tables.
E) A query result.
,Correct Answer: B) A single category of information.
Rationale: A field (or attribute) represents a single, specific category
of information within a record, such as "CustomerName" or
"ProductID."
Question 4
Which of the following uniquely identifies each record in a database table?
A) Foreign Key
B) Secondary Key
C) Composite Key
D) Primary Key
E) Candidate Key
Correct Answer: D) Primary Key
Rationale: A primary key is a field (or combination of fields) that
uniquely identifies each record in a table, ensuring no two records
are identical.
Question 5
A "foreign key" in a database table serves what purpose?
A) To uniquely identify each record in its own table.
B) To link two tables together by referencing the primary key of another
table.
C) To store encrypted data.
D) To define the data type of a field.
E) To sort records in alphabetical order.
Correct Answer: B) To link two tables together by referencing the
primary key of another table.
Rationale: A foreign key is a field in one table that refers to the
primary key in another table, establishing a link or relationship
between them.
Question 6
Which type of database relationship exists when one record in Table A can
,relate to many records in Table B, but one record in Table B can only relate to
one record in Table A?
A) One-to-one
B) Many-to-many
C) One-to-many
D) Many-to-one
E) Self-referencing
Correct Answer: C) One-to-many
Rationale: A one-to-many relationship means one record in the "one"
table can be associated with multiple records in the "many" table,
but each record in the "many" table is associated with only one
record in the "one" table.
Question 7
A "Database Management System (DBMS)" is primarily used for:
A) Creating spreadsheet documents.
B) Managing hardware components.
C) Creating, maintaining, and providing controlled access to user data.
D) Designing web pages.
E) Writing programming code.
Correct Answer: C) Creating, maintaining, and providing controlled
access to user data.
Rationale: A DBMS is software used to create, manage, and retrieve
data from databases, ensuring data integrity, security, and efficient
access.
Question 8
Which language is specifically designed for managing and querying data in
relational databases?
A) HTML
B) Python
C) Java
, D) SQL
E) XML
Correct Answer: D) SQL
Rationale: SQL (Structured Query Language) is the standard language
for relational database management systems, used for tasks such
as querying data, inserting records, updating records, and deleting
records.
Question 9
The SQL keyword used to retrieve data from a database is:
A) INSERT
B) UPDATE
C) DELETE
D) SELECT
E) CREATE
Correct Answer: D) SELECT
Rationale: The SELECT statement is used to query the database and
retrieve specific rows or columns of data.
Question 10
Which SQL keyword is used to filter records based on a specified condition?
A) FROM
B) JOIN
C) ORDER BY
D) WHERE
E) GROUP BY
Correct Answer: D) WHERE
Rationale: The WHERE clause is used to extract only those records
that fulfill a specified criterion or condition.
Question 11
A "data warehouse" is best described as:
A) A collection of raw, unorganized data.
ANSWERS WITH COMPLETE SOLUTIONS 100% VERIFIED
Question 1
Which of the following is a collection of related data organized in a way that
makes it easy to store, manage, and retrieve?
A) Spreadsheet
B) Word document
C) Database
D) Presentation file
E) Operating system
Correct Answer: C) Database
Rationale: A database is an organized collection of structured
information, or data, typically stored electronically in a computer
system, designed for efficient storage and retrieval.
Question 2
In a relational database, a "record" is also commonly referred to as a:
A) Field
B) Table
C) File
D) Row
E) Column
Correct Answer: D) Row
Rationale: In a relational database, a row (or tuple) represents a
single, complete record of information about an entity.
Question 3
A "field" in a database table represents:
A) A complete record about an entity.
B) A single category of information.
C) The entire collection of data.
D) A relationship between tables.
E) A query result.
,Correct Answer: B) A single category of information.
Rationale: A field (or attribute) represents a single, specific category
of information within a record, such as "CustomerName" or
"ProductID."
Question 4
Which of the following uniquely identifies each record in a database table?
A) Foreign Key
B) Secondary Key
C) Composite Key
D) Primary Key
E) Candidate Key
Correct Answer: D) Primary Key
Rationale: A primary key is a field (or combination of fields) that
uniquely identifies each record in a table, ensuring no two records
are identical.
Question 5
A "foreign key" in a database table serves what purpose?
A) To uniquely identify each record in its own table.
B) To link two tables together by referencing the primary key of another
table.
C) To store encrypted data.
D) To define the data type of a field.
E) To sort records in alphabetical order.
Correct Answer: B) To link two tables together by referencing the
primary key of another table.
Rationale: A foreign key is a field in one table that refers to the
primary key in another table, establishing a link or relationship
between them.
Question 6
Which type of database relationship exists when one record in Table A can
,relate to many records in Table B, but one record in Table B can only relate to
one record in Table A?
A) One-to-one
B) Many-to-many
C) One-to-many
D) Many-to-one
E) Self-referencing
Correct Answer: C) One-to-many
Rationale: A one-to-many relationship means one record in the "one"
table can be associated with multiple records in the "many" table,
but each record in the "many" table is associated with only one
record in the "one" table.
Question 7
A "Database Management System (DBMS)" is primarily used for:
A) Creating spreadsheet documents.
B) Managing hardware components.
C) Creating, maintaining, and providing controlled access to user data.
D) Designing web pages.
E) Writing programming code.
Correct Answer: C) Creating, maintaining, and providing controlled
access to user data.
Rationale: A DBMS is software used to create, manage, and retrieve
data from databases, ensuring data integrity, security, and efficient
access.
Question 8
Which language is specifically designed for managing and querying data in
relational databases?
A) HTML
B) Python
C) Java
, D) SQL
E) XML
Correct Answer: D) SQL
Rationale: SQL (Structured Query Language) is the standard language
for relational database management systems, used for tasks such
as querying data, inserting records, updating records, and deleting
records.
Question 9
The SQL keyword used to retrieve data from a database is:
A) INSERT
B) UPDATE
C) DELETE
D) SELECT
E) CREATE
Correct Answer: D) SELECT
Rationale: The SELECT statement is used to query the database and
retrieve specific rows or columns of data.
Question 10
Which SQL keyword is used to filter records based on a specified condition?
A) FROM
B) JOIN
C) ORDER BY
D) WHERE
E) GROUP BY
Correct Answer: D) WHERE
Rationale: The WHERE clause is used to extract only those records
that fulfill a specified criterion or condition.
Question 11
A "data warehouse" is best described as:
A) A collection of raw, unorganized data.
