Data and database administration
Write a brief note on the difference between data and database administration?
Expert
Data administration is Amenable for the overall management of data resources. Some of the core roles include the formation of data policies, standards and procedures, solve data ownership issues, and handle the information repository. Database administration is the oversight of the physical database. Some of the core duties comprise the selection of the software tools and DBMS, the upgrade and installation of the DBMS, and database performance tuning.
Write a short note on the difference between embedded and dynamic SQL?
Specify the enhancements which are made within datastage 7.5 and also compare with the 7.0?
Explain about the Buffer Manager in relational database management system.
Explain the following term: a) ROLAP b) MOLAP
Write down the employ of incremental aggregation?
Briefly describe the differentiation between star and snowflake schemas?
Explain the object qualification?
Explain the term queue in data structure? Answer: In data structure a queue is a sequential organization of data. It is a first in first out i.e. FIFO type of data s
Describe any two reasons which show the necessity of database redesign?
Explain the operations that can be done with the Data Stage Director?
18,76,764
1945300 Asked
3,689
Active Tutors
1452263
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!