Database - Interview Questions and Answers for 'Triggers' | Search Interview Question

Database - Interview Questions and Answers for 'Triggers' - 6 question(s) found - Order By Newest

Q1. What is a Database Trigger ?

Ans. A trigger is a special kind of stored procedure that automatically gets executed upon an event in the database server.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve database trigger Asked in 10 Companies basic frequent}

Q2. What are the different trigger types in AWS Lambda ?

Amazon Web Services (AWS)

Ans. Api Gateway
Alexa
CloudFront
CloudWatch
Code Commit
Kinesis
S3
SNS

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve aws lambda aws serverless computing amazon cloud serverless computing amazon lambda trigger}

Q3. What is the difference between TimeBasedRollingPolicy and SizeBasedTriggeringPolicy within Log4j ? Can we use both together and What would that mean ?

Log4j

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.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve Log4j TimeBasedRollingPolicy SizeBasedTriggeringPolicy}

Q4. What is the order in which triggers gets fired ?

Database

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.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve oracle database triggers sequence of trigger execution sequence in which triggers gets fired Asked in 1 Companies}

Q5. What do you understand by "Scaling Trigger" ?

Server

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.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve AWS Amazon AWS Amazon EC2 Elastic Beanstalk Auto Scaling Scaling Trigger production support}

Q6. What is the use case of having Code Commit trigger within AWS Lambda ?

Amazon Web Services (AWS)

Ans. If we would like a program to be executed if someone commits code to the repository.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve aws lambda aws serverless computing amazon cloud serverless computing amazon lambda trigger}

Search Interview Questions

Help us and Others Improve. Please let us know the questions asked in any of your previous interview.