Which two are SQL features? (Choose two.)
Which two are SQL features? (Choose two.)
SQL features include processing sets of data and providing database transaction control. SQL operations are typically set-based, meaning they handle collections of data as opposed to individual records. Additionally, SQL has robust capabilities for controlling database transactions, including commands to begin, commit, and roll back transactions, ensuring data integrity and consistency.
The two SQL features are: B. Processing sets of data. SQL is primarily designed for processing sets of data. It allows you to query, insert, update, and delete data in a relational database management system (RDBMS). SQL statements operate on sets of records, and you can use SQL to retrieve, manipulate, and manage data in databases. E. Providing variable definition capabilities. SQL supports variable definition capabilities through the use of variables and parameters. You can declare and use variables and parameters within SQL statements to store and manipulate data.
My hesitation on this one is E. https://docs.oracle.com/en/database/oracle/oracle-database/19/sqpug/DEFINE.html