What are the duties of a DBA?
What will be an ideal response?
A Database Administrator is responsible for installing Oracle database, managing day-to-day
needs of the complex database, and running the system at peak performance. A DBA performs
software maintenance, resource management, data administration, database tuning, and
troubleshooting, data security, and backup and recovery. Some of the duties performed by the
DBA are
? Install and upgrade Oracle and its tools
? Configure the Oracle instance
? Create a database
? Create, alter, and remove database users and roles
? Grant and restrict access rights
? Allocate and manage physical and logical storage structures
? Develop security strategies
? Develop backup and recovery procedures
? Monitor system performance
? Analyze database performance and implement solutions to problems
? Communicate with Oracle support service personnel
? Troubleshoot locking problems
In short, the DBA is the most trusted user in the database environment. The DBA must
possess a thorough knowledge of the operating system Oracle is installed on, the hardware
specifications needed for the server and the clients, the memory structures and Oracle
processes, PL/SQL modules and their behavior in the system, client-server architecture, and
networking-related issues.
You might also like to view...
In the context of the IEEE 802.1d specification of the spanning tree protocol, define the following terms:
What will be an ideal response?
What is an in-order traversal of binary search trees?
a. It is a way of traversing each element of the tree in the following order: left -> root -> right, starting from the root node b. It is a way of traversing each element of the tree in the following order: root -> left -> right, starting from the root node c. It is a way of traversing each element of the tree in the following order: left -> right -> root, starting from the root node d. None of the above
Caching is a strategy to use when you want to exclude a particular file from being uploaded to a server.
Answer the following statement true (T) or false (F)
You just learned that a car patrolling your neighborhood is scanning the wireless signals coming from homes. What is this called?
A) Salami attack B) Social engineering C) War driving D) Data diddling