Interested to Buy Any Domain ? << Click Here >> for more details...
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.
639What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
670If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?
610What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
664Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
689Post New Oracle DBA (Database Administration) Questions
Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
If you see statistics that deal with "undo" what are they really talking about?
What are the different types of database users?
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.
How can you determine the space left in a file system?
Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
What are the main functions of dba?
How can you find out how many users are currently logged into the database?
You see a wait on lms process in statspack, what does that mean?
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 happens if a tablespace clause is left off of a primary key constraint clause?
How can you determine if the sqlnet process is running for sqlnet v1? How about v2?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
What happens if the constraint name is left out of a constraint clause?
What is the difference between a database and instance? What is the relation between them?
