Multiple choice

Create table employee salary (empid int, fname varchar (30), lname varchar (30), dept varchar (30), salary varchar (10), constraint chk_employee salary check (dept=’Accounts’ AND salary>=5000)). It allows to insert values if

  1. employee’s salary is greater than 4999

  2. employee’s department is accounts

  3. employee’s department is accounts and employee’s salary is greater than 5000

  4. employee’s department is accounts and employee’s salary is greater than 4999

  5. total salary of employee is zero
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

This option is correct because the employee’s department is accounts and employee’s salary is greater than 4999.

Keep practicing — related questions