What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
551When using oracle export/import what character set concerns might come up? How do you handle them?
580Post New Oracle DBA (Database Administration) Questions
What is oracle log switch?
What are the various ingredients of sga?
When configuring sqlnet on the client what files need to be set up?
What are the main benefits of using spfile over pfile?
Are database administrators in demand?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
Is oracle dba in demand?
What is the purpose of the import option ignore? What is its default setting?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
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 is the difference between truncate and delete? How would a full table scan behave after?
What happens if the constraint name is left out of a constraint clause?
You have taken a manual backup of a datafile using os. How rman will know about it?
What are four common errors found in an alert .log?
How can you determine if an oracle instance is up from the operating system level?