SQL Server Quiz

What is the advantage of using DATEDIFF(YEAR, HireDate, GETDATE()) as a computed column in the Employees table?

• To prevent future updates to the HireDate field

• To automatically calculate years of service without manual updates

• To store redundant date values for performance improvement

• To enforce referential integrity across related tables

Which of the following approaches would most accurately preserve deleted employee records for audit purposes?

• Use a DELETE statement and remove records from the table

• Move records to a dedicated archive table before deletion

• Update the Salary field to zero to mark deletion

• Disable all constraints and leave the record untouched

What is the primary reason for using HAVING AVG(Salary) > 40000 after a GROUP BY clause?

• To filter individual rows based on salary conditions

• To filter grouped records based on their aggregated average

• To calculate the total salary of all employees

• To increase the performance of the GROUP BY operation

In SQL Server, what is the main risk of directly deleting employees with Salary < 30000?

• It will increase the number of employees in higher salary ranges

• It may unintentionally remove employees with valid ongoing records

• It automatically duplicates higher-paid employees

• It restricts future salary increases in the database

Why is CONCAT(FirstName, ' ', LEFT(MiddleName, 1), '. ', LastName) a better formatting choice than using simple string addition (+) in SQL Server?

• It allows for CASE statements to modify values mid-string

• It reduces NULL handling issues and ensures clean formatting

• It increases the storage size of the result set

• It forces all results into a single uppercase string

In the Shoe Ordering System, what is a key reason to prefer DECIMAL(10, 2) for the Price column over FLOAT?

• It performs faster on all mathematical operations

• It ensures fixed precision without rounding errors

• It restricts the storage of negative values

• It limits the number of transactions processed per second

According to the correct rule for DECIMAL(p, s), what is the maximum number of digits before the decimal point for DECIMAL(8, 3)?

• 3

• 5

• 8

• 6

Which of the following ensures accurate tracking of price changes over time for each shoe item?

• Overwriting the price column in the main Shoes table

• Inserting old and new prices into a ShoePriceHistory table

• Removing the old price before adding a new price

• Duplicating the entire Shoes table after each price change

Why is it considered poor practice to store both FirstName and FullName separately in the same table?

• It simplifies aggregate queries on personal names

• It violates normalization by creating redundant data

• It reduces JOIN operation performance

• It increases the size of the primary key unnecessarily

In SQL Server, what operation is performed by DATEADD(YEAR, -1, GETDATE())?

• It adds one year to the current date

• It subtracts one year from the current date

• It removes the time component from the date

• It finds the number of months since the date of hire