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!
Data Base Management System
1. Draw the Architecture of MySQL and explain about its subsystems briefly.
2. Elaborate with the help of an example the concept of Primary key and foreign key in Relational Database management system.
3. Explain View? With an example, use the format of view statement to create view.
4. What types of anomalies are found in relational database? Explain briefly.
5. Explain the three phases that a query passes through during the DBMS processing of that query? Explain briefly.
6. Write down the advantages of Advantages of Object Oriented Database Management.
Question: (a) Discuss the difference between a composite key and a composite attribute. How would each be indicated in an E-R diagram? Support your answer with appropriate exam
Data Definition Language It organises the data in the form of columns and rows. But what does the data field column of table accumulate? How do you describe it using SQL? Th
Benefits of Sequential File Organisation It is quick and efficient when dealing with huge volumes of data that require being processed periodically (batch system). Dra
When is a transaction rolled back? Any changes that the aborted transaction made to the database must be uncompleted. While the changes caused by an aborted transaction have be
how oracle can be used
Describe an data dictionary? A data dictionary is a data structure which keeps meta data about the structure of the database ie. the schema of the database.
What is bucket overflow and how bucket overflow is handled through Over Flow Chaining or Closed Hashing? Ans: Bucket: unit of storage holding records. Bucket is a disk block
how to implement mid square hashing?
A model in database system mostly defines the organisation of data or structure and a set of operations on that data. Relational model is a easy model in which database is represen
What are audit trails? An audit trail is a log of all alters to the database along with information like which user performed the change and when the alter was performed.
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