Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
lt classquotnotranslatequot onmouseoverquottiponthisquot onmouseoutquottipoffquotgtlt classquotgoogle-src-text notranslatequot
what is the function of iom signal in the 8085it is a status signal it is used to differentiate among memory locations and io operations when this
what is an operandthe data on which the operation is to be performed is known as an
mention the purpose of sid and sod lines sid serial input data lineit is an input line by which the microprocessor accepts serial datasod serial
what are the functions of an accumulatorthe accumulator is the register associated with the alu operations and sometimes io operations it is an
describe queries with complex typesthe present extension of the sql query language deal with the complex typelet us start with the simple examplefind
what are the types of referenceexplain it with suitable examplesobject oriented language given the ability to refer the object attribute of the type
what is inheritance define it in detail inheritance inheritance can be at the levels of types or at the level of tables we first consider
explain nested relationsnested relationsthe assumption of inf is a natural one in the bank examples we have consideredhowever not all applications
write short notes on data ware housingdata ware housing applications needs the transformation of data from many sources into a cohesive reliable step
explain concurrency controlconcurrency controloracles multiversion concurrency control varies from the concurrency mechanism used by some other data
briefly describe concurrency executionlock - based protocolslocksthere are several modes in which a data item may be locked in this section we
write short notes on transaction statea transaction may not always complete its implementation successfully such a transaction is termed aborteda
what is serializability explain its typesthe data base system must control concurrent implementation of transactions to ensure that the data base
describe log based recoverythe most usably structure for recording data base modification is the log the log is a sequence of log records recording
what is magnetic disksexplain itmagnetic disk provides the bulk of secondary storage of modern computer system the disk capacity is growing at over
explain hash file organizationhash functionsa the distribution is uniformhash functions assign each bucket the similar number of search -key values
write short notes on index structure of filesthere are two basic parts of indices1 ordered indices2 hash indicesevery technique must
define raid briefly explain ita range of disk organization methods collectively called redundant arrays of independent disks raido
describe file organisationa file is organized logically as a sequence of records these records are mapped onto disk blocksa fixed-length recordstype
explain mechanism of nested queriessql gives a mechanism for nesting subqueries a subquery is a select from where expression that is nested within
what is data definition language explain it in detailthe sql ddl allows specification of not only a set of relations but also information after each
what is aggregate function briefly describe itaggregate functions are functions that take a collection of values as input and return a one value sql
describe integrity and securitya domain constraintb referential integritya value that appears in one relation
what are data models explain it detailentity relationship model rectanglesellipsediamondslinesrelational model relational model use a collection of