1. The application server first attempts to connect to database using the user id and password as part of the database connection string.
2. User must be defin...
To enable the employee to connect to the database using the Application and have database access, the user corresponding to that employee should be created in t...
Simply u can Add,Delete and Modify records with the help of
application and then use diff.SQL queries to fetch data
from database then u come to no What ty...
LUW is Logical Unit of Work and the types of LUW are:
1)DB LUW - A database LUW is the mechanism used by the database to ensure that its data is always consi...
A database link is an object in the local database that allows you to access objects on a remote database or to mount a secondary database in read-only mode....
When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operati...
Connecting to a Database
The first step to using ADO.NET is to connect to a data source, such as a database. Using the Connection object, you tell ADO.NET whic...
A database instance (Server) is a set of memory structure and background processes that access a set of database files. The process can be shared by all users....
A database trigger is a PL/SQL block that can defined to automatically execute for insert, update, and delete statements against a table. The trigger can e defi...