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!
Describe the algorithm for updating indices for a single level index when a record is
(i) Inserted (ii) deleted
What will be the modification if there are multilevel indices?
Ans: Inserted: The time it acquires to insert a new data item. This value involves the time it takes to find out the correct place to insert the new data item, also the time it takes to update the index structure.
Deleted: The time it receives to delete a data item. This value involves the time it takes to find the item to be deleted, also the time it takes to update the index structure.
Why are cursors necessary in embedded SQL? A cursor is an object used to store the output of a query for row-by-row processing through the application programs. SQL statements
Define weak and strong entity sets? Weak entity set: entity set that do not have key attribute of their own are known as weak entity sets. Strong entity set: Entity set that
What is first normal form? The domain of attribute must contain only atomic (simple, indivisible) values.
List and also explain the dissimilar stages of DDLC ?
There are two major types of fragmentation: Horizontal& Vertical. Horizontal fragments, as the name suggests are subsets of tuples and vertical fragments are subsets of attributes
What are the different kinds of database end users? Discuss the major activities of each? End-Users - End-users are the people whose jobs need access to the database for que
Describe the advantage of State chart Diagram A state chart represents a state machine, emphasizing flow of control from one state to other. A state machine is a behaviour whi
What is the difference between serial and sequential files? How searching is applied on both? Ans: A serial file is one where the records have been stored in the order where
Question A What is operational intelligence? Question B What is Business Intelligence? Explain the components of BI architecture Question C Differentiate between databas
Define the Boyce-Codd Normal Form with instance and also Compare BCNF and 3NF. Ans: BCNF: For each functional dependency X->Y in a set F of functional dependencies over relati
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