6. Databases and Networking

Sql Fundamentals — Quiz

Test your understanding of sql fundamentals with 5 practice questions.

Practice Questions

Question 1

Which normal form requires that a table have no repeating groups and that all non-key attributes are functionally dependent on the primary key?

Question 2

Consider two tables, \texttt{Employees} (\texttt{EmployeeID}, \texttt{Name}) and \texttt{Departments} (\texttt{DepartmentID}, \texttt{DepartmentName}). Which SQL query would return all employees and their corresponding department names, including employees who are not assigned to any department?

Question 3

Which of the following is a key characteristic of a relational database model?

Question 4

What is the primary purpose of indexing in a database?

Question 5

Which of the following SQL commands is used to ensure that changes made during a transaction are permanently saved to the database?