What is the most common database language that a db administrator needs to know?

410

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?

467

What do you understand by the term 'normalization'?

447

How does one create a new database?

431

What are the different responsibilities of a dba?

453

What are elements of administration?

404

How can you determine if an oracle instance is up from the operating system level?

409

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

411

The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

401

How many control files should you have? Where should they be located?

406

What is oracle dba role?

410

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

419

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

442

When should you increase copy latches?

445

What is a production dba?

416