Interested to Buy Any Domain ? << Click Here >> for more details...
CTS int questions:
1.Temperory tablespace corrupted,how to resolve?If you need
to recover?
2.In tablespace begin backup mode,Its possible to add the
datafile?
3.How to partition the table using Hash partioning,what
happened internally?
4.During rman backup,some files are missing Rman will
continue the backup?
5.what are the errors occurs frequently?
6.which join method is best?why?
7.how to solve deadlock errors?
please reply anyone....
regards
siva
- 2 Answers
- 7445 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / ashok
1) no need to recover a temperory tablespace .if it is
corrupted we create a new temporary tablespace assign that
tablespace to database
2) yes we can add a datafile when tablespace in begin
backup mode also
4)yes
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What the different types of replication and why are they used? : sql server DBA
what is the diffrence between core dba and apps dba?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What the different topologies in which replication can be configured? : sql server DBA
Where would you look for errors from the database engine?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
what is the role of dip user in our database?
how can you enable flashback feature?
how can you schedule a job in database?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
What are the operating modes in which database mirroring runs? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
