Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 1 The constraint primary key means that the values must be: Not yet answered Marked out of 1.00 a. not null O b. unique

image text in transcribedimage text in transcribedimage text in transcribed

Question 1 The constraint primary key means that the values must be: Not yet answered Marked out of 1.00 a. not null O b. unique O c. not null and unique O d. null Flag question Question 2 Based on the data inserted to university database, which of the following is a valid update statement: Not yet answered Marked out of 1.00 a. Update majors set major_id=128 where major_name like 'c%'; O b. Update majors set faculty="Engineering' where major_name like '%engineering%'; c. Update majors set major_name=law where major_id=124; O d. Update majors set major_name='law' and faculty='law where major_name like '%'; Flag question Question 3 During creation of Exam_results table, you can add a constraint that validates the Mark to be valid: Not yet answered Marked out of 1.00 a. Create table Exam_results (Mark number(5,2) check (Mark between 0 and 100)); O b. Create table Exam_results (Mark number(5.2) check (Mark = 100)); O c. Create Exam_results (Mark number(5,2) check Mark>= 0 and Mark 0 and Mark =

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_2

Step: 3

blur-text-image_step3

Ace Your Homework with AI

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

Get Started

Students also viewed these Databases questions