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
- 7431 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 are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
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.
Which autogrowth database setting is good? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What types of replication are supported in sql server? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What would you do with an "in-doubt" distributed transaction?
how does an oracle clusterware manage crs resources?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
