Create table EMP with columns emp_num, ename, sal and enter 10 records. Add columns dname, dept_num, location for emp table.

Question image

Understand the Problem

The question is asking to create a database table named EMP with specific columns and to insert records into it as well as to add new columns later, which relates to SQL operations.

Answer

Create 'EMP' table, insert records, add columns, update records.

To accomplish the task, first create the table with given columns and types, insert 10 records, add the new columns, then update those records with additional data.

Answer for screen readers

To accomplish the task, first create the table with given columns and types, insert 10 records, add the new columns, then update those records with additional data.

More Information

This exercise demonstrates basic SQL database manipulation tasks such as table creation, data insertion, and schema modification using 'ALTER TABLE'.

Tips

Ensure data types match when inserting and updating records. Verify column additions and updates for accuracy.

Sources

Thank you for voting!
Use Quizgecko on...
Browser
Browser