What are the different types of SQL statements?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

113. What are the different types of SQL statements?

SQL statements are divided into five categories:
Data manipulation language (DML).
Data definition language (DDL).
Transaction control.
Session control.
System control

(Continued on next question...)

Other Job Interview Questions

• Give one method for transferring a table from one schema to another
• What is the basic data structure that is required for creating an LOV?
• Auditing
• What are the different types of Record Groups?
• What are the built-ins used for processing rows?
• Give some examples of Analytical functions
• What is a database link?
• How to implement the multiple control files for an existing database?
• What are the Built-ins to display the user-named editor?
• How do you resize a data file?
• More...