Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Choose the command to enable unique constraint sal_uni on salary column in Employees table. Employee Table: Eid EName Salary Join Date 1000 Q1 E11 Khalid
Choose the command to enable unique constraint sal_uni on salary column in Employees table. Employee Table: Eid EName Salary Join Date 1000 Q1 E11 Khalid E12 Asma E13 Ali E14 Zahra 500 600 10-10-2019 20-05-2018 25-06-2019 15-02-2019 1000 O a. ALTER TABLE EMPLOYEES ENABLE CONSTRAINT UNIQUE (salary); O b. ALTER TABLE EMPLOYEES ENABLE sal_uni: O C. ALTER TABLE EMPLOYEES ENABLE CONSTRAINT sal_uni; O d. ALTER TABLE EMPLOYEES DISABLE CONSTRAINT sal_uni: A table in which foreign key is defined is called Q2 O a. Master table O b. Detail table O c. Primary table O d. Default table Select the correct command to add Not Null constraint to column salary. Employee Table: Eid EName Salary Join Date Q3 1000 soo E11 E12 E 13 E14 Khalid Asma Ali Zahra 10-10-2019 20-05-2018 25-06-2019 15-02-2019 600 1000 a. Alter table Employee modify (salary constraint NN_sal NOT NULL): b. Alter table Employee modify (salary constraint NOT NULL): c. Alter table Employee add (salary constraint NN_sal NOT NULL O d. Alter table Employee acid constraint NN_sal NOT NULL(salary)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started