Bissoy.com
Doctors Medicines MCQs Q&A

The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER INSERT trigger.

The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER INSERT trigger. Correct Answer On, for insert

The triggers run after an insert, update or delete on a table. They are not supported for views.

Related Questions

Which of the following statements are TRUE about an SQL query? P: An SQL query can contain a HAVING clause even if it does not have a GROUP BY clause Q: An SQL query can contain a HAVING clause only if it has a GROUP BY clause R: All attributes used in the GROUP BY clause must appear in the SELECT clause S: Not all attributes used in the GROUP BY clause need to appear in the SELECT clause
Find the error in the following SQL statement?
CREATE TABLE person( person_id SMALLINT, name VARCHAR, LAST VARCHAR CONSTRAINTS pk_person PRIMARY KEY (person_id)); INSERT INTO person VALUES( person_id, name, LAST) (1, ’s’, ’p’); INSERT INTO person ( person_id, name, LAST) VALUES(1,’s’,’p’);
Read the passage carefully and choose the best answer to each question out of the four alternatives.
Eight north Indian Ocean countries, namely, Bangladesh, India, the Maldives, Myanmar, Oman, Pakistan, Sri Lanka and Thailand, were asked to contribute names so that a combined list could be compiled. Each country gave eight names and a combined list of 64 names was prepared. This list is currently in use, and all cyclones arising in the north Indian Ocean are named from this list, with one name from each country being used in turn. Almost 38 or 39 names from the list have been used up, but since many cyclones dissipate long before they hit land, their names rarely figure in the papers or other media. The names that people do know about, and remember are, naturally, those that were most destructive ones, or very recent. Aila, in 2009 is remembered with a shudder for the enormous destruction it caused in West Bengal and Bangladesh; Phaillin, also for the damage it caused when it hit the Odisha coast in 2013. Two harmless cyclones, which also might remain in peoples memory, are the more recent ones of 2014 — Hudhud, which threatened the east coast of India and Nilofar, which was expected to, but did not, devastate the western coast. The names in the cyclone list are usually words one associates with storms; words which mean water or wind or lightning in various national languages. Sometimes they are names of other things — birds or flowers or precious stones. The name Aila, contributed by the Maldives means fire, the name Phaillin from Thailand means sapphire, the name Hudhud from Oman is the name of a bird, probably the hoopoe, and the name Nilofar, given by Pakistan, is the Urdu name of the lotus or water lily. The eight names suggested by India, and which are in the list of 64, are Agni, Akaash, Bijli, Jal, Leher, Megh, Sagar and Vayu, meaning in that order, fire, sky, lightning, water, wave, cloud, sea and wind. Five of these names (that is, up to Leher) have been used so far.
For the next cyclone if it is the turn of an Indian name to be chosen, then what will be that name?
Read the passage carefully and choose the best answer to each question out of the four alternatives.
Eight north Indian Ocean countries, namely, Bangladesh, India, the Maldives, Myanmar, Oman, Pakistan, Sri Lanka and Thailand, were asked to contribute names so that a combined list could be compiled. Each country gave eight names and a combined list of 64 names was prepared. This list is currently in use, and all cyclones arising in the north Indian Ocean are named from this list, with one name from each country being used in turn. Almost 38 or 39 names from the list have been used up, but since many cyclones dissipate long before they hit land, their names rarely figure in the papers or other media. The names that people do know about, and remember are, naturally, those that were most destructive ones, or very recent. Aila, in 2009 is remembered with a shudder for the enormous destruction it caused in West Bengal and Bangladesh; Phaillin, also for the damage it caused when it hit the Odisha coast in 2013. Two harmless cyclones, which also might remain in peoples memory, are the more recent ones of 2014 — Hudhud, which threatened the east coast of India and Nilofar, which was expected to, but did not, devastate the western coast. The names in the cyclone list are usually words one associates with storms; words which mean water or wind or lightning in various national languages. Sometimes they are names of other things — birds or flowers or precious stones. The name Aila, contributed by the Maldives means fire, the name Phaillin from Thailand means sapphire, the name Hudhud from Oman is the name of a bird, probably the hoopoe, and the name Nilofar, given by Pakistan, is the Urdu name of the lotus or water lily. The eight names suggested by India, and which are in the list of 64, are Agni, Akaash, Bijli, Jal, Leher, Megh, Sagar and Vayu, meaning in that order, fire, sky, lightning, water, wave, cloud, sea and wind. Five of these names (that is, up to Leher) have been used so far.
Which name suggested by India has not been used so far?
In the following passage some of the words have been left out. Read the passage carefully and choose the correct answer for the given blank out ofthe four alternatives.
We have rich cultural _____ . Its roots go into _____. Ours has never been a closed ______. It has _______ just like a tree, ______ to external ______ but holding itsroots _______. But one wonders today whether it will be able to hold its _____. The ______ of our cultural heritage has come under the _____ of western culture.
We have rich cultural _____ .
In the following passage some of the words have been left out. Read the passage carefully and choose the correct answer for the given blank out of the four alternatives.
We have rich cultural _____ . Its roots go into _____. Ours has never been a closed ______. It has _______ just like a tree, ______ to external ______ but holding itsroots _______. But one wonders today whether it will be able to hold its _____. The ______ of our cultural heritage has come under the _____ of western culture.
Its roots go into _____.
In the following passage some of the words have been left out. Read the passage carefully and choose the correct answer for the given blank out ofthe four alternatives. We have rich cultural _____ . Its roots go into _____. Ours has never been a closed ______. It has _______ just like a tree, ______ to external ______ but holding itsroots _______. But one wonders today whether it will be able to hold its _____. The ______ of our cultural heritage has come under the _____ of western culture.
whether it will be able to hold its _____.
In the following passage some of the words have been left out. Read the passage carefully and choose the correct answer for the given blank out ofthe four alternatives.
We have rich cultural _____ . Its roots go into _____. Ours has never been a closed ______. It has _______ just like a tree, ______ to external ______ but holding itsroots _______. But one wonders today whether it will be able to hold its _____. The ______ of our cultural heritage has come under the _____ of western culture.
the _____ of western culture.
In the following passage some of the words have been left out. Read the passage carefully and choose the correct answer for the given blank out ofthe four alternatives.
We have rich cultural _____ . Its roots go into _____. Ours has never been a closed ______. It has _______ just like a tree, ______ to external ______ but holding itsroots _______. But one wonders today whether it will be able to hold its _____. The ______ of our cultural heritage has come under the _____ of western culture. Ours has never been a closed ______
In the following passage some of the words have been left out. Read the passage carefully and choose the correct answer for the given blank out ofthe four alternatives.
We have rich cultural _____ . Its roots go into _____. Ours has never been a closed ______. It has _______ just like a tree, ______ to external ______ but holding its roots _______. But one wonders today whether it will be able to hold its _____. The ______ of our cultural heritage has come under the _____ of western culture.
just like a tree, ______ to external