- Trigger A stored procedure in a database that automatically executes or is triggered when a specific event occurs in the database. - Events Common events include data modification operations like INSERT, UPDATE, and DELETE. - Conditions Triggers can be set to fire only when certain conditions are met. - Purpose Triggers are used for enforcing business rules, maintaining data integrity, auditing, and automating complex database operations.
The operation which can be used to specify automatic actions that the database system will perform when certain events and conditions occur is known as - - Question not attempted
Asked in Programmer Exam 2024 · Topic: Big Data, Data Analytics, and Cloud Storage (Data Mining Concepts and Techniques)
More Information and Communication Technology questions
- Correct order of applying 3 passes in ARIES recovery algorithm is - - Question not attempted
- Consider following schedule with a sequence of operations on a data object Q having the initial value of 500 - What will be the final value of Q after the last operation is completed? - Question not attempted
- Which one of the following statement is not correct? - Question not attempted
- The concept of 'Big O' notation is used to express the - memory usage of an algorithm in relation to the input data - efficiency of an algorithm based on the programmer's skill - specific number of steps an algorithm takes for a given input - upper bound on the time complexity of an algorithm as input size grows
- You have a labelled data set of fraudulent and legitimate transactions. Which type of machine learning is most appropriate for building a fraud detection system?
- ______ is required in supervised learning.
- With respect to various computing environments and their applications which of the following pairs are correctly matched? Cloud computing: Building datasets for AI-based applications Edge computing : Municipal Solid Waste Management Fog computing : Autonomous Vehicles Select the correct answer code:
- Assertion (A) : Online survey tools such as Survey Monkey and Question Pro have made data collection, analysis and result extraction much easier and simpler. Reason (R) : Though these tools are being used widely without any doubt in recent time, but social research cannot rely always on the results from an online survey because of their inherent limitations. Select the correct answer from the following options :
All 1,360 Information and Communication Technology questions →