🎴 Flashcard Mode
PL-SQL and SQL Database Concepts
Card1 / 20
Mastered0
Review0
QuestionClick to flip
What is true about MERGE command? Choose all that apply.
AnswerClick to flip back
A
It is a DML command
B
Provides the ability to conditionally update or insert data into a database table
💡 Explanation:
MERGE is a DML (Data Manipulation Language) command, not DDL, because it modifies existing data in tables. It provides UPSERT functionality - conditionally updating existing rows or inserting new ones based on a matching condition. Option D is incorrect because MERGE operates on table data, not on schema objects like views or indices.