• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Summary

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?
  1. Stored procedure

  2. Trigger

  3. Index

  4. Primary key

2:Which of the following statements are true?
  1. Stored procedures execute quicker than regular SQL statements.

  2. Stored procedures are supported by all databases.

  3. Stored procedures cannot be called from within ColdFusion code.

  4. Stored procedures can help secure your data.

3:Which of the following statements support triggers?
  1. INSERT

  2. UPDATE

  3. DELETE

  4. SELECT

4:Which of the following technologies could be used to prevent database hacking via URL tampering?
  1. Stored procedure

  2. Trigger

  3. Index

  4. Constraints


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint