Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 4 Not yet answered To add a foreign key constraint to table registration that is references to table students. which of the following statements

image text in transcribedimage text in transcribedimage text in transcribed

Question 4 Not yet answered To add a foreign key constraint to table "registration" that is references to table "students". which of the following statements is correct? Marked out of 1.00 P Flag question a. Alter table registration add(constraint st_cons foreign key(student_id) references students(id)); O b. Alter table students add(constraint st_cons foreign key(student_id) references students(id)); c. Alter table registration add(constraint st_cons references students(id)); O d. Alter table registration add(constraint st_cons foreign key (id) references students(id)); Question 5 To change NULL values of the column "Mark" in the table "Exam_results" to 0, write the query: Not yet answered Marked out of 1.00 P Flag question a. update Exam_results set Mark = NULL where Mark =0; O b. alter table Exam_results set Mark = 0 O c. update Exam_results set Mark = 0 where Mark is NULL: O d. A or C. Question 6 Which statement will erase all records in Registration table? Not yet answered Marked out of 1.00 a. Drop table Registration O b. Delete from Registration O c. Delete * from Registration O d. B and C. P Flag

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

Modern Database Management

Authors: Jeffrey A. Hoffer Fred R. McFadden

9th Edition

B01JXPZ7AK, 9780805360479

More Books

Students also viewed these Databases questions

Question

What are the challenges associated with tunneling in urban areas?

Answered: 1 week ago

Question

What are the main differences between rigid and flexible pavements?

Answered: 1 week ago

Question

What is the purpose of a retaining wall, and how is it designed?

Answered: 1 week ago

Question

How do you determine the load-bearing capacity of a soil?

Answered: 1 week ago

Question

what is Edward Lemieux effect / Anomeric effect ?

Answered: 1 week ago