Latest Answer: Group by class will have to group all the data returing from the query in our specifed groups... so it is definitly an overhead from execution point of view... imagine that the number of rows returned by the query are in millions and you have to group ...
Latest Answer: A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server. There are three types of triggers: 1. DML trigger ...
Latest Answer: Normalization is the technique of breaking the complex tables into much understandable smaller one to improve the optimzation of the database structure. The concept of "Fucntional Dependancy" is followed in Second Normal Form (2NF) which means ...
Latest Answer: aggregate fact tables have two types of keys-composite key-serrogate key (system generated key)So aggregate-key is a primary key ...
Latest Answer: You can use Bulk copy program (BCP) to convert a data from row to text or text to row ...
Latest Answer: Ans:Database returns an error message when a constraint is violated.Differnet type of constrains;1.Domain Constraints:A Domain constraint deals with one or more columns2.Entity Constraints3.Referential Integrity Constraints.4.Key Constraints 4.1.Primary ...
Latest Answer: Normalization : It is the process of decomposing a relation with anomalies into a well structured relation.Basic Terminology of Normalization:-Well-structured relation : A relation with minimum redundancy and no anomalies Anolamy : is an error during ...
Latest Answer: A transaction is a group of operations combined into a logical unit of work. Developer uses transactions to control and maintain the consistency and integrity of each action in a transaction, despite errors that might occur in the system BEGIN ...
Latest Answer: Rownum is the id which is assigned to recored, by the time of record set selected (executed).Rowid is, the id which is assigned physically to each record in table.RegadsSarele ...
Latest Answer: 1. Optimise DB performance ...
View page << Previous 5 6 7 8 [9] 10 Next >>
Go Top
