What are Data Manipulating Language (DML) Statements?
Data manipulating language (DNL) statements query and manipulating data in existing scheme objects. These statements do not implicity commit the current transaction. 54. What are Data Manipulating Language Statements? • CALL • DELETE • EXPLAIN PLAN • INSERT • LOCK TABLE • MERGE • SELECT • UPDATE 55. What are the Transaction control Statements? • COMMIT • ROLLBACK • SAVEPOINT • SET TRANSACTION 56. Define Session Control Statements? Session control statements dynamically manage the properties of a user session. These statements do not implicity the current transaction. 57. Define System Control Statement? The single system control statement dynamically manages the properties of an Oracle instance. This statement does not simplicity commit the current transaction. ALTER SYSTEM is not supported in PL/SQL. 58. What are Embadded SQL Statements? Embedded SQL statements place DDL, DML, and transaction control statements within a procedural lam Language program. 59. What are the Session control
