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!
What are the Constituents of File? Also elaborates all the possible file operations?
A file is organised logically as sequence of record. These records are mapped onto disk blocks. Although blocks are of fixed size denoted through the physical properties of the disk and through the operating system, record sizes vary. In a relational database, tuples of distinct relations are commonly of different sizes.
Possible operations on a file: (i) Create: a file can be created (ii) Delete: a file can be deleted (iii) Changing attributes of a file: The attributes of a file say read only, author's name etc. can be changed. (iv) Contents of the file can be altered.
Normal 0 false false false EN-US X-NONE X-NONE
What is object identity? An object retains its identity even if some or all the values of variables or explanations of methods change overtime.
Attributes having a one value for a particular entity. For instance, Age is a single valued attribute of a student entity. Attributes that have more than single values
What is meant by buffer blocks and disk buffer The blocks residing temporarily in main memory are referred to as buffer blocks. The area of memory where blocks reside t
How can you map NULL values to other values while display? IF( ) , IFNULL( ) keywords are used to do so. They are 'LIMIT' is used for the following kinds of problems: 1) Ans
What is transaction? Transaction is a unit of program implementation that accesses and possibly updated several data items.
Two-way Associations Mostly, associations are travel in both directions, although not usually with same frequency. There are three approaches for the implementation. In
explain exhaustively the problems associated with ER diagrams. include illustrations in your answer
Heap files (unordered file) Mostly these files are unordered files. It is the easiest and most basic type. These files having of randomly ordered records. The records will have
In the architecture of a database system which external level used? In the architecture of a database system view external level used.
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd