Blog

A query includes the DeptID and DeptName fields from the Departments table and the EmployeeLast field from the Employees table. Both tables are shown below. What happens when you update the DeptName field value for an employee? Departments (DeptID, DeptName) Employees (EmpID, EmployeeFirst, EmployeeLast, DeptID)

Because you cannot directly create a many-to-many relationship between two tables, what must you create to link the tables together?

A table is in second normal form when it is in first normal form and _____.

Git and GitHub operate on what type of distributed database model?

A _____ is a single logical database that is physically divided among computers at several sites on a network.

_____ are actions that are performed on resources or files at the server.

According to the Bureau of Labor Statistics, what is the job growth outlook for database administrators?

If you use ____________________ criteria, each criterion must be true for a record to be selected .

A _____ is a question about the data structured in a way that the DBMS can recognize and process.

In Access, what uniquely identifies a row in a table?