What are the types of schemas?

609

Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?

561

What do you understand by a control file?

586

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

596

A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

639

How do you analyze table partition using oracle provided package?

554

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

647

What kinds of responsibilities does a dba have in a database environment?

638

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

608

Does dba need to know programming?

617

What parameters control copy latches?

631

What are database skills?

626

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

597

How can you determine if the sqlnet process is running for sqlnet v1? How about v2?

624

What should a dba know?

568