Unlike desktop databases, such as Paradox and xBase databases, a Firebird database is not a series of “table files” physically organized in rows and columns. Firebird stores data, independent of its structure, in a compressed format, on database pages. It may store one or many records—or, correctly, rows—of a table’s data on a single page. In cases where the data for one row is too large to fit on one page, a row may span multiple pages.
Although a page that stores table data will always contain only data belonging to one table, pages are not stored contiguously. The data for a table may be scattered all around the disk and, in multi-file databases, may be dispersed across several directories or disks. BLOB data is stored apart from the rows that own it, in another style of database page.
Metadata—the physical descriptions of tables and their columns and attributes, as well as those of all other objects —is itself stored in ordinary Firebird tables inside the database. The Firebird engine writes to these tables when database objects are created, modified, or destroyed. It refers to them constantly when carrying out operations on rows. These tables are known as system tables.
Firebird Related Interview Questions
|RDBMS Interview Questions||MySQL Interview Questions|
|Linux Interview Questions||Mac OS X Deployment Interview Questions|
|Windows Administration Interview Questions||Windows Server 2003 Interview Questions|
|SQL Interview Questions||NoSQL Interview Questions|
|Advanced C++ Interview Questions|
Introduction To Client/server Architecture
About Firebird Data Types
Date And Time Types
Blobs And Arrays
From Drawing Board To Database
Creating And Maintaining A Database
Firebird’s Sql Language
Expressions And Predicates
Querying Multiple Tables
Ordered And Aggregated Sets
Overview Of Firebird Transactions In
Programming With Transactions
Introduction To Firebird Programming
Developing Psql Modules
Error Handling And Events
Security In The Operating Environment
Configuration And Special Features
Interactive Sql Utility (isql)
Database Backup And Restore (gbak)
Housekeeping Tool (gfix)
Understanding The Lock Manager
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.