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
- 7434 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
how will u see whether the dabase is in archive log mode or not?
How can you control the amount of free space in your index pages? : sql server DBA
If CPU is very slow What can u do to speed up?
What is the difference between clustered and non-clustered index? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
how can you connect from 10g user to 11g user??
What is the importance of a recovery model? : sql server DBA
What types of replication are supported in sql server? : 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?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
what is the difference between db2start command and start database manager command?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
