ibps-so 2016 · Question 178 of 394

The database administrator of Chandrabhaga Urban Bank has circulated a list of the statements the application issues against the empanelment schema, and has asked the trainees to place each of them in the sublanguage of SQL to which it belongs, since the bank's change-control procedure requires a written approval for one class of statement, an authorisation from the security o cer for another, and nothing at all for the third. The statements are: CREATE TABLE and ALTER TABLE; INSERT, UPDATE, DELETE and SELECT; GRANT and REVOKE; and COMMIT, ROLLBACK and SAVEPOINT. The four groups are correctly classi ed, in the order given, as:

1. AData manipulation language; data de nition language; transaction control language; and data control language
2. BData de nition language; data manipulation language; data control language; and transaction control languageCorrect
3. CData de nition language; data control language; data manipulation language; and transaction control language
4. DData control language; data manipulation language; data de nition language; and transaction control language
5. EData de nition language; data manipulation language; transaction control language; and data control language