what SQL statements have you used in Database Testing?
I said I used select statements most of the times. So, the interviewer took it granted that I am unaware of insert, update and delete statements. Hence it is better to read out whole of the SQL as an answer to this question.
Total Answers and Comments: 7
Last Update: August 28, 2009 Asked by: Bindu Puvvala
RE: what SQL statements have you used in Database Test...
DDL( Data Definition Language) and DML(Data Manipulation Language) .DDL for creating tables and database.DML for the manipulations like insert alter and delete operations.
RE: what SQL statements have you used in Database Test...
DDLDDL is Data Definition Language statements. Some examples: CREATE ALTER - DROP - TRUNCATE - COMMENT - RENAME - DMLDML is Data Manipulation Language statements. Some examples: SELECT - INSERT - UPDATE - DELETE - MERGE - UPSERT - CALL - EXPLAIN PLAN - LOCK TABLE - DCLDCL is Data Control Language statements. Some examples: GRANT - REVOKE - COMMIT - SAVEPOINT - ROLLBACK - COMMIT - SET TRANSACTION - This are the Database testing commands used.thnxAnand
RE: what SQL statements have you used in Database Test...
Database Testing can use a lot of SQL statements.other than all of them that were already mentioned above you might want to use stored procedures and triggers as well in order to create test data.Creation of test data is the most critical part of database testing as well as identifying valid inputs.If you are testing a database service you will have to use many SQL statements as mentioned above but if you are testing a stored procedure or a trigger then select update delete are more than enough. Obviously other than joins which are always important.
RE: what SQL statements have you used in Database Test...
Pranav gave a very good reply that Test Data is very critical part while performing Backend testing or DB testing. One should have properly prepared Test Data before performing DB testing....Mainly DB testing is used to test data corectness and data integrity.
RE: what SQL statements have you used in Database Testing?
The following are the most widely used Sql statments in database testing: 1. Use Database 2. Select 3. Insert 4. Update 5. Delete 6. Drop 7. Alter 8. Modify Structure 9. Join(Inner and outer) 10. Views
