Questions
For a database administrator, describe the importance of database alerts
The alerts are very important to the database administrator because they help them get information regarding the events that may diversely impact the database in one way or another. They help the database administrator to respond to the issues as quickly as possible before any damage can take place (Basta & Zgola, 2011). Alerts come from all the internal errors, block corruption errors and deadlock errors that may be disastrous to the database. So the alerts help the database administrator to respond to them promptly before the effect of the error can escalate.
Describe the importance of reviewing the database logs to determine errors
At the heart of many devices that offer protection for the information technology, networks is an ability to log the events and actions so that remediation actions can be taken as appropriate (Horwath, 2012). The database logs errors to help the database administrator to review them and take any appropriate responses as per the error. It is essential for the database administrator to review the database error logs to determine the error so that he/she can take defensive measures before any real damage occurs (Murphy, 2015). Without the review of those database logs, the database administrator has little chances of knowing whether a live application has been compromised or is being attacked.
Compare the advantages of using a Database creation tool or using a script to create a database
Creating a database using a database creation tool or a script has many advantages, for instance, one can use the DBCA wizards to get direction in the selection of options offering an easy means of creation and tailoring of the database (Oracle Corporation, 2002). The database creator only supplies a minimum of input, and the tool makes decisions for them, eliminating the need to spend much time in deciding how to set parameters or how best to structure the database. The use of a tool also helps the database creator to be very specific concerning the file allocations and settings. The database creation using a script helps to decide the services required at the start.
Describe the basic database administrator responsibilities
The database administrator responsibilities revolve around three major activities: maintenance of the production database; planning, designing and making changes to the existing applications; and the management of a company’s data and the metadata (Connolly & Carolyn, 2004). The database administrator should also create policies and procedures regarding the database management, security, and the use of the database. A database administrator should also carry out general technical troubleshooting as he/she also provides consultation to the development teams (Blaha, 2001).
Describe Oracle tablespace (default tablespace, Bigfile, Smallville)
Oracle tablespace are the logical units in Oracle database that are used to store the entire database’s data. Each of those logical units/tablespaces consists of one or more data files that are physical structures that are specific to the operating system that Oracle database is running in. There are Bigfile tablespace and small file tablespace whereby the Bigfile tablespace comprises of a single datafile or a single temp file and the small file tablespace consists of several temp file of data files that can amount up to 1022 (Powell, 2007). A Bigfile tablespace comprises of a repository of if all the information in a single file whereas the small file tablespace has the same information contained in several files.
Describe the benefit of the Oracle client/server architecture
The client applications do not have to perform any data processing. Those applications only concentrate on the input requests from users or the server and then analyzing that data appropriately so that they can present it through display capabilities of the client node Luz, T. (1990).
The client/server architecture helps Oracle RDMS to exploit the multitasking as well as the shared memory facilities of the underlying operating system. Consequently, that offers the highest degree of data integrity, concurrency, and performance to the clients.
In this architecture, it is possible to optimize the terminals or client workstations for the presentation of data while the server can also be optimized to process and store data.
In the case of networked environments, the shared data can have placement on the servers instead of the workstations so that it will be easier and efficient to manage its concurrent access.