SQL

Question 147

In DML, RECONNCT command cannot be used with

A	OPTIONAL Set
B	FIXED Set
C	MANDATOR Set
D	All of the above

Database-Management-SystemSQLUGC NET CS 2012 Dec-Paper-2

Question 147 Explanation:

→ The RECONNECT command can be used with both OPTIONAL and MANDATORY sets, but not with FIXED sets.
→ The RECONNECT command moves a member record from one set instance to another set instance of the same set type. It cannot be used with FIXED sets because a member record cannot be moved from one set instance to another under the FIXED constraint.

Correct Answer: B

Question 147 Explanation:

→ The RECONNECT command can be used with both OPTIONAL and MANDATORY sets, but not with FIXED sets.
→ The RECONNECT command moves a member record from one set instance to another set instance of the same set type. It cannot be used with FIXED sets because a member record cannot be moved from one set instance to another under the FIXED constraint.

SQL

SQL

SQL

Kirti