What is database files , Database Management System

The database files accept the actual data and are typically the biggest in size. Depending on their shape, the tables for all the user operation can go in one database file-but that's not an unique situation because it does not create the database structure very flexible for controlling access to storage for different accounts, putting the database on different storage disk drives, or backing up and restoring just phase of the database. You must have at least one database file but generally, more than one file are needed. In terms of accepting and using the data in the other objects and tables, the number of the folders is immaterial. The database files are not variable in size and never goes bigger than the size at which they were prepared

 

242_Database files.png

Posted Date: 7/30/2012 2:38:48 AM | Location : United States







Related Discussions:- What is database files , Assignment Help, Ask Question on What is database files , Get Answer, Expert's Help, What is database files Discussions

Write discussion on What is database files
Your posts are moderated
Related Questions
Given the following set of functional dependencies {cf?bg, g?d, cdg?f, b?de, d?c} defined on R(b,c,d,e,f,g) a.Find a non-redundant cover. b.Find a canonical cover.

Command Line Interfaces: These are interactive interfaces, character-based that let you use the complete power and functionality of the DBMS query language directly. They permit yo

Two-way Associations Mostly, associations are travel in both directions, although not usually with same frequency. There are three approaches for the implementation. In

Explain the Fundamental concepts of object-orientation Software developers, data base administrators (DBAs) need to be familiar with fundamental concepts of object-orientation.

Insulation between conceptual and physical structures It can be defined as: 1. The Database Administrator should be capable to vary the storage structures without affectin

Explain several types of constraints that can be specified using CREATE TABLE command. Explain CASCADE and RESTRICT clauses of DROP SCHEMA command? Constraint Description PRIM

Differentiate between the object oriented decomposition and the structured decomposition? Process-oriented (structural) decomposition divides a complex process, function or tas

Explain trigger? Trigger: A database trigger is procedural code which is automatically executed within response to certain events on a particular table in a database. Trigger

Problem: You are given the following schema 1. Flights(flno, from, to, distance) 2. Aircraft(aid, flno, aname, cruisingRange) 3. Certified(eid, aid) 4. Employees(eid, ena

Describe an data dictionary? A data dictionary is a data structure which keeps meta data about the structure of the database ie. the schema of the database.