51Testing软件测试论坛

 找回密码
 (注-册)加入51Testing

QQ登录

只需一步,快速开始

微信登录,快人一步

手机号码,快捷登录

查看: 2797|回复: 0
打印 上一主题 下一主题

[转贴] How to Test database in Manually?

[复制链接]

该用户从未签到

跳转到指定楼层
1#
发表于 2007-12-27 19:39:20 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
Observing that opertaions, which are operated on front-end is effected on back-end or not.
The approach is as follows :
While adding a record thr' front-end check back-end that addition of record is effected or not.
So same for delete, update,......

Ex:Enter employee record in database thr' front-end and check if the record is added or not to the back-end(manually).
Database can be tested various ways,

If we are usein SQL server then opne the SQL query analyzer and write the queries to retrieve the data. Then verify whether the expected result is correct or not. IF not the data is not inserted into database.

We can play with queries to insert, update and delete the data from the data base and check in the front end of the application.

IF it is Oracle then open the SQL plus and follow the same procedure. Most of the time we find invalid data.

Same way we can test the stored procedure in sql query analyzer and check the result
How to test means , Through SQL quary we can test manually, how , i will tell see the below exmple with out using check point we can test.

1)connect to the database
db_connect("query1",DRIVER={drivername};SERVER=server_name;UID=uidnameWD=password;DBQ=database_name ");

2)Execute the query
db_excecute_query("query1","write query u want to execute");
-Condition to be mentioned-

3)disconnect the connection
db_disconnect("query");
分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏
回复

使用道具 举报

本版积分规则

关闭

站长推荐上一条 /1 下一条

小黑屋|手机版|Archiver|51Testing软件测试网 ( 沪ICP备05003035号 关于我们

GMT+8, 2024-11-7 18:28 , Processed in 0.069040 second(s), 27 queries .

Powered by Discuz! X3.2

© 2001-2024 Comsenz Inc.

快速回复 返回顶部 返回列表