Consider the following SQL statements that manipulate an employee table:
Insert a new employee named Arthur Anderson with the following information...
Consider the following SQL statements that manipulate an employee table: Insert a new employee named Arthur Anderson with the following information: ID 37, position Gerente, salary 5345.57, phone number (11)93435-4332, and no dismissal date. Insert a new employee named Moisés Santos Silva with the following information: ID 18, position Vendedor, salary 2325.38, phone number (11)97343-2432, and no dismissal date. Insert a new employee named Roberta Soares with the following information: ID 48, position Vendedor, salary 2325.38, no phone number, and no dismissal date. Insert a new employee named Alice Silva with the following information: ID 101, position Vendedor, salary 1935.34, no phone number, and no dismissal date. Select all employees. Select all active employees. Select all employees ordered by salary, breaking ties by name. Select all employees whose name contains 'Silva'. Select all employees whose salary is greater than R$ 2,000.00. Select all employees whose position is Gerente or Almoxarife.
a) The SQL statements are incorrect. b) The SQL statements are correct and will execute without errors. c) The SQL statements are correct, but there is a syntax error in one of them. d) The SQL statements are correct, but there is a logical error in one of them.
Compartilhar