Who is dba in dbms?

398

What is your favorite tool for day-to-day oracle operation?

353

How can you determine if an index needs to be dropped and rebuilt?

404

You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?

623

You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?

377

What is the dba role in oracle?

396

What happens if a tablespace clause is left off of a primary key constraint clause?

403

What is a database instance?

396

What are the different types of database users?

384

You see a wait on lms process in statspack, what does that mean?

399

What do you understand by the term 'system change number (scn)'?

415

What are the types of locks in database?

410

What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?

435

What happens when the default and temp tablespace clauses are left out from create user statements?

408

What is the finger command?

407