What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
Submitted by: AdministratorA temporary tablespace is used for temporary objects such as sort structures while permanent tablespaces are used to store those objects meant to be used as the true objects of the database.
Submitted by: Administrator
Submitted by: Administrator
Read Online Database Administrator (DBA) Job Interview Questions And Answers
Top Database Administrator (DBA) Questions
| ☺ | Name three advisory statistics you can collect. |
| ☺ | How would you determine who has added a row to a table? |
| ☺ | What are the ways to monitor the performance of the report? |
| ☺ | What DBA activities did you to do today? |
| ☺ | What is the maximum no of chars the parameter can store? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Sybase Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
