Skip to content

New Oracle DBA – Top 50 DBA terminologies to know

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.

You can easily search for the answers as there are numerous good websites to provide detailed information.

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
unix server?

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
10g?

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
processes?

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
delete them?

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
these tools?

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
,procedure etc?

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
tuning?

46)what is a tkprof tool? what is sql trace?what is the purpose of sql trace?
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.

 

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Post a Comment

You must be logged in to post a comment.