Describe the term data constraints
Briefly define and describe the term data constraints?
Expert
In a column the data constraints are the limits which are put on the values that the data can have.
There are four types of data constraints which are as follows:
(i) Domain constraints: This defines a limited setup of values for the column.
(ii) Range constraints: This specify that the values must fall in a certain range.
(iii) Intra relation constraints: This defines what values the column can have based on values of other columns in the same table.
(iv) Interrelation constraints: This defines values the column can have based on values of columns in other tables.
Write about the term Data stage architecture?
Name the Applications of tree data-structure?
Illustrate the term indexing. Specify the kinds of the indexing.
What do you understand by the term snapshot replication in DBMS?
Describe the process that takes place to execute a stored routine.
Briefly describe time series algorithm in data mining?
Describe the inconsistent values problem? Comprise an appropriate example?
Elucidate Where to keep informatica rejected data? How to remove the informatica rejected data?
Specify the types of dimensions which are available in the Informatica?
Write down the brief note on the differentiations between Normalizer and Normalizer transformation?
18,76,764
1936229 Asked
3,689
Active Tutors
1450477
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!