Transaction Control Language

Transaction Control Language These commands are used for controlling the state of the transaction they are fired from. Controlling a transaction includes capabilities of committing it, rolling back the changes, identifying the SAVEPOINTs to control the ROLLBACK, etc. The command belonging to this category are:- COMMIT – used for making the changes permanent. ROLLBACK – … Read more

Overview On Databases

Overview On Databases What is a Database? : A database is a systematic collection of data. Databases support storage and manipulation of data. Databases make data management easy. They do so through the use of tables. For example, a university database might contain information about the following: • Entities such as students, faculty, courses, and … Read more

SQL Interview Questions and Answers

SQL Interview Questions and Answers Structured Query Language (SQL) developed by IBM in 1970s, It is used to communicate with Databases. Most of the Databases Management Systems like Oracle, Sybase, MS SQL Server, MySQL, IBM-DB2 etc… using SQL for communication databases. SQL knowledge is mandatory for Database developers as well as Testers. 1) What are … Read more