If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
609using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
1 1071What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
597What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
647Post New Oracle DBA (Database Administration) Questions
What is dba training?
What is the advantage of using rman?
How can you find dead processes?
How can you determine the number of sqlnet users logged in to the unix system?
What kinds of responsibilities does a dba have in a database environment?
What is end user in database?
Is oracle dba in demand?
How many types of database software are there?
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?
What are the types of schemas?
How can you find out how many users are currently logged into the database?
What is the purpose of the import option ignore? What is its default setting?
You see a wait on lms process in statspack, what does that mean?
How can you tell if an index on particular table is used or not used in 9i?
System tablespace cant be exported from one database and imported into another why?