When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

Question

Options

• AThe cloned views and the stored procedures will reference the cloned tables in the cloned
• BAn error will occur, as views with qualified references cannot be cloned.
• CAn error will occur, as stored objects cannot be cloned.
• DThe stored procedures and views will refer to tables in the source database.

• A
  91% (48)
• B
  6% (3)
• C
  2% (1)
• D
  2% (1)

Explanation

When cloning a database containing stored procedures and regular views with fully qualified table database (A). This ensures that the cloned database is a self-contained copy of the original, with all references pointing to objects within the same cloned database.

No community discussion yet for this question.