Relational Database Week 07

What is the purpose of using SELECT DISTINCT in SQL?

• To sort data alphabetically

• To delete duplicate rows

• To update data in the database

• To retrieve unique values from a column

What is the purpose of the OFFSET clause in a SQL query?

• To filter out rows of data where the WHERE clause isn't true.

• To declare what row in the record set to start at.

• To group the result set according to values from specified columns.

• To filter aggregated values.

What is the difference between the WHERE and HAVING clauses in SQL?

• WHERE filters rows, while HAVING filters columns.

• WHERE and HAVING are the same and can be used interchangeably.

• WHERE filters rows, while HAVING filters aggregated values.

• HAVING groups the result set, while WHERE filters aggregated values.

Which SQL clause is used to sort the result set?

• GROUP BY

• ORDER BY

• SELECT

• WHERE

What commonly violates the atomicity of first normal form?

• Storing multiple values in a single cell, separated by a delimiter

• Using primary keys in every table

• Avoiding the use of SELECT statements

• Limiting the use of WHERE clauses

When expanding databases past one table, it is helpful to start viewing our databases in which view to visualize the relationship between tables?

• Data view

• Entity Relationship view

• Spreadsheet view

• Normal form view

For planning the design of a database, showing a table in entity relationship view is helpful because it shows how the table will relate to what?

• Other tables in the database

• The data stored in one table

• The column names as rows

• The spreadsheet view

What is NOT shown when looking at a database in entity relationship view?

• Table contents or data

• Table names

• Columns names

• Relationships between tables

What does 'FK' stand for in the context of database tables?

• A full key

• A functional key

• A foreign key

• A foundational key