ISQS 2340 EXAM 2 REVIEW TTU MITCHELL
QUESTIONS AND ANSWERS – VERIFIED
2025 VERSION || 100% GUARANTEED PASS
<RECENT VERSION>
Database Fundamentals
1. What is the primary purpose of a database?
A) To create spreadsheets
B) To organize and manage data efficiently
C) To replace all business applications
D) To design user interfaces
2. A collection of related tables in a database is called a:
A) Spreadsheet
B) Schema
C) Query
D) Field
3. In a relational database, a row is also known as a:
A) Attribute
B) Record or Tuple
C) Entity
D) Key
4. In a relational database, a column is also known as a(n):
A) Entity
B) Record
C) Attribute or Field
D) Relationship
5. A primary key is used to:
A) Uniquely identify each record in a table
B) Create a link between two computers
, C) Sort the data in alphabetical order
D) Encrypt the data for security
6. A foreign key is an attribute in one table that is a primary key in
another table. Its main purpose is to:
A) Increase database storage space
B) Ensure data redundancy
C) Enforce referential integrity between tables
D) Speed up data entry
7. The language used to communicate with and manipulate databases is:
A) Java
B) SQL
C) C++
D) HTML
SQL (Structured Query Language)
8. Which SQL clause is used to retrieve data from a database?
A) UPDATE
B) SELECT
C) INSERT
D) DELETE
9. Which SQL keyword is used to filter results based on a specified
condition?
A) GROUP BY
B) ORDER BY
C) WHERE
D) FROM
10.To retrieve all columns from a table named 'Customers', you would use:
A) SELECT ALL FROM Customers;
B) SELECT * FROM Customers;
C) SELECT [Customers];
D) GET Customers.*;
, 11.The SQL statement SELECT Name, Price FROM Products WHERE Price
> 20; will return:
A) All columns from the Products table
B) Only the Name and Price columns for products costing more than 20
C) Only the Price column for all products
D) The average price of all products
12.Which SQL keyword is used to sort the result-set?
A) FILTER
B) SORT BY
C) ORDER BY
D) ARRANGE BY
13.To sort results in descending order, you use the keyword:
A) ASC
B) DESC
C) HIGH TO LOW
D) Z-A
14.The INSERT INTO statement is used to:
A) Create a new database
B) Add new records to a table
C) Modify existing records
D) Delete a table
15.The UPDATE statement is used to:
A) Modify existing records in a table
B) Create a new table
C) Change the database structure
D) Delete a column
16.The DELETE statement is used to:
A) Remove a database
B) Delete records from a table
C) Remove a column from a table
D) Clear the entire SQL console
QUESTIONS AND ANSWERS – VERIFIED
2025 VERSION || 100% GUARANTEED PASS
<RECENT VERSION>
Database Fundamentals
1. What is the primary purpose of a database?
A) To create spreadsheets
B) To organize and manage data efficiently
C) To replace all business applications
D) To design user interfaces
2. A collection of related tables in a database is called a:
A) Spreadsheet
B) Schema
C) Query
D) Field
3. In a relational database, a row is also known as a:
A) Attribute
B) Record or Tuple
C) Entity
D) Key
4. In a relational database, a column is also known as a(n):
A) Entity
B) Record
C) Attribute or Field
D) Relationship
5. A primary key is used to:
A) Uniquely identify each record in a table
B) Create a link between two computers
, C) Sort the data in alphabetical order
D) Encrypt the data for security
6. A foreign key is an attribute in one table that is a primary key in
another table. Its main purpose is to:
A) Increase database storage space
B) Ensure data redundancy
C) Enforce referential integrity between tables
D) Speed up data entry
7. The language used to communicate with and manipulate databases is:
A) Java
B) SQL
C) C++
D) HTML
SQL (Structured Query Language)
8. Which SQL clause is used to retrieve data from a database?
A) UPDATE
B) SELECT
C) INSERT
D) DELETE
9. Which SQL keyword is used to filter results based on a specified
condition?
A) GROUP BY
B) ORDER BY
C) WHERE
D) FROM
10.To retrieve all columns from a table named 'Customers', you would use:
A) SELECT ALL FROM Customers;
B) SELECT * FROM Customers;
C) SELECT [Customers];
D) GET Customers.*;
, 11.The SQL statement SELECT Name, Price FROM Products WHERE Price
> 20; will return:
A) All columns from the Products table
B) Only the Name and Price columns for products costing more than 20
C) Only the Price column for all products
D) The average price of all products
12.Which SQL keyword is used to sort the result-set?
A) FILTER
B) SORT BY
C) ORDER BY
D) ARRANGE BY
13.To sort results in descending order, you use the keyword:
A) ASC
B) DESC
C) HIGH TO LOW
D) Z-A
14.The INSERT INTO statement is used to:
A) Create a new database
B) Add new records to a table
C) Modify existing records
D) Delete a table
15.The UPDATE statement is used to:
A) Modify existing records in a table
B) Create a new table
C) Change the database structure
D) Delete a column
16.The DELETE statement is used to:
A) Remove a database
B) Delete records from a table
C) Remove a column from a table
D) Clear the entire SQL console
