ITE 311 Advanced Database Systems Exam

Author

• bragz official View count: 2 · Try count: 2 · Copy count: 0

Stats

Question preview

• 1. Quiz: Testing pani, kalma lang: Gwapa si Kat
• 2. Quiz: An administrator wants to modify an incoming row's data before it is permanently stored in the database. Which trigger timing and configuration is BEST suited for this scenario?
• 3. Quiz: A database developer attempts to modify a transition variable during an operation. Under which of the following circumstances will this modification be successful?
• 4. Quiz: To enforce complex business validation that must completely reject and abort an incoming DML transaction, which mechanism should be used inside a MySQL trigger?
• 5. Quiz: A development team discovers that complex business logic hidden inside various triggers is causing mysterious system latencies and makes debugging extremely difficult. Which architectural anti-pattern are they experiencing?