|
INTERVIEW QUESTIONS
DATABASE
FIREBIRD
DETAILS
Question: How to move a multi-file database?
Answer: You are probably used to having a single-file database which you can move around as much as you want. But, your database has grown too big and now you need a multi-file database. Paths to the secondary files are absolute and stored in the header page of the first database file. If you need to move those files, it is recommended that you backup the database and restore at new location. However, if you really, really need to copy them around, you can use freeware tool GLink by Ivan Prenosil:
|
|
|
Category |
Firebird Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 8655 users |
Added on |
7/23/2015 |
Views |
67706 |
Rate it! |
|
|
Question:
How to move a multi-file database?
Answer:
You are probably used to having a single-file database which you can move around as much as you want. But, your database has grown too big and now you need a multi-file database. Paths to the secondary files are absolute and stored in the header page of the first database file. If you need to move those files, it is recommended that you backup the database and restore at new location. However, if you really, really need to copy them around, you can use freeware tool GLink by Ivan Prenosil: Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
How to open the database in exclusive mode?
|
View Answer
|
|
How to pipe multiline string to isql?
|
View Answer
|
|
How to determine who is and change the owner of database?
|
View Answer
|
|
How to detect the server version?
|
View Answer
|
|
How to detect applications and users that hold transactions open too long?
|
View Answer
|
|
How to debug stored procedures?
|
View Answer
|
|
How to deactivate triggers?
|
View Answer
|
|
How to create a database from my program?
|
View Answer
|
|
How do convert or display the date or time as string?
|
View Answer
|
|
How to configure events with firewall?
|
View Answer
|
|
How to change database dialect?
|
View Answer
|
|
How to add, remove, modify users using SQL?
|
View Answer
|
|
How to activate all indexes in Firebird?
|
View Answer
|
|
Can I concurrently access a Firebird database with embedded and with regular server?
|
View Answer
|
|
What is command for supporting foreign key in Firebird?
|
View Answer
|
|
What is the maximum number of rows in a table in Firebird?
|
View Answer
|
|
What are the vital features of Firebird that makes it powerful database?
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All Firebird Interview Questions & Answers - Exam Mode /
Learning Mode
|