Multiple choice technology packaged enterprise solutions

How do you run SQL alter to alert you the discrepancies between your record definitions and underlying SQL tables without actually performing changes to the object in the database?

  1. Run as a user with SELECT only permissions to the underlying database

  2. Run the SQL Alter in Audit only mode

  3. Run the SQL Alter in Report mode by selecting Build Script file Radio button

  4. Run as a user that has no permission to modify the underlying database

  5. Run as a user with AUDIT permissions to the underlying database
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Running SQL Alter in Report mode with 'Build Script file' option generates a script showing the discrepancies without executing changes. This lets you review differences between record definitions and SQL tables safely. The other options involve permissions or audit modes that don't generate comparison scripts.

Keep practicing — related questions