Databases support a wide range of advanced features (some support more features than others). These features can and should be used to improve performance, ensure data integrity, and help protect data.
Sample Questions
1:
Which of the following technologies could you use to ensure data consistency?
Stored procedure
Trigger
Index
Primary key
2:
Which of the following statements are true?
Stored procedures execute quicker than regular SQL statements.
Stored procedures are supported by all databases.
Stored procedures cannot be called from within ColdFusion code.
Stored procedures can help secure your data.
3:
Which of the following statements support triggers?
INSERT
UPDATE
DELETE
SELECT
4:
Which of the following technologies could be used to prevent database hacking via URL tampering?