Interested to Buy Any Domain ? << Click Here >> for more details...
In testing where do we use sql language and how it helps in
testing?
- 2 Answers
- 7297 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajendra prasad reddy,p
AS a Basic concept Database is two types
1.DBMS-Database Management Systems
2.RDBMS-Relational Database Management System
In DBMS the data will be stored in tables.It is not
possible to compare one table with another table in
DBMS.Like MS Access.
but in the case RDBMS we can create Data in the form of
tables and also it is possible to create relations from one
table to another table i.e we can compare one table data
with Another table data
SQL -Structured Query Language.
Mainly It has three parts
1.DDL-Data Definition Language
2.DML-Data Manipulation Language
3.TCL-Transaction Control Language
DDL contains following Operations
a.Create
b.Alter
c.Drop
d.Truncate
DML contains Following Operations
a.Select
b.Insert
c.Update
d.Delete
TCL contains Following operations
a.Commit
b.RollBack
Some famous database names are
MS SQL Server from Microsoft
(less secure conpared to oracle)
Oracle from Oracle Corporation
(highly Secure then SQL Server)
MySql Open Source DataBase(Free Available Databse)
Allthe above three widely using databases are built on
SQL.
In case of Testing SQL plays important role.
After creating Database it has ti be tested throughly.
Testing of database two types
1.Testing database directly by writing SQL
queries on the Back-end database and cross checking the
database vaidity.
2.Testing the database From front end,It requires
no knowledge of SQL skills
i.e we enter the data from front end and we will retrieve
from the front end.
Now a days Almost 90% of the applicationswill have
database.
Ok friends ,
Rajenda_prnumalli@yahooo.com
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How run sql*plus commands that are stored in a local file?
how to create a new view in mysql? : Sql dba
How to create an array in pl/sql?
What does rownum mean in sql?
What is trigger explain with example?
What is the difference between sql, mysql and sql server?
What is the use of desc in sql?
What does count (*) mean?
Explain select statements in sql?
How to move files from one directory to another in pl sql?
Explain the working of primary key?
what is online transaction processing (oltp)? : Sql dba
How do you remove duplicates without using distinct in sql?
Why is nosql good?
Which version of sql do I have?
