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
- 7463 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 |
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Give the two types of tables involved in producing a star schema and the type of data theyhold.
What column differentiates the V$ views to the GV$ views and how?
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
Where in the Oracle directory tree structure are audit traces placed?
why Datapump is faster than traditional export and import
Which autogrowth database setting is good? : sql server DBA
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
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?
what functionality does oracle provide to secure sensitive information?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
-
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)
