Design a trigger that works like MaintainCoursesNonEmpty but is a row-level trigger.
What will be an ideal response?
```
CREATE TRIGGER MaintainCoursesNonEmpty2
AFTER DELETE, UPDATE OF CrsCode, Semester ON Transcript
REFERENCING OLD AS O
FOR EACH ROW
WHEN (NOT EXISTS (
SELECT *
FROM Transcript
WHERE Semester = O.Semester AND
CrsCode = O.CrsCode ) )
DELETE FROM Teaching
WHERE Semester = O.Semester AND
CrsCode = O.CrsCode
```
You might also like to view...
According to the Requirements Document for the Student Registration System, one session can include a number of use cases. Later, during the design, we will decompose each use case into one or more transactions. The ACID properties apply to all transactions, but a session that involves more than one transaction might not be isolated or atomic. For example, the transactions of several sessions might be interleaved. Explain why the decision was made not to require sessions to be isolated and atomic. Why is a session not one long transaction?
What will be an ideal response?
In addition to using the options in the Format Cells dialog box, you can apply borders to cells by using the ________ pointer
A) Outline B) Presets C) Fill Border D) Draw Borders
Which Cisco IOS command would be used to configure HSRP on an interface using a group number of 10 and a virtual IP address of 192.168.1.5?
A) hsrp 10 ip 192.168.1.5 B) standby 10 ip 192.168.1.5 C) standby 10 virtual ip 192.168.1.5 D) hsrp 10 virtual ip 192.168.1.5
The ____ metacharacter is used to allow a string to contain an alternate set of substrings.
A. (!) B. (|) C. (\) D. (/)