Consider the following employee table. Write SQL commands for the question. EMP CODE NAME DESIG PAY ALLO WANCE S1001 Hariharan Supervisor 29000 12000 P1002 Shaji Operator 10000 5500 P1003 Prasad Operator 12000 6500 C1004 Manjima Clerk 8000 4500 M1005 Ratheesh Mechanic 20000 7000 To add a new row.

Consider the following employee table. Write SQL commands for the question. To add a new row.

Consider the following employee table. Write SQL commands for the question.

To add a new row.

One Line Answer

INSERT INTO Employee VALUES(/C1006,/ ‘Ram’, ‘Clerk’,15000, 6500);

shaalaa.com

SQL Commands and Their Functions

Is there an error in this question or solution?

Chapter 12: Structured Query Language (SQL) - Evaluation [Page 231]

Chapter 12 Structured Query Language (SQL)
Evaluation | Q 2. (iv) | Page 231

The command to delete a table is ______

Write a query that selects all students whose age is less than 18 in order wise.

Differentiate Unique and Primary Key constraint.

Write the difference between table constraint and column constraint?

What is a constraint?

Write any three DDL commands.

Write the use of the Savepoint command with an example.

Write a SQL statement using the DISTINCT keyword.

Consider the following employee table. Write SQL commands for the question.

To display the details of all employees who are operators.

Write a SQL statement to create a table for employees having any five fields and create a table constraint for the employee table.