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

406

What does database administrator do?

368

What are the five functions of a database?

413

I am getting error "no communication channel" after changing the domain name? What is the solution?

407

Which date function is used to find the difference between two dates?

371

Do you need a commit after ddl statements?

390

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

384

What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?

386

You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?

410

What do you mean by oracle dba?

373

Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.

375

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

447

What are the main benefits of using spfile over pfile?

406

What are roles in oracle?

384

How do I become a database administrator?

375