Google News
logo
SQL Server - Quiz(MCQ)
Which of the code deletes node H using hierarchical data type?
A)
DELETE H WHERE Name = ‘Steve’
B)
DROP FROM H WHERE Name = ‘Steve’
C)
DELETE FROM H WHERE Name = ‘Steve’
D)
All of the above

Correct Answer :   DELETE FROM H WHERE Name = ‘Steve’


Explanation : Deleting a node does not automatically delete the child nodes, this would result in orphaned children.

Advertisement