Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
what is the difference between tftp and ftp application layer protocols the trivial file transfer protocol tftp allows a local host to obtain files
what is difference between arp and rarpthe address resolution protocol arp is used to associate the 32 bit ip address with the 48 bit physical
what are the data units at dissimilar layers of the tcp ip protocol suitethe data unit formed at the application layer is called a message at the
what is the different type of networking internetworking devices1 repeater also known as a regenerator it is an electronic device that operates only
describe domain constraintsdomain constraints contain entity integrity and referential integrity the domain is a set of values that might be assigned
explain the systems development life cyclethis is the traditional method to develop maintain and replace information systems that contains the
explain the differences between structured data and unstructured datastructured data are facts concerning objects and events the most significant
what is olaponline analytical processing olap is a business intelligence bi reporting system olap gives the user with the capability to sum count
what is a dataseta dataset is an in-memory database that is disconnected from any regular database but has all the significant characteristics of a
what disadvantage of odbc does ole db overcomeby breaking the features and the methods of a dbms into com objects ole db characteristic overcomes a
what are the three types of data sources used with odbcan odbc file data source is a file that can be shared between database users an odbc system
what is the difference between sql server 2000 clustered and nonclustered indexeswith a clustered index the data are kept in the bottom level of the
what is the difference between sql server 2000 complete and differential backupsa complete backup makes a copy of the whole database a differential
what is deadlock how can it be avoided how can it be resolved once it occursdeadlock happens when two transactions are each waiting on a resource
explain the difference between optimistic locking and pessimistic lockingoptimistic locking supposes no transaction conflict will occur and deals
why is database redesign necessarydatabase redesign is essential for two reasons first redesign is essential both to fix mistakes made during the
what is a cascading updatereferential integrity constraints needs that foreign key values in one table correspond to primary key values in another if
what is a recursive relationship give an example not used in the texta recursive relationship is a relationship among an entity and itself for
what is the archtetypeinstance patternthe archetypeinstance pattern happens when one entity tracks occurrences of another entity a common example is
what is a foreign key and what is it used fora foreign key is used to establish relationships between relations in the relational model technically a
what is sql and why is it importantsql stands for structured query language and is the most significant data processing language in use today it is
what is enterprise resource planning erp and what kind of a database is used in an erp applicationenterprise resource planning erp is an information
what are stand-alone proceduresprocedures that are not part of a package are called as stand-alone because they independently defined a good example
what are stored-procedures and what are the advantages of using themstored procedures are database objects that perform a user defined operation a
what is database triggera database trigger is a plsql block that can explained to automatically execute for insert update and delete statements