Bissoy.com
Doctors Medicines MCQs Q&A

A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.

A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data. Correct Answer Triggers

Triggers are automatically generated when a particular operation takes place.

Related Questions

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create anapplication. The application uses the ADO.NET Entity Framework to model entities. Theapplication allows users to make changes to entities while disconnected from the central data store. You need to ensure that when the user connects to the central data store and retrieves new data, the application meets the following requirements:
  • Changes made to the local data store in disconnected mode are preserved.
  • Entities that have already been loaded into the local data store, but have not been modified by the user, are updated with the latest data.
What should you do?
The price of an item is 10% cheaper in an online store S compared to the price at another online store M. Store S charges ₹ 150 for delivery. There are no delivery charges for orders from the store M. A person bought the item from the store S and saved ₹ 100. What is the price of the item at the online store S (in ₹) if there are no other charges than what is described above?
Which of the following statements are true?
Statement I Big data refers to no precise quantity, but generally refers to data in the range of Petabytes and Exabyte, i.e. billions to trillions of records, all from various sources. Big data is generated much faster. than traditional data in much larger quantities.
Statement II Big data interests industries because they are able to learn more patterns and curious variances than smaller data sets, with the capability to provide valuable insights into consumer behaviour, weather systems, financial market activity, or other phenomena.
Statement III Various departments and product lines use various applications within most organisations and store data in separate datasets. These separate databases may contain similar data, but data from one data base to another is not always consistent. This is called data silo.
In a group, 29 people like to watch movies, 35 people like to watch web series and 34 people like to watch YouTube videos. Also, 13 people like to watch only movies, 21 people like to watch only web series and 15 people like to watch only YouTube videos. 4 of them like to watch only movies and web series. 3 of them like to watch movies, web series and YouTube videos as well. How many people like to watch both movies and YouTube videos?
Fact 1: All dogs like to run.
Fact 2: Some dogs like to swim.
Fact 3: Some dogs look like their masters.

If the first three statements are facts, which of the following statements must also be a fact?
I: All dogs who like to swim look like their masters.
II: Dogs who like to swim also like to run.
III: Dogs who like to run do not look like their masters.
Three concurrent processes X, Y, and Z execute three different code segments that access and update certain shared variables. Process X executes the P operation (i.e., wait) on semaphores a, b and c; process Y executes the P operation on semaphores b, c and d; process Z executes the P operation on semaphores c, d, and a before entering the respective code segments. After completing the execution of its code segment, each process invokes the V operation (i.e., signal) on its three semaphores. All semaphores are binary semaphores initialized to one. Which one of the following represents a deadlock-free order of invoking the P operations by the processes?
In a group, 22 women like Red color, 20 women like the blue color and 19 women like Yellow color. Among them, 5 women like both Red and Blue color, 5 women like both Yellow and Blue color and 9 women like both Red and Yellow color. 14 women like only Blue color and 4 women all the three colors. Find the total number of women who like only Red color.
There are 90 people in a company, they all like at least one of the drinks namely tea, coffee, and milk. Further it is known that, 20 people like all the three drinks. 30 people like both coffee and milk, 25 people like both tea and milk and 35 people like both tea and coffee. A total of 60 people like tea and a total of 40 people like milk. What is the number of people who like only coffee?
In a group, 22 women like Red colour, 20 women like blue colour and 19 women like Yellow colour. Among them, 5 women like both Red and Blue colour, 5 women like both Yellow and Blue colour and 9 women like both Red and Yellow colour. 14 women like only Blue color and 4 women all the three colors. Find the total number of women who like only Red color.
A survey of 100 candidates with respect to their choice of ice cream flavors - vanilla, chocolate and strawberry - produced the following information.  50 candidates like vanilla, 28 like chocolate, 43 like strawberry, 13 like vanilla and chocolate, 11 like chocolate and strawberry, 12 like strawberry and vanilla, and 5 like all the three flavours.  How many candidates like chocolate and strawberry but not vanilla?