Ask a Question

____________ is a special type of stored procedure that is automatically invoked whenever the data in the table is modified.

in Education by
____________ is a special type of stored procedure that is automatically invoked whenever the data in the table is modified. (a) Procedure (b) Trigger (c) Curser (d) None of the Mentioned The question was posed to me in semester exam. I need to ask this question from Querying database part 3 topic in portion Transactions of Database Management

1 Answer

0 votes
by
The correct answer is (b) Trigger The explanation is: Triggers are used to initiate an action to take place.

Related questions

0 votes
Q: View Temporary Table Created from Stored Procedure
    I have a stored procedure in SQL 2005. The Stored Procedure is actually creating temporary tables in the ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 19, 2022 in Education by JackTerrance
0 votes
Q: View Temporary Table Created from Stored Procedure
    I have a stored procedure in SQL 2005. The Stored Procedure is actually creating temporary tables in the ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 18, 2022 in Education by JackTerrance
0 votes
Q: View Temporary Table Created from Stored Procedure
    I have a stored procedure in SQL 2005. The Stored Procedure is actually creating temporary tables in the ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 18, 2022 in Education by JackTerrance
0 votes
Q: Insert results of a stored procedure into a temporary table
    How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [ ... not supply any columns. Select the correct answer from above options...
asked Jan 28, 2022 in Education by JackTerrance
0 votes
Q: Which SQL server table is used to hold the stored procedure scripts?
    Which SQL server table is used to hold the stored procedure scripts?...
asked Nov 9, 2020 in Technology by Editorial Staff
0 votes
Q: which of the following is not a type of stored procedure:-a-systemb-inputc-remoted-user-defined
    which of the following is not a type of stored procedure:- a-system b-input c-remote d-user-defined (Tick the correct option) Select the correct answer from above options...
asked Dec 10, 2021 in Education by JackTerrance
0 votes
Q: Stored Procedure in Mysql returnig only one column data
    Simple select stored procedure but getting only one column as the result others were getting as null. Can ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 7, 2022 in Education by JackTerrance
0 votes
Q: Stored Procedure in Mysql returnig only one column data
    Simple select stored procedure but getting only one column as the result others were getting as null. Can ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
Q: How inserting data through stored procedure do reduces network traffic and increase database performance?
    How inserting data through stored procedure do reduces network traffic and increase database performance? (a) ... Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: a,b,c and d are int type, however, the expression is slightly modified as (a+b*c-d)/7.0. What is the resultant data type of the following mathematical expression?
    a,b,c and d are int type, however, the expression is slightly modified as (a+b*c-d)/7.0. ... of the following mathematical expression? Select the correct answer from above options...
asked Dec 19, 2021 in Education by JackTerrance
0 votes
Q: a,b,c and d are int type, however, the expression is slightly modified as (a+b*c-d)/7.0. What is the resultant data type of the following mathematical expression?
    a,b,c and d are int type, however, the expression is slightly modified as (a+b*c-d)/7.0. ... of the following mathematical expression? Select the correct answer from above options...
asked Dec 18, 2021 in Education by JackTerrance
0 votes
Q: Special programs that assist programmers are called ____________
    Special programs that assist programmers are called ____________ (a) heuristic processors (b) symbolic programmers (c) ... (d) program recognizers Please answer the above question....
asked Oct 9, 2022 in Education by JackTerrance
0 votes
Q: Special programs that assist programmers are called ____________
    Special programs that assist programmers are called ____________ (a) heuristic processors (b) symbolic programmers (c) ... (d) program recognizers Please answer the above question....
asked Oct 2, 2022 in Education by JackTerrance
0 votes
Q: Special programs that assist programmers are called ____________
    Special programs that assist programmers are called ____________ (a) heuristic processors (b) symbolic programmers (c) ... (d) program recognizers Please answer the above question....
asked Sep 23, 2022 in Education by JackTerrance

© Copyright 2018-2023 www.Blogmepost.com. All rights reserved. Developed by Blogmepost.

...