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

Question

mr Craig Ferguson · Accepted Answer

The stored procedures and views will refer to tables in the source database.

mr Craig Ferguson · Answer

The cloned views and the stored procedures will reference the cloned tables in the cloned database.

mr Craig Ferguson · Answer

An error will occur, as views with qualified references cannot be cloned.

mr Craig Ferguson · Answer

An error will occur, as stored objects cannot be cloned.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 248 - COF-R02 discussion

Suggested answer: D

0 comments