0
What contains data about each file in the database and each field within those files?
Wiki User
∙ 11y ago
table of contexts
***Incorrect***
The correct answer is Data Dictionary
Wiki User
∙ 11y ago
The data dictionary contains information about each file in the database, including the structure, properties, and location of each file. It also includes information about each field within those files, such as the data type, size, and constraints associated with each field. The data dictionary acts as a centralized repository of metadata that helps in managing and understanding the database schema and data.
Add your answer:
Earn +20 pts
Which type of database model connects data in different files through the use of a key field?
The relational database model connects data through the use of a key field, which is called a primary key in one table and a foreign key in another table. This key field establishes a relationship between different tables by uniquely identifying records.
Difference between database and database instance?
A database is a structured collection of data, while a database instance refers to a single running copy of a database system. Think of a database as the overall system that stores data, and a database instance as a specific iteration of that system currently running in memory.
What is a record in the database?
In a database, a record is a complete set of fields that represents one entity in a table. It typically contains different pieces of information related to that entity, organized in a structured format such as rows and columns. Each record is a unique entry in the database and can be identified by a primary key.
What is called a collection of interrelated files?
A collection of interrelated files is called a database. It is organized in a way that allows for easy access, retrieval, and manipulation of data. Databases are commonly used in applications to store and manage information efficiently.
Where would you find internal information?
Internal information can typically be found within an organization's database, intranet, company files, or through communication with colleagues, managers, or other internal stakeholders. It is information that is specific to the organization and not readily available to the public.
A database contains files a file contains?
records, a record contains fields, and a field is made up of characters
What is the difference between database file and datafile?
Datafile is a group of files in each table space in an Oracle database. Database files are all files that are found within the database.
Which type of database model connects data in different files through the use of a key field?
The relational database model connects data through the use of a key field, which is called a primary key in one table and a foreign key in another table. This key field establishes a relationship between different tables by uniquely identifying records.
What is a mixed database?
A mixed database is a system that contains different records that are set up in different files. This means that the database system will run several workloads simultaneously.
What is a Un-normalize database?
An un-normalized database contains a random population of data that has not been organized into small stable data files
Correct difference between file and database?
A file is a record. A record is comprised of a bunch of fields. Files are the subject of some thing. For example, if you are on a mailing list, it has your name, address. A database contains files - think of a file cabinet.
What are the different types of physical files in the Oracle 9i?
* Database datafiles - contain the data itself * Control files - binary files containing information about the database (name, files, backup...) * Online redo logs - files, which record every transaction in the database * Parameter files - database parameter file * Other database related files - password files, alert log, trace files...
What is called as Collection of files in database?
database
Is database files and internet files the same?
No
What order are files stored in the database?
simply files are stored in database in upper to lower order.
What is role of database in organization?
database is a collection of different files
When it is more appropriate to use a file system rather than a database?
One answer is when you are dealing with image files like JPGs or PDFs. One mistake I see people making is storing image files within a database. That's a poor design. They bloat the database and can't be indexed. You should store the images in a file system and simply put ponters in the database.
