 Related Questions Latest Answer : Two tier architecture having three components at two layers. It was intended due to the limitation in the file sharing software engineering as in the file sharing system more than 12 users can not work together. ... Read Answers (20) | Asked by : geetha Latest Answer : Normalization is based on the functional dependency and primary key.1NF- Attribute should be atomic value and there must be no composite attribute, no multivalued attribute and no relation with in relation. By default what ever relation we are creating ... Latest Answer : DELETEWe can use the DELETE command to remove rows from a table. We must specify a WHERE clause in our DELETE statements so only some rows will be removed.If we do not do that all rows will be removed and that something we ... Read Answers (18) | Asked by : Periyasamy Latest Answer : HI, In simple words databse is generic and database server is specific to computers. Database is collection of data in a defined manner.Database sever is software that helps us to operate on the databaseRegards,PRASAD ... Read Answers (7) | Asked by : Rana Irfan What is the difference between a stored procedure and a view? why do we use views from SQL Server point of view? What are mutating triggers? How is the structure of a bit map index, clustered, Non clustered and B Tree What re mutating triggers? Can a stored procedure a record set? Can we use DTS on a client machine to schedule jobs and consolidate data to a sql tables? Can we have an update trigger within another update trigger? Latest Answer : 1) Transaction database is designed for a specific application.Datawarehouse is designed to integrate data from multiple datasource.2) Transaction focuses on the details, Datawarehouse focuses on high level aggregates.3) Transaction database is volatile. ... Read Answers (8) | Asked by : Mojtaba Kamalian Latest Answer : Perform is purely based on executionhow we get the result, ie Time , spped etcbutexecute is purely depends on logic of how we had done the design and code,itslike the output for given input for a written logic ... Latest Answer : Listener.ora is the configuration file for the listener, living on theserver. Tnsnames.ora is one of the sqlnet configuration files on the client. ... Read Answers (1) | Asked by : nutan Latest Answer : As c is a programming language, T-Sql is also the same to SQLin other words T-Sql is implemetation of SQL in Microsoft SQL Server ... Read Answers (6) | Asked by : dhana Latest Answer : DAO is quite older one and doesnt support few rdbms'swhile ado is the later one that supports all dbms as well as rdbms ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
