Which operation is supported by the Database Connector for data definition?

Which operation is supported by the Database Connector for data definition?

• A. It supports only SELECT statements
• B. It can execute stored procedures
• C. It performs bulk inserts only
• D. It can execute DDL statements such as CREATE and ALTER

Answer: (D)

Data definition language is about changing the database structure—creating or altering objects like tables. The Database Connector can run such statements, so you can issue SQL like CREATE TABLE or ALTER TABLE through it. This is why executing DDL statements such as CREATE and ALTER is supported. It isn’t limited to retrieving data with SELECT, nor solely about stored procedures or bulk inserts, which are different kinds of operations.

Data definition language is about changing the database structure—creating or altering objects like tables. The Database Connector can run such statements, so you can issue SQL like CREATE TABLE or ALTER TABLE through it. This is why executing DDL statements such as CREATE and ALTER is supported. It isn’t limited to retrieving data with SELECT, nor solely about stored procedures or bulk inserts, which are different kinds of operations.