New : »Puzzles Questions
SQL INTERVIEW QUESTION & ANSWERS
|11.||What are the four transactional control commands?|
|12.||What are the differences between a DDL statement and a DML statement?|
|DDL statements are used to create, modify, and delete database objects such as tables, views, schemas, domains, triggers, and stored procedures.
DML statements are used to view, add, modify, or delete data stored in the database objects.
|13.||What is a schema?|
|A schema is a set of related objects that are collected under a common namespace. The schema acts as a container for those objects, which in turn store the SQL data or perform other data–related functions.|
|14.||What is embedded SQL?|
|Embedded SQL refers to SQL statements that are interspersed in some type of application programming language. The SQL statements are blended into the host language to allow the source program to be able to access and modify SQL data and the underlying database structure.|
|15.||What are the data types available in SQL?|
|Posted by Sudarshan. (Oct 20, 2013)|