Blog

Based on the SQL shown, which query lists the last names and bonuses of employees who have a Bonus field value greater than Juliana Suarez, EmployeeID 14? Employees ( EmployeeID, LastName, FirstName, HireDate, JobTitle, Bonus )

Based on the table description and SQL shown, which query lists the states in the Students table and displays the number of students from each state? Students (StudentID, FirstName, LastName, Street, City, State, PostalCode)

Which of the following expressions in Access Query Design View creates a computed field named MonthlySalary using a value from the Salary field?

Which of the following is a reason to store business data in a database rather than a spreadsheet?

In the Pitt Fitness database, which attribute uniquely identifies each class?

In Access SQL, which operator could you use to list all fields from a Customers table where the City field is Madison, Middleton, or Belleville?

During which phase does a database developer create the entities, attributes, and relationships between the tables of data?

A ____________________ in a record is the result of a calculation using data from the rest of the record .

Based on the table description and SQL shown, which query lists the states in the Students table and displays the number of students from each state? Students (StudentID, FirstName, LastName, Street, City, State, PostalCode)

Which of the following expressions in Access Query Design View creates a computed field named MonthlySalary using a value from the Salary field?