Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a Application Server and a
Database
- 3 Answers
- 13034 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / suresh murugadass
Application server contain all application specific
components such as Jar, WAR, EAR files which inturn
containts web components and bussine class components.
DB Server will normally a separate server instance. App
server send a db request via JDBC calls to connect to the db
and fetch the results / process the request in the databse.
| Is This Answer Correct ? | 27 Yes | 0 No |
Answer / mahadev maity
Application server contain all application such as(MS word,
excel etc)which responsible for web component and contain
business data.
Database server is a separate server. application server
depends on the DB server. application server sends a db
request and process the request.
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / sivasankardoss
Application Server conatains all the databases that holds
the business data.
Database resides in the application servetr.
Sivasankardoss.K
| Is This Answer Correct ? | 6 Yes | 29 No |
What are user defined functions in ms sql server?
What is difference between join and natural join?
What kind of problems occurs if we do not implement proper locking strategy?
Explain about merge replications?
Explain about service Broker functions?
* CREATE TABLE [dbo].[t_Colors]([ColorId] [int] NOT NULL,[ColorName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ColorDesc] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,[ColorIndex] [int] NULL) ON [PRIMARY] GO * insert into [t_Colors] values(101,'Red','',1) insert into [t_Colors] values(101,'Red1','',2) insert into [t_Colors] values(102,'Blue','',1) insert into [t_Colors] values(102,'Blue1','',2) insert into [t_Colors] values(102,'Blue2','',3) * In this table i need to delete DELETE FROM t_Colors WHERE ColorIndex=1 AND ColorId=102 After delete above condition i need to update the ColorIndex set to 1 for Blue1[ColorName] and 2 for Blue2[ColorName] select * from [t_Colors] Note:- how can i get updates the ColorIndex values after delete. for example we need to update Blue1 ColorIndex set to 1 and Blue2 ColorIndex set to 2
Detail about the hardware which is supported by SQL server?
How dts is used to extract, transform and consolidate data?
How do you rename a table in sql server?
can we have a nested transaction? : Sql server database administration
what is performance tunning in sql server ? explain.
Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?
-
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)
