File represents some characteristic of the real-world object that is being modelled
Anonymous Quiz
50%
T
50%
F
FILE-BASED SYSTEMS DISADVANTAGES:
Anonymous Quiz
2%
Separation & Isolation Of data
2%
Data Redundancy
2%
Integrity problems
94%
All
Database is an organized shared collection of related data used to support the activities of a particular organization.
Anonymous Quiz
97%
T
3%
F
Traditional database applications
Anonymous Quiz
64%
Store textual or numeric information
1%
Store images, audio clips, and video streams digitally
1%
Store and analyze maps, weather data, and satellite image
34%
All
Data warehouses systems:
Anonymous Quiz
7%
Support decision making
22%
Extract and analyze useful business information from very large databases
71%
Both
In DB insulation between the programs and data is also called program-data independence.
Anonymous Quiz
87%
T
13%
F
........... s the intermediate layer between the database and the programs that access the data.
Anonymous Quiz
4%
DB
86%
DBMS
10%
BOTH
........... is collection of programs that enables users to create and maintain a database and control access to them.
Anonymous Quiz
8%
DB
85%
DBMS
7%
BOTH
the primary key cannot have a NULL value, so the candidate key with a NULL value can be the primary key
Anonymous Quiz
39%
T
61%
F
What is the self-describing nature of a database system?
Anonymous Quiz
68%
It contains a complete definition of the database structure and constraints.
24%
It requires the use of metadata to describe the data.
9%
It stores data items and values separately.
What is stored in the DBMS catalog of a database system?
Anonymous Quiz
13%
Data items and values
80%
Metadata describing the structure and constraints of the database
7%
Virtual data derived from the database files
Which type of systems do not require metadata in NOSQL systems?
Anonymous Quiz
31%
File-based systems
19%
Database systems
38%
Self-describing systems
12%
Virtual data systems
What is the insulation between programs and data called in a database system?
Anonymous Quiz
63%
Program-data independence
9%
File-based structure
28%
DBMS catalog
What does a view represent in a database system?
Anonymous Quiz
12%
The structure of the data files
53%
The virtual data derived from the database files
22%
The subset of the database
13%
The programs that access the database