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
- 7442 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 is ora 24313?what is the procedure to exclude that error?
What is replication? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what are the types of connection load-balancing?
what functionality does oracle provide to secure sensitive information?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
How do you trace the traffic hitting a sql server? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
what are the differences of where and if in SAS?
how can you create a user-defined lock?
What is the default fill factor value? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What purpose does the model database server? : sql server DBA
