Ways to suggest the dba, Database Management System

a)  Suppose we updated the catalog tables in real time, that is, after every update, insert, or delete SQL statement were executed-rather than only running RUNSTATS once every few days or longer.

Is this idea (real time updates), a good idea?   Provide arguments both for and against.

b)  Suppose the DBMS kept track of how long it took to execute each SQL statement:  i.e., for every single SELECT, INSERT, UPDATE, and DELETE statement.  Explain how the database system could use this information in some meaningful and practical ways to suggest to the DBA when it is time to reorganize the tables and indexes (or for the DBA to take other action). 

c)  When should a DBA consider dropping indexes from a table?  Give at least 3 good reasons.

Posted Date: 3/7/2013 4:42:05 AM | Location : United States







Related Discussions:- Ways to suggest the dba, Assignment Help, Ask Question on Ways to suggest the dba, Get Answer, Expert's Help, Ways to suggest the dba Discussions

Write discussion on Ways to suggest the dba
Your posts are moderated
Related Questions
What is called an evaluation primitive? A relational algebra operation annotated with instructions on how to evaluate is known as an evaluation primitive.

What is data definition language? Explain it in detail? The SQL DDL allows specification of not only a set of relations, but also information after each relation, containing

Describe the GRANT function and explain, how it associates to security. What kind of privileges may be granted? How are they revoked? Ans: Since more than one user can aacce

Describe about Object oriented design Object oriented design is concerned with developing an object oriented model of a software system to implement known requirements. Many OO

Function requirement as given: 1> manage fans and likes and followings those information from facebook. twitter. google+ and linkedin etc 2> Organize the clients from email m

In a relational model how relations are termed? In a relational model, relations are termed as tables. (The term ‘relation’ is the technical name of the ‘table’ in RDBMS)

QUESTION (a) Give two advantages of using Linked List as compared to arrays. (b) (i) You are working as programmer at the Orange Mauritius branch. You have been asked to cre

What is SQL, and why is it important? SQL stands for Structured Query Language, and is the most significant data processing language in use today. It is not a complete programm

System error :These contain errors in database system or the OS, example, deadlocks.Such errors are fairly hard to detect and need reprogramming the erroneous components of the sys

What is meant by Physical blocks? The input and output operations are completed in block units. The blocks residing on the disk are referred to as physical blocks.