Question 1: Which of the following T-SQL creates a database?
Question 2: Considering the Employee table below, how will you delete a record whose EmpId is 5?
Question 3: From the Employee table below, how do you get the average salary of each department?
Question 4: Which of the following is a valid T-SQL statement to add a new column to a table?
Question 5: How do you get the total number of employees whose
DeptId is 1 from the
Employee table given below: