Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
475Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?
546You 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?
746You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
553If you are not sure what command does a particular unix function what is the best way to determine the command?
511You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
486What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
578Post New Oracle DBA (Database Administration) Questions
What is an artificial (derived) primary key?
What are elements of administration?
What are the different types of database users?
Which dba certification is best?
How can you find your id on a system?
A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?
Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
What is dba training?
What kinds of responsibilities does a dba have in a database environment?
What does a dba do all day?
What does >> do?
What is end user in database?
Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?
What does a senior database administrator do?
How can you determine the space left in a file system?