Management has requested that you build an employee database. You need to include each employee's current position and salary, as well as all prior positions and salaries with the company. You decide to use a one-to-many structure: an employee table with the main information such as name and address, and an employment table with position and salary history. You can use the employeeID field to connect them. What is employment.employeeID an example of?

In recent versions of MySQL (8.0+), what's the correct syntax to declare a CTE (Common Table Expression)?

What is one reason to introduce data redundancy into a normalized database design?

You are loading data into a table. Which command can you use to make sure that all data is inserted and duplicates rows are discarded?

Which statement about the TRUNCATE TABLE statement is true?

In data migration, there is often a need to delete duplicate rows as part of data cleanup. Which statement works best?

What locks can be applied to MyISAM tables?

Which clauses can be used in a SELECT statement to reduce the results to a unique list of values?

What is A in ACID?

Which statement is correct?

With SQL, how can you return the number of records in the 'Persons' table?