Answer / stl

We use sql in Database testing. to see the impact of front
end changes are correctly posted on the backend database

Answer / 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

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

0 Answers  

---

Can we use join in subquery?

0 Answers  

---

How can we find duplicate records in a table?

0 Answers  

---

How delete all data from table in sql?

0 Answers  

---

If we have n no of columns in a table, can we add new column in that table with not null constraint?

2 Answers  

---

What is trigger in pl sql?

0 Answers  

---

how to connect oracle in unix prompt?

4 Answers   Polaris,

---

Why use truncate instead of delete?

0 Answers  

---

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.

2 Answers   Oracle,

---

How to disable a trigger name update_salary?

0 Answers  

---

Is it possible to create the following trigger: before or after update trigger for each row?

0 Answers  

---

how can create data base link for tow servers (scott schema) give examples plz

2 Answers  

---