Answered step by step
Verified Expert Solution
Question
1 Approved Answer
During creation of Exam_results table, you can add a constraint that validates the Mark to be valid: a. Create table Exam_results (Mark number(5,2) check (Mark
During creation of Exam_results table, you can add a constraint that validates the Mark to be valid:
a.
Create table Exam_results (Mark number(5,2) check (Mark between 0 and 100));
b.
Create table Exam_results (Mark number(5,2) check (Mark <= 0 or Mark >= 100));
c.
Create Exam_results (Mark number(5,2) check Mark>= 0 and Mark <= 100);
d.
Create table Exam_results (Mark number(5,2) check (Mark=> 0 and Mark =<100));
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