50 DBA Terms for the New DBA
****Summary of How this page can help you******************
This page contains 50 terminologies that you should learn and become knowledgeable to be
confident on performing your Job as a New DBA.
To go back to the DBA career shift home page click dbacareershift
Well, you now know that you should learn SQL, PL/SQL to make a good start to your DBA
career.We will assume that you already spent good amount of time to get a considerable grip on
SQL and pl/sql. Now welcome into the DBA world.
Now as a beginner if you search in Google you would find hundreds of websites giving lot of
excellent information about different DBA concepts.
You are bound to get confused by looking at the huge amount of information. Here we try to give
you guidance about a list of 50 terms that you should study and understand before you even want
to consider yourself as a junior DBA. We will order the terms to help you gradually learn more. As
time permits we will also provide the answers.Some of the answers are already provided.please
click on the links below.Regarding other questions for the time being please google and find out the
1)What are the responsibilities of a DBA on a typical working day?
2)Which tools does a DBA need to carry out his tasks?
3)10 functionalities in each tool that you identified in step 2, that you should know in order to
perform your duties as a DBA.
4)connecting to a database on a Unix server using sqlplus.
5)connecting to a database on a Windows server using sqlplus.
6)starting a database.
7)shutting down a database.
8)What is a listener? How to start and stop a listener?How to find out the status of a listener?
9)What is a Port?
10)What are the uses of tnsnames.ora , sqlnet.ora, listener.ora files? Where should they be located
on a server?
11)Which components are required for a client to connect to a database?
12)What is Oracle Client? What is Oracle Server? Where should they be installed and what is the
difference between them?
13)How many different versions of a Oracle database exists at the moment?Which versions are
used most?Which is the latest version?
14)How do you find out if a database is already running/active on a Unix server?
15)What is oracle enterprise manager?
16)What are Oracle patches and which tools do you use to Patch a Oracle database?why should
you patch a Oracle database?where do you get the patches?
17)What are the 20 unix commands you should know to work on a oracle database which is on a
18)What is a backup ? Which is the well known Oracle backup tool?
19)In the oracle website , where do you find all the DBA Documentation for the versions 9i and
20)What is a SGA?
21)What is the difference between a database and Instance in oracle?What is a schema ? What is
the difference between a schema and user in Oracle?
22)What is block, extent, segment , datafile , tablespace , redolog , archive log , controlfile , undo
file , rollback segment?
23)what are the various background processes in an oracle database?What is the purpose of each
background process? When do the background processes get created?
24)What is a user process? What is a server process ? what is the difference between the two
25)Which components do you need for starting a oracle database?
26)What is a pfile?What is a spfile? what is the difference between them?How do you create and
27)What is an Oracle home?
28)What is an alert log? How is it created?what happens if the alert log is deleted?
29)What is a .profile file on a unix server and what is the purpose of it?
30)What is a password file ?
31)what is a sysdba privilege in oracle?
32)What is a data dictionary view in an oracle database? In which oracle document do you find
information about all the data dictionary views?
33)What is a crontab on a unix server and what is the purpose of it?How do you schedule shell
scripts using Crontab ?
34)what is a export tool in oracle? What is an import tool in oracle? what is the purpose of both
35)What is a table, sequence , view , profile , role , index , procedure , function , package , trigger
, dblink , materialized view , synonym , constraint , primary key , foreign key , unique key , grant ,
revoke , sqlloader in oracle ?
36) What is a Job in oracle?
37)which dictionary tables do you check to find out the version of a database ? to find out if the
database instance is online? to find out if the database is open?
38)what are the different stages a database can be from the time it initially starts until the time it is
completely open?what is meant by nomount? mount? open? resetlogs?
39)What is a buffer cache? shared pool? library cache ? data dictionary cache? log buffer? large
pool? java pool? pga ?
40)What is a cold backup? what is a hot backup? what is the commonly used method to do a cold
backup ?what is the commonly used methos to take a hot backup?what is the purpose of doing a
cold backup or a hot backup?
41)What is meant by database backup? What do you mean by a database restore?Which tool do
you use to restore a database?
42)How do you create a oracle instance ? how do you create a oracle database ?
43)how do you create a control file ? create a datafile ? create a user? create a redo log? create a
archived log? create a tablespace ? create a profile? change a users password ? change a datafile
size? change tablespace size? change undo tablespace size? create a table , view , sequence
44)what is bdump directory? cdump directory? udump directory?
45)what is statspack? what is performance tuning in oracle and what is the purpose of performance
46)what is a tkprof tool? what is sql trace?what is the purpose of sql trace?
47)what is an explain plan? what is a plan_table and how is it created? what is an optimizer ?what
is optimizer mode ? what are statistics and why do statistics need to be collected for all tables and
indexes in an oracle database?
48)what is block corruption ? which tool do you use to check block corruption in a datafile?
49)what is a recovery catalogue?
50)can you have multiple databases in a single server? what factors should be take into account
before we decide to put a new database into a unix server?What is the impact of the server RAM ,
disk space , CPU on a oracle database?
To go to the next section please click Unix Commands for the new dba