MIST 4610 Final Questions with multiple choices
1. What is a primary key in a relational database?
a.a key used to encrypt data
b. a unique identifier for a row in a table
c. a foreign key in another table
d. a column used for indexing data: a unique identifier for a row in a data
2. What does SQl stand for?
a. Simple Query Language
b. Structured Query Language
c. Sequential Query Language
d. Systematic Query Language: Structured Query Language
3. True or False: A table in a relational database can have multiple primary keys: False (can have multiple
components but is still considered a single primary key)
4. What is the purpose of a foreign key in a relational database?
a. To create indexes on a table
b. To reference a primary key in another table
c. To encrypt table data
d. To specify a unique identifier for a table: To reference a primary key in another table
5. In SQL, which keyword is used to remove duplicate rows in the result set?
a. UNIQUE
b. DISTINCT
c. DELETE
d. WHERE: DISTINCT
6. True or False: A relational database uses tables to organize data into rows and columns: True
7. What is a JOIN operation in SQL?
a. A command to add new rows to a table
b. A method to combine rows from two or more tables based on a related column
c. A function to aggregate data in a table
d. A way to remove duplicates in a table: A method to combine rows from two or more tables based on a related colum
8. True or False: In SQL, the GROUP BY clause is used to group rows that have the same values in specified
columns: TRUE
9. What is the purpose of normalization in database design?
a. To create backups of data
b. To reduce data redundancy and improve integrity
, MIST 4610 Final Questions with multiple choices
c. To optimize query performance
d. To encrypt sensitive data: To reduce data redundancy and improve integrity
10.Which SQL statement is used to create a new table?
a. CREATE TABLE
b. ADD TABLE
c. NEW TABLE
d. MAKE TABLE: CREATE TABLE
11.True or False: Tableau is used for data visualization and business intelli- gence: True
12.What is a Tableau worksheet?
a. A single dashboard view
b. A sheet containing visualizations like charts and graphs
c. A set of data filters
d. A data connection interface: A sheet containing visualizations like charts and graphs
13.True or False: In Tableau, a dimension is a categorical variable used to slice data: True
14.What is the purpose of a dashboard in Tableau?
a. to store data
b. to display multiple visualizations together for analysis
c. to connect external data sources
d. to apply filters to data: To display multiple visualizations together for analysis
15.True or False: In Tableau, a measure is typically a numeric variable that can be aggregated: True
16.What is a composite key in a relational database?
a. A key made of multiple columns to uniquely identify a row
b. A key used for encrypting database tables
c. A primary key in multiple tables
d. A foreign key that links two tables: A key made of multiple columns to uniquely identify a row
17.True or False: A foreign key must always reference a primary key in another table: True
18.Which SQL clause is used to filter aggregate functions like SUM or COUNT?
a. WHERE
b. HAVING
c. GROUP BY
d. FILTER: HAVING
1. What is a primary key in a relational database?
a.a key used to encrypt data
b. a unique identifier for a row in a table
c. a foreign key in another table
d. a column used for indexing data: a unique identifier for a row in a data
2. What does SQl stand for?
a. Simple Query Language
b. Structured Query Language
c. Sequential Query Language
d. Systematic Query Language: Structured Query Language
3. True or False: A table in a relational database can have multiple primary keys: False (can have multiple
components but is still considered a single primary key)
4. What is the purpose of a foreign key in a relational database?
a. To create indexes on a table
b. To reference a primary key in another table
c. To encrypt table data
d. To specify a unique identifier for a table: To reference a primary key in another table
5. In SQL, which keyword is used to remove duplicate rows in the result set?
a. UNIQUE
b. DISTINCT
c. DELETE
d. WHERE: DISTINCT
6. True or False: A relational database uses tables to organize data into rows and columns: True
7. What is a JOIN operation in SQL?
a. A command to add new rows to a table
b. A method to combine rows from two or more tables based on a related column
c. A function to aggregate data in a table
d. A way to remove duplicates in a table: A method to combine rows from two or more tables based on a related colum
8. True or False: In SQL, the GROUP BY clause is used to group rows that have the same values in specified
columns: TRUE
9. What is the purpose of normalization in database design?
a. To create backups of data
b. To reduce data redundancy and improve integrity
, MIST 4610 Final Questions with multiple choices
c. To optimize query performance
d. To encrypt sensitive data: To reduce data redundancy and improve integrity
10.Which SQL statement is used to create a new table?
a. CREATE TABLE
b. ADD TABLE
c. NEW TABLE
d. MAKE TABLE: CREATE TABLE
11.True or False: Tableau is used for data visualization and business intelli- gence: True
12.What is a Tableau worksheet?
a. A single dashboard view
b. A sheet containing visualizations like charts and graphs
c. A set of data filters
d. A data connection interface: A sheet containing visualizations like charts and graphs
13.True or False: In Tableau, a dimension is a categorical variable used to slice data: True
14.What is the purpose of a dashboard in Tableau?
a. to store data
b. to display multiple visualizations together for analysis
c. to connect external data sources
d. to apply filters to data: To display multiple visualizations together for analysis
15.True or False: In Tableau, a measure is typically a numeric variable that can be aggregated: True
16.What is a composite key in a relational database?
a. A key made of multiple columns to uniquely identify a row
b. A key used for encrypting database tables
c. A primary key in multiple tables
d. A foreign key that links two tables: A key made of multiple columns to uniquely identify a row
17.True or False: A foreign key must always reference a primary key in another table: True
18.Which SQL clause is used to filter aggregate functions like SUM or COUNT?
a. WHERE
b. HAVING
c. GROUP BY
d. FILTER: HAVING
