Describe perform recovery
Describe briefly perform recovery?
Expert
When Informatica Server starts a recovery session, it reads OPB_SRVR_RECOVERY table and notes the row ID of the last row committed to target database. The Informatica Server then reads overall sources again and starts processing from next row ID.
Illustrates the levels of data abstraction?
State the components of report studio?
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
Illustrate stored procedures, and how do they are distinct from triggers?
Illustrates the term Table Partitioning in detail? Answer: If you wish for to decrease page contention you do not require multiple devices. You should use multiple d
Explain about the Active and Passive Stage?
Illustrates the cold backup in case of Oracle?
Write down brief note on the issues for database performance?
Give a brief differentiation between metadata and data dictionary?
Illustrates the difference between a user’s defined function and a stored procedure?
18,76,764
1954854 Asked
3,689
Active Tutors
1420373
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!