Dba Sure Success Guide: A Free Ebook From
Dba Sure Success Guide: A Free Ebook From
Dba Sure Success Guide: A Free Ebook From
GUIDE
Srinimf.com
Education Series
Free to share your friends and who need help
A FREE EBOOK FROM SRINIMF.COM
1
1
2
Table of Contents
About this e-book.............................................................................................. 3
DBA real time job responsibilities ..................................................................... 4
Database adminstrator roles ......................................................................... 4
Orcle DBA responsibilities ................................................................................. 6
Oracle DBA roles ............................................................................................ 6
TOP five DB2 DBA critical functions .................................................................. 8
Critical functions ............................................................................................ 8
2
3
The roles and responsibilities are so criticle. So before start your journey take a
look of all the points given to do your job well.
A Free education series. You can share this e-book to your friends and who
need help.
3
4
DB2 has many in-built security features and are most popular. The following
security problems DB2 can handle. The below list is for your quick note:
• Authentication
• Authorization
• Data integrity
• Confidentiality
• System integrity
• Audit
“The trace can record changes in authorization IDs for a security audit as well
as changes made to the structure of data (e.g., dropping a table) or to data
values (e.g., updating or inserting records) for an audit of data access.
You can also use the audit trace to track access attempts by unauthorized IDs,
the results of GRANT and REVOKE statements, the mapping of Kerberos
security tickets to RACF IDs, and other activities of interest to auditors.”
Only a user with SYSADM authority can perform the following functions:
• Upgrade a database
4
5
• Restore a database
• Change the database manager configuration file (including specifying the
groups having SYSADM, SYSCTRL, SYSMAINT, or SYSMON authority)
With the system DBADM authority, you can issue SQL statements to perform
the following tasks:
A user with the DBMAINT authority can grant the privileges on a specific
database to an ID. With the DBMAINT authority, that user can perform the
following actions within that database:
• Create objects
• Run utilities that don’t change data
• Issue commands
• Terminate all utilities on the database except DIAGNOSE, REPORT, and
STOSPACE
5
6
If a user has the DBMAINT authority with the GRANT option, that user can
grant those privileges to others.
A user with the SYSOPR authority can issue all DB2® commands except
ARCHIVE LOG, START DATABASE, STOP DATABASE, and RECOVER BSDS.
1. Evaluate the Database Server Hardware: Evaluate how Oracle and its
applications can best use the available computer resources. This
evaluation should reveal the following information:
• How many disk drives are available to Oracle and its databases
6
7
7
8
8
9
iii. The reasons to data loss are – User error, Logical error and
Process failure
5. Why is performance tuning of a database important?
A. The below are awesome reasons
i. Poor database design
ii. Growth of database size
iii. Change in requirements
9
10
References
1. The role of administrator from computer weekly – Read here
2. DBA roles and responsibilities from Srinimf – Read here
3. Database administrator or DBA roles from Wiki – Read here
10