Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

PostgreSQL 10 High Performance Expert Techniques For Query Optimization High Availability And Efficient Database Maintenance

Authors: Ibrar Ahmed ,Gregory Smith ,Enrico Pirozzi

3rd Edition

1788474481, 978-1788474481

More Books

Students also viewed these Databases questions