srilathat123

 Profile Answers by srilathat123 

• Nov 16th, 2005

 

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.

Bgl_Sathis

• Nov 28th, 2005

 

hi friends,

    database testing is nothing but backend testing.

if we want to check all your datatable details means we have to good knowedge about all ddl comments

the ddl cover coment.

                select ,delet,insert,update and all type of joins

i thk my ans very hope ful for you..'

thx,

bgl_brain

   

anand choubey

• Dec 5th, 2005

 

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

pranav

• Jan 31st, 2007

 

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.

Deepak Kalra

• Aug 18th, 2007

 

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.

vemparalasuresh

 Profile Answers by vemparalasuresh 

• Jun 18th, 2008

 

suresh:-
             we can't say, insert , update, delete are sufficient. the db tester have good knoeledge on sql

ashishks

 Profile Answers by ashishks 

• Aug 28th, 2009

 

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