|
INTERVIEW QUESTIONS
DATABASE
FIREBIRD
DETAILS
Question: Why does reading require write privileges on database file?
Answer: In order to run the SELECT statmement, it still needs to start a transaction.
If you wish to build a read-only database to place on some read-only media like CD or DVD ROM, you can do it with:
gfix -mode read_only database.fdb
...or within your favorite administration tool. It is also available via ServicesAPI, so you may do it from your application as well. Please note that you can only make this change while preparing the database, because the read-only flag needs to be written in the database file.
When the database becomes read-only, the only thing you can write to is the read_only flag (to reset it back to read-write).
|
|
|
Category |
Firebird Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 6708 users |
Added on |
7/23/2015 |
Views |
67867 |
Rate it! |
|
|
Question:
Why does reading require write privileges on database file?
Answer:
In order to run the SELECT statmement, it still needs to start a transaction.
If you wish to build a read-only database to place on some read-only media like CD or DVD ROM, you can do it with:
gfix -mode read_only database.fdb
...or within your favorite administration tool. It is also available via ServicesAPI, so you may do it from your application as well. Please note that you can only make this change while preparing the database, because the read-only flag needs to be written in the database file.
When the database becomes read-only, the only thing you can write to is the read_only flag (to reset it back to read-write). 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 |
|
Is there an example how to configure ExternalFileAccess setting in firebird.conf?
|
View Answer
|
|
Is there a way to detect whether fbclient.dll or fbembed.dll is loaded?
|
View Answer
|
|
Is there a way to automate SQL execution from the command-line, batch job or shell script?
|
View Answer
|
|
Is it possible to determine clients IP address?
|
View Answer
|
|
How to write UDF s in Delphi?
|
View Answer
|
|
How to use events with ZeBeDee, SSH or stunnel?
|
View Answer
|
|
How to tell Firebird to only accept conections from XYZ host or network?
|
View Answer
|
|
How to stop SuperServer service on Linux using only Firebird tools?
|
View Answer
|
|
How to specify transaction or query timeout?
|
View Answer
|
|
How to select a random record from a table?
|
View Answer
|
|
How to repair a corrupt Firebird database?
|
View Answer
|
|
How to reorder the table columns (fields)?
|
View Answer
|
|
How to recreate the index on a Firebird table?
|
View Answer
|
|
How to pump the data from one database to another?
|
View Answer
|
|
How to prevent firebird.log file from filling up the disk partition?
|
View Answer
|
|
How to disconnect the user connection?
|
View Answer
|
|
How to do replication of Firebird databases?
|
View Answer
|
|
How to drop all foreign keys in database?
|
View Answer
|
|
How to export data from database and import into another?
|
View Answer
|
|
How to extract metadata for the entire database?
|
View Answer
|