Types of Strategies
Specify the several types of Strategies?
Expert
In Designer we may specify the two types of strategies:
a) External strategies
b) Built–in strategies
Built–in Strategies : Designer offers a number of default strategies that we may use. These are the strategies in order to extract the joins, detecting the cardinalities, and producing the default classes and objects. Options in order to indicate the default strategies are situated in the Database tab of the Options dialog box.
External Strategies : We may also produce our own strategies. These strategies are considered as the external strategies. Along with the external strategy, we may describe the exact way that objects and joins need to be extracted from database structure. The external strategy is generally specific to one RDBMS.
Explain what is meant by the Drill up/down/by/through?
Specify the user profiles within the Supervisor?
Illustrates the term bucket size, while the overlapping and collision arise at same time? Answer: Bucket size is one. When there is only one entry possible in the bu
Explain about the Data Storage Definition Language?
What do you mean by optimization and performance tuning and explain how does it actually work in the practical projects?
Under what conditions should indexes are employed?
What do you understand by the term foreign key in DBMS, and why is it employed for?
Explain what are the roles performed by the SQL?
Explain the following terms: Proactive, Retroactive and immediate Update.
Illustrates the way to save space while inserting rows monotonically?
18,76,764
1956158 Asked
3,689
Active Tutors
1417185
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!