Mod 9 Quiz Flashcards
Why are databases better for concurrent use compared to spreadsheets?
Databases allow many users to access data simultaneously.
How does a document database store data?
In flexible documents
What is a flat file system?
Another name for a spreadsheet.
What is a database schema?
The architecture of how a database is structured and organized
What type of relationship has one record with a primary key associated with multiple records in other tables with foreign keys?
B) One-to-many relationship
Which of the following can be a primary key?
Phone number
What is one advantage of databases in terms of data recovery?
Databases back up information within seconds.
What is a document database?
A type of non-relational database
What does scalability in a database mean?
The ability to handle a large amount of data efficiently
What is the main purpose of a physical data model?
To show how to set up a database using a specific database management system
What is XML used for in databases?
To give structure to non-structured data
What is a relational database?
A database that keeps data in several connected tables.
What is the purpose of data modeling?
To help programmers and others understand the complex flow of data within an organization
What is the best way to enter large amounts of data into a database?
Importing it from other sources
What does RDBMS stand for?
Relational Database Management System
