P Pre Langsql Cssfilehk1stylecreate Table Employeeempid Numeric #344

</p> <pre><code class="language-sql">Create table Employee(Emp_id numeric not null, Name varchar(20) , dept_name varchar(20), Salary numeric, unique(Emp_id,Name)); insert into Employee values(1002, Ross, CSE, 10000); insert into Employee values(1006,Ted,Finance, ); insert into Employee values(1002,Rita,Sales,20000);</code></pre> <p>What will be the result of the query?

This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 SQL: Queries, Constraints and Triggers - Integrity Constraints - Quiz No.1.

Create table Employee(Emp_id numeric not null, Name varchar(20) , dept_name varchar(20), Salary numeric, unique(Emp_id,Name)); insert into Employee values(1002, Ross, CSE, 10000); insert into Employee values(1006,Ted,Finance, ); insert into Employee values(1002,Rita,Sales,20000);