Interested to Buy Any Domain ? << Click Here >> for more details...
how i do the database testing of online money transactions
between two parties (client and organization).
suppose our company makes a website for our client and give
a extra feature of online money transaction with there
clients then how i test this feature in database testing
- 1 Answers
- 4086 Views
- I also Faced
- E-Mail Answers
Answer / kumar
Every online transaction is having credit debit
transactions. Suppose if client is transferred money from
his account to another account. The client account will be
debited and other party account will be credited.
If we are maintaining only client account from our end.
These transactions details will be updated/inserted into
database tables. This can be achieved by writing pl/sq l
program unit
can be called from other interfaces.
I think this is a normal process for testing what we do for
pl/program units.
When client performs online transaction back end pl/sql
program unit will be called and the corresponding data base
will be effected.
| Is This Answer Correct ? | 0 Yes | 0 No |
Why are sql stored procedures used?
what is a stored procedure? : Sql dba
Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.
What are packages in pl sql and also explain its advantages?
how to calculate expressions with sql statements? : Sql dba
What is the usage of distinct keyword?
Which command is used to call a stored procedure?
How packaged procedures and functions are called from the following?
How do I write a sql query in pgadmin 4?
how to retrieve the top 3 salaries of the table using rownum
What is the use of index in sql?
what is table? : Sql dba
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
