(Solved):   If Enrollments tabel is empty when INSERT instruction is executed,what will SELECT instructi ...

 

If Enrollments tabel is empty when INSERT instruction is executed,what will SELECT instruction return?

a) nothing

b)(104,'Baze de date I','2021-11-01',1)

c) INSERT instruction will generate an exception and won't insert anything so SELECT will return nothing

d)(104,'Baze de date I','2021-11-01',NULL)

CREATE TABLE Enrollments Studid int NOT NULL, CourseTitle nvarchar(50) NOT NULL, EnrollmentDate date NULL, Accepted bit NULL ); GO CREATE VIEW Accepted(ID, Curs, EDate) AS SELECT StudID, CourseTitle, EnrollmentDate FROM Enrollments WHERE CourseTitle='Baze de date I' AND Accepted=1; GO INSERT IGNORE INTO Accepted (ID, Curs, EDate) VALUES