Search Interview Questions | ![]() ![]() Click here and help us by providing the answer. ![]() Click Correct / Improve and please let us know. |
|
| ||||
Database - Interview Questions and Answers for 'Triggers' - 6 question(s) found - Order By Newest | ||||
| ||||
Ans. A trigger is a special kind of stored procedure that automatically gets executed upon an event in the database server. | ||||
![]() | ||||
![]() ![]() ![]() ![]() ![]() ![]() | ||||
| ||||
Ans. Api Gateway Alexa CloudFront CloudWatch Code Commit Kinesis S3 SNS | ||||
![]() | ||||
![]() ![]() ![]() | ||||
| ||||
Ans. TimeBasedRollingPolicy enables rolling of logs based on the time / days whereas SizeBasedTriggeringPolicy enables rolling of logs based on size cap. Yes we can use both together. In that case Logs will be rolled in case any of the condition is met i.e after the interval or if the size is reached. | ||||
![]() | ||||
![]() ![]() ![]() | ||||
| ||||
Ans. There is no specific order in which database fires the triggers if they are for the same operation. If we need to have a specific order for their execution, we should have them all in a stored procedure and the procedure should get executed upon the event. | ||||
![]() | ||||
![]() ![]() ![]() ![]() | ||||
| ||||
Ans. It's a configuration for auto scaling environment that specify the attributes / conditions for scaling instances up and down. For example - We may like environment to scale up when the number of requests / sec increases a particular threshold and scale down when it decreases below a threshold. | ||||
![]() | ||||
![]() ![]() ![]() | ||||
| ||||
Ans. If we would like a program to be executed if someone commits code to the repository. | ||||
![]() | ||||
![]() ![]() ![]() | ||||