Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
An employee record has the following structure struct employee { int eno; char name[22]; float salary; char dept[10];};(i) Calculate the record size R in bytes.(ii) If the file has 500 records, calculate the blocking factor bfr and the number of blocks b, assuming an unspanned organization with block size B = 512 bytes.(iii) Describe the unused space in each block and in the last block?
Ans: (i) 2 + 22+ 4 + 10 =38 bytes (ii) bfr = floor( B/R) = [512/38] =13 Number of blocks b = ceiling (500/13) =39 (iii) Unused space in each block = 512 - 38 *13 = 512 - 494= 18 bytes Unused space in the last block = ( 39 *13 - 500) * 38 bytes = (507 -500) * 38 bytes = 7 * 38 =266 bytes
Explain the Recoverable Schedule A recoverable schedule is one in which for each pair of transactions Ti and Tj such that Tj reads a data item formerly written by Ti, the comm
In a Hierarchical model of data records are organized ? In the hierarchical model of data records are organized as Tree structure.
lock and types of lock
What is a B+-Tree index? A B+-Tree index takes the form of a balanced tree in which each path from the root of the root of the root of the tree to a leaf of the tree is of the
Question : (a) Data mining is one of the best ways to analyse data and using software method, hidden and unexpected patterns and relationships in sets of data can be extracte
What are the disadvantages of file processing system? The drawbacks of file processing systems are a) Data redundancy and inconsistency b) Complexity in accessing data
Write an sql statement to find what is the percentage of home policies which are from the state of Arizona out of all Home policies by Policy Value.
A relationship set is a set of relationships of the similar type. For example, let consider the relationship among two entities sets course and student. Collection of all the in
vertical fragmentation
Explain the Fundamental concepts of object-orientation Software developers, data base administrators (DBAs) need to be familiar with fundamental concepts of object-orientation.
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd