This is my little test, only for new DBA'swho have OCP and not more than 2 years experience
Each question counts for 20% of the mark, I will post answer later.
No book checking, and no people asking, I want to see how many people can get 80% or more correct
------------------------------------------------------------------------------------------------------
You are called by your customer to solve their database problems, you know nothing about their database.
1. Your customer's database suddenly hangs, while all the processes are still running,and nothing you can find in alert.log.
What are the first things you will check ?
2. The customer is using a self build webpage to monitor ifdatabases and listeners are running by TNSPING the databases.
Suddendly you get calls from users complaining that they can't connect to a database, you open the monitoring webpage,
and it shows that the database is running, you tnsping the database, it shows ok. What is going on ?
3. A user need your help with debugging a batch job which runs slow. The database is running ok,
it's just this batch that is slow. The source code of the batch job is not available becuase it is a binary file that belongs to a thrid party. What do you need to do to find out what this batch job is doing ?
4. Your customer ask you to check a table on a production database, he want to know how big it is,
how many rows it has etc. You log on, do 'select count(*) from table ..' ,and you notice that the customer's face
is changing color, and you notice that nothing is happening in your session for 15 minutes, you are wondering...what is wrong ?
5. You are trying to configure the backup of a new database, the customer created this database by copying
all files from another database A and renamed it to B. The customer is uing rman with a centralized catalog,
in the catalog database there is a schema called rman that owns the catalog. When you want to use this catalog for database B, what do you need to do ? do you expect any trouble,
if yes, why ? How can you solve the trouble ?
|