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. ...
Latest Answer: There are restrictions on indexed views in SQL server such as the columns are not nullable. ...
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: 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 ...
Latest Answer: It is the property of the database to utilize the additional resources such as the memory and processors to meet the increased demand. By scaling performance is increased to a greater extend ...
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 ...
Latest Answer: step1) Search "demobld.sql" file in the directory where you installed Oracle using Search option. step2) Make a copy of it (demobld.sql) in C drive or D drive step3)Execute "@c:demobld.sql" in sql prompt(If you copied that in C drive).step4)Oracle ...
Latest Answer: We can normalize the many to many realationship, by creating a third table contaaining the primary keys of both the tables ...
Can you dynamically change the sys date hours , minutes and seconds? Can change the date OK but always get 00:00:00 with the new date.
View page << Previous 2 3 4 5 [6] 7 Next >>
Go Top
