All fields

“Triggers” in Information Technology

14 questions across 7 technologies.

Information Technology

14 questions in 7 technologies

#QuestionTechnologyTopicLevel
1Why should triggers generally be designed to handle multiple affected rows at once rather than assuming only a single row was changed? SQL Server › TriggersSQL ServerTriggersIntermediate
2What are the performance implications of using triggers heavily on a busy, high transaction volume table? SQL Server › TriggersSQL ServerTriggersAdvanced
3How do nested and recursive triggers work in SQL Server, and what precautions should be taken to avoid unexpected behavior or infinite loops? SQL Server › TriggersSQL ServerTriggersAdvanced
4How is Change Data Capture different from using triggers to track changes to a table? SQL Server › Change Data Capture (CDC)SQL ServerChange Data Capture (CDC)Intermediate
5What are Triggers in MAUI and what types exist? .NET MAUI › Styling, Resources & Themes.NET MAUIStyling, Resources & ThemesAdvanced
6What are Triggers in MAUI and what types exist? .NET MAUI › Styling, Resources & Themes.NET MAUIStyling, Resources & ThemesAdvanced
7How do you add a setter to a property so assignment (obj.attr = value) triggers custom logic, like validation? Python › Descriptors & PropertiesPythonDescriptors & PropertiesBeginner
8How would you test that clicking a button in a component triggers the expected behavior? Angular › Testing with Jasmine & KarmaAngularTesting with Jasmine & KarmaIntermediate
9How does SAM support defining event sources, such as API Gateway or S3 triggers, directly within a function's configuration? AWS › AWS Serverless Application Model (SAM)AWSAWS Serverless Application Model (SAM)Intermediate
10How can you properly implement pull to refresh functionality that correctly triggers a Riverpod provider to actually genuinely refetch its own underlying data using the ref.refresh or invalidate methods? Flutter › State Management with RiverpodFlutterState Management with RiverpodIntermediate
11What is a trigger in SQL Server, and what kinds of events can cause one to run automatically? SQL Server › TriggersSQL ServerTriggersBeginner
12What is the difference between an AFTER trigger and an INSTEAD OF trigger? SQL Server › TriggersSQL ServerTriggersBeginner
13How do you access the old and new values of a row that was just updated from inside a trigger? SQL Server › TriggersSQL ServerTriggersIntermediate
14What are some alternatives to using a trigger for tasks like auditing or enforcing business rules, and when might those alternatives be preferable? SQL Server › TriggersSQL ServerTriggersIntermediate