Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
what is project managementapplying the knowledge skills techniques tools in project and deliver project deliverable is a short definition of the
i need help on java homework is it possible to know the shortest possible time to get the solution before giving my
what is the difference between dataset and datareaderthe major differences between dataset and datareader are as follows-1the dataset is a
how can we load multiple tables in a datasetobjcommandcommandtext table1 objdataadapterfillobjdataset table1 objcommandcommandtext table2
whats difference between optimistic and pessimistic lockingin the pessimistic locking when user wants to update a data it locks the record and till
how can we add relations between table in a datasetdim objrelation as datarelation objrelationnew
what are the ways to implement locking in adonetthere are many ways to implement locking using adonet which are shown below-1whenever we call update
how can we perform transactions in netthe common sequence of steps that would be performed for developing a transactional application is as
explain the difference between an adonet dataset and an ado recordsetthe two main basic differences between recordset and dataset are as shown below
what is denormalizationthe denormalization is the process of putting one fact in numerous places ie the vice-versa of normalization only one valid
what is a candidate keya table may have more than one combination of columns that could uniquely identify the rows in a table every combination is a
what are the different types of joins1 inner jointhe inner join shows matches only when they exist in both the tablesfor example in the sql below
what are indexesthe indexes in the sql server are similar to the indexes in books they help sql server to retrieve the data quicklythese are
how can you increase sql performance1keep your indexes as narrow as possible this reduces the size of the index and decrease the number of reads
what is fill factorthe fill factor option describes how full sql server will make each index page when there is no free space to insert a new row on
what is raid and how does it workthe redundant array of independent disks raid is a term used for describing the technique of improving data
what is the difference between delete table and truncate table commandsfollowing are differences between delete amp truncate commands-1the delete
what are the problems that can occur if you do not implement locking properly in sql serverthe problems that occur if you do not implement locking
what are different transaction levels in sql serverthe transaction isolation level decides how is the one process isolated from theother process
what are the different locks in sql serverdepending on the transaction level there are six types of lock that can be acquired on data -1intentthe
what is lock escalationthe lock escalation is the process of converting of the low level locks such as row locks page locks into the higher level
what are advantages of sql 2000 over sql 701user-defined functions the user-defined functions udfs -- one or moretransact-sql statements may be used
how can you raise custom errors from stored procedurethe raiserror statements are used to produce an ad hoc error message or to retrieve acustom
what is acid fundamental what are transactions in sql serverthe transaction is a sequence of operations performed as a single logical unit of workthe
what are the different types of replication supported by sql serverthere are 3 types of replication supported by sql server which are shown