Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
define data conversionhelpful to load data into temporary staging tables then can write sql code to do much of data processing sql code is simpler
write the motivations led to development of oo-dbms1 programmer frustration with rdbmss2 requirement for special
q what are the major differences between capability lists and access listsanswer an access list is a list for each object consisting of the domains
q distinguish among a streams driver and a streams moduleanswer the streams driver controls the physical device that could be involved in a streams
q why is it important to scale up system bus and device speeds as the cpu speed increasesanswer consider a system which carries out 50 io and 50
q how does dma raise system concurrency how does it make difficult hardware designanswer dma increases system concurrency by allowing the cpu to
q polling for an io completion is able to waste a large number of cpu cycles if the processor iterates a busy-waiting loop several times before the
q why might a system utilize interrupt-driven io to manage a single serial port however polling io to manage a front-end processor such as a terminal
q the instance of handshaking used 2 bits a busy bit as well as a command-ready bit is it probable to implement this handshaking with only 1 bit if
q state three merits of placing functionality in a device controller rather than in the kernel and state three disadvantagesanswer three advantages
q presume that we agree that 1 kilobyte is 1024 bytes 1 megabyte is 10242 bytes and 1 gigabyte is 10243 bytes this progression carries on through
q it is occasionally said that tape is a sequential-access medium whereas magnetic disk is a random-access medium in fact the correctness of a
q if magnetic hard disks eventually have the same cost per gigabyte as do tapes will tapes turn into obsolete or will they still be needed describe
q in a disk jukebox what would be the result of having more open files than the number of drives in the jukeboxanswer two bad results could result
q remapping of bad blocks by sector sparing or else sector slipping could influence performance presume that the drive in subsequent exercise has a
q more than one disk drive is able to be attached to a scsi bus especially a fast wide scsi-ii bus can be connected to at most 15 disk drives
q the term fast wide scsi-ii signifies a scsi bus that operates at a data rate of 20 megabytes per second when it moves a packet of bytes among the
q is there any way to execute truly stable storage describe your answeranswer truly steady storage would never lose data the fundamental technique
q what are the tradeoffs concerned in rereading code pages from the file system versus using swap space to store themanswer if codes pages are
q why is it significant to balance file system io among the disks as well as controllers on a system in a multitasking environment answer a system
q how would utilize of a ram disk affect your selection of a disk-scheduling algorithm what factors would you require to consider do the similar
q why is rotational latency typically not considered in disk scheduling how would you alter sstf scan and c-scan to comprise latency
q describe why sstf scheduling tends to favour middle cylinders over the innermost and outermost cylindersanswer the middle of the disk is the
q is disk scheduling except fcfs scheduling useful in a single-user environment describe your answeranswer in a single-user environment the io queue
q the accelerating search for described in subsequent exercise is typical of hard-disk drives by contrast floppy disks and several hard disks