Data query and knowledge query
Write down some of the differences between the data query and the knowledge query.
Expert
A data query determines the real data resides within the database and corresponds to the basic retrieval statement within the database system.
A knowledge query determines the rules, patterns and other types of knowledge within the database and corresponds to the querying database knowledge involving the deduction rules, generalized rules, integrity constraints, frequent patterns and several other regularities.
Explain the following terms: Proactive, Retroactive and immediate Update.
explain binary relationship set and terenary relationship set
Briefly explain SQL Server 2005 Business Intelligence components?
What do you understand by the term locking in DBMS?
Write a brief note on the differences between a data warehouse and data mart?
What are the utilities Oracle gives, which are utilize for backup and recovery?
States the term Volatile temporary tables.
Illustrates the purposes of a key component in SQL Server Integration Services (SSIS)?
Specify the use of data stage designer?
Explain the term Coalesce. Answer: Coalesce is also obtainable in Sybase, this function estimates the listed expressions and returns the first non-null value.
18,76,764
1960795 Asked
3,689
Active Tutors
1422920
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!