Latest Answer: Oracle is ORDBMS (Object Oriented Relational DataBase) while Access is RDBMS(Relational DataBase) only. ...
What is the difference among "dropping a tableâ€,†truncating a table" and deleting all records" from a table?
Latest Answer: VARCHAR is used to store alphanumeric values without padding unused memory locations. But VARCHAR2 is used to store alphanumeric values with padding unused memory locations. so using VARCHAR2 we are saving memory locations. ...
Latest Answer: View is a logical partition of one or more table in horizontally(by putting condition) or vertically (by including selected columns). View can be used to update table, provides security mechanism. view defionition(qurey) stored as ...
Latest Answer: Hints are options or strategies specified for enforcement by the SQL Server 2005 query processor on SELECT, INSERT, UPDATE, or DELETE statements. The hints override any execution plan the query optimizer might select for a query. ...
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: Trigger is a self executing event in sql server where a relevent action is occured.triggers are useful in master-child relation ship in a table.Trigger can be created as,create trigger triggername on tablename for insert,update,delete as "necessory ...
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 ...
View page << Previous 4 5 6 7 [8] 9 10 Next >>
Go Top
