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's the difference between a primary key and a unique key?
Both primary key and unique key enforces uniqueness of the column on which they are explained. But by default primary key creates a clustered index on the column, where are unique makes a no clustered index by default. Another main difference is that, primary key doesn't permit NULLs, but unique key permits one NULL only.
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
Write short notes on data ware housing? Data ware housing applications needs the transformation of data from many sources into a cohesive reliable step set of data configured a
To delete a particular column in a relation which command is used ? To delete a particular column in a relation ALTER command is used.
The First Normal Form (1NF) Let us first describe 1NF: Definition: A relation (table) is in 1NF if 1. There are no duplicate tuples or rows in the relation. 2.
what are the limitations of dbms?
explain thee diffrent types of data models
how can apply joins on table
Attributes and its types explain?
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
define anomalies and different types of anomalies with example
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