Interested to Buy Any Domain ? << Click Here >> for more details...
what is meant by trigger?
- 8 Answers
- 19658 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mrniceksa
A trigger is a special kind of stored procedure that goes
into effect when you modify data in a specified table using
one or more data modification operations: UPDATE, INSERT,
or DELETE. Triggers can query other tables and can include
complex SQL statements. They are primarily useful for
enforcing complex business rules or requirements. For
example, you could control whether to allow an order to be
inserted based on a customer's current account status.
| Is This Answer Correct ? | 46 Yes | 7 No |
Answer / bgg
trigger is something which is executed when some specified
event occurs.
two main specifications are-
1.when the trigger should be executed(event)
2.what action must be taken when this event occurs
| Is This Answer Correct ? | 15 Yes | 5 No |
Answer / sagaya maria virgin
a trigger is a statement that system execute automatically
as a side effect of a modification of database.
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / dinesh kumar
Trigger can be defined as a action that is performed on
data when event occur. Here action can modify data from
database, insert data into database etc.
| Is This Answer Correct ? | 9 Yes | 5 No |
Answer / srikanth
A trigger is a special kind of stored procedure that goes
into effect when you modify data in a specified table using
one or more data modification operations: UPDATE, INSERT,
or DELETE.
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / a.palanisamy
A trigger is a special kind of stored procedure that goes
into effect when you modify data in a specified table using
one or more data modification operations: UPDATE, INSERT,
or DELETE. in future use u can get old data from specified table
| Is This Answer Correct ? | 0 Yes | 1 No |
In OB52 , How to define two open posting period, Like only 5 and 8 posting should be open.. should not open 6 and 7..period..
How to use string functions in QTP?give some examples
What is the difference between WebIntelligence and Designer in creating universes?
cgi stands for
What ports must be open for DCOM over a firewall? What is the purpose of Port 135?
In Java what is the difference between following two statements ? int a[],b; int []a,b;
Write a program to read and print a text file on screen
What is web.configuration? how is it work? & wht is use this?
what is the last ant version you worked?how to get it
Write a program to implement BFS/ DFS routine in a connected graph
1.) - Design the class model and produce a class diagram for a set of vehicle types for a vehicle manufacturer. At a minimum, the class model should include the following information: - Type of vehicle (e.g. sedan, truck, etc), - Number of seats - Number of doors - Color of the vehicle - Transmission type (auto vs manual) - Engine’s rated horsepower - Number of engine cylinders - Engine size (in liters) - Number of stereo speakers - Does it include satellite radio? - Does it have a CD player? (and if so, how many CDs can it hold?) - Is it front, rear, all, or 4 wheel drive? - Truck bed type (e.g. short, standard, long) - Trunk size (for those vehicle types that have a trunk) 2.) I want to create an in-memory definition for a set of airline routes for a small airline company. I want to maintain a list of all of my planes and their current locations (or their destination location if they are currently in the air). One of the possible locations needs to be “hangar” for maintenance or repairs. I want to have the full airline schedule available so that I can look for available flights. I also want to store information on which planes are operating each schedule. Assuming that a customer comes to the ticketing counter at one of my airports when it opens at 6:00am, I want to be able to give a customer the fastest option to get from one airport to another. Keep in mind that it may take more than one flight to get from one airport to another. Describe how you would fulfill this request with your design. 3.) I want to create a course registration database for a university. I want to store information for each department, information for each course (including which department they’re offered under as well as which professors are teaching them), information for each professor, and the list of the registered students and which courses each student has registered for. Keep in mind that an instance of a course could be taught by multiple instructors (i.e. one instructor for the first half of the course and then a different instructor for the second half). Also keep in mind that there could be multiple instances of a given course offered by different sets of instructors (e.g. offered by Bob Smith on Mondays & Wednesdays at 10am and Bill Jones on Tuesdays & Thursdays at 1pm). Design a set of database tables to store this information. 4.) Given the following: You have an application that consists of three parts: a front end GUI, a middle-ware layer where all the processing of data takes place and a database where data is read from. What are the areas that would be most likely to break? What would your testing strategy for this be? Why? 5.) Imagine I am handing you a wine glass and I ask you to test it. What would your testing strategy for this be?
I was try to insert 120000 records into the orcle table using the stroed proceeder. But it was stop the 9999. What can I do insert all the records.
C 
