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 reasons for having variable length records? What are the various ways to store variable length records?
Variable-length records arise in a database in various ways:
(i)Storage of multiple items in a file. (ii)Record types allowing variable field size (iii)Record types allowing repeating fieldsVarious ways of storing variable length records:
(i) In fixed form through allocating every record, maximum amount of space in which can be occupied a record and padding smaller sized records along with nulls. (ii) Special separator characters among the records to delineate variable length records.
Explain pipelining. Ans: In order to describe pipelining in simple terms, think of it as breaking down processor functions into smaller and smaller parts. For instance,
What is a checkpoint? List the operations to be performed by the system when a checkpoint is to be taken. What does the recovery system do if there is a crash? There is large n
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? HAVING CLAUSE - HAVING CLAUSE is used only with SELECT statement. - It is normally used in a GROUP BY
WHAT IS DBMS
There are three main sources of utilities and applications for a DBMS: a. Vendor applications and utilities are given for working with or maintaining the database, and generally
Explain Candidate key? Candidate Key - A candidate key is a minimal superkey, that can be used to uniquely identify a tuple in the relation.
Write a query that display ename annual salary and comm from emp table
Examine about the Behavioural Diagrams The main objective of behavioural diagrams is to visualize, specify, construct and document dynamic aspects of a system. The interactio
The definition of the classes and operation can often be adjusted to increase the amount of inheritance". Justify the above statement. Adjustment of Inheritance The def
A B-tree of order how much children m has maximum ? m has maximum m mchildren in a B tree.
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