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.
What is the meaning of Data independence? Data independence means a programs that are not dependent on the physical attributes of data and a programs that are not dependent on
Define upgrade and downgrade? It gives a mechanism for conversion from shared lock to exclusive lock is called as upgrade. It gives a mechanism for conversion from exclusive
1.Why we need data mining? Give an example to illustrate your answer. 2. Why data mining is considered as "misleading name"? 3. Distinguish the difference between database an
Explain the Cartesian product: The Cartesian product operation does not need relations to union-compatible. The meaning of this is that the involved relations may have dissim
Creating views with Read only option : In the view definition this option is used to make sure that no DML operations can be done on the view.
Control as Concurrent Tasks The expression control as simultaneous task means applying control for those events of object which can happen simultaneously. An object can be imp
3NF Normal Form A relation schema R is in 3NF if it is in 2NF and for each FD X A either of the following is true X is a Super-key of R. A is a prime attribute of R
Multiple column Queries: Syntax: SELECT COLUMN1, COL2,...... FROM TABLE WHERE (COLUMN1, COL2, ...) IN (SELECT COLUMN1, COL2,.... FROM TABLE WHERE );
Explain Authorization and Integrity Manager ? Authorization and Integrity Manager: Tests for the satisfaction of integrity constraints and checks the authority of users to acce
describe objectivde of file organisation
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