Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
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
name the three major set of files on disk that compose a database in oraclethere are three main sets of files on disk that compose a database all the
what do you mean by correlated subquerysubqueries or nested queries are used to bring back a set of rows to be used by the parent query depending on
what is a phantom deadlock in distributed deadlock detection the delay in propagating local information might cause the deadlock detection algorithms
what do you mean by atomicity and aggregation atomicity either all actions are carried out or none are users should not have to worry about the
what is system catalog or catalog relation how is better known asa rdbms maintains a explanation of all the data that it contains information about
what are partial alternate artificial compound and natural keypartial key it is a set of attributes that can uniquely recognize weak entities and
what is functional dependency a functional dependency is shown by x y among two sets of attributes x and y that are subsets of r specifies a
what is normalizationit is a method of analysing the given relation schemas based on their functional dependencies fds and primary key to attain the
how does tuple-oriented relational calculus vary from domain-oriented relational calculusthe tuple-oriented calculus uses a tuple variables ie
what is dml data manipulation languagethis language that enable user to access or manipulate data as organised by appropriate data modelprocedural
what is data storagethe storage structures and access methods used by database system are specified by a set of explanation in a special type of ddl