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
- 7428 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / victory
1.Temporary tablespaces can be used only for that particular
session.Once u end the session there will be no more old
temp tbsp available. (as far as i know)
7.activate the deadlock detector and dlchktime which
automatically rollbacks one application randomly.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the different sql server versions you have worked on? : sql server DBA
What is the importance of a recovery model? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Where would you look for errors from the database engine?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What are the different types of indexes available in sql server? : sql server DBA
what do you understand by flashback feature of oracle?
Why would you call update statistics? : sql server DBA
how can you schedule a job in database?
How can you control the amount of free space in your index pages? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
