5.1 Explain Data concepts and the purpose of a Database Flashcards
In a relational database, data is organized into tables that are made up of rows and columns. The term “record” is a synonym for which of these terms?
Rows
A manager needs to view last month’s sales figures. Which of the following functionalities can be done with a query statement?
Specifying criteria to match values in one or more fields
In which order are the rows typically stored in a relational table?
The order in which they were entered into the database
When processing large numbers of transactions, how does processing speed compare between databases and flat file systems?
Database processing speeds are much faster than flat file speeds.
A database is organized by relating data together,
Why is the level of data integrity greater in a database than in a flat file?
A database can enforce data types for each column in a table, and can validate data as it is entered into those columns.
Microsoft SQL Server is an example of what?
Relational Database Management Systems (RDBMS). Software is required to create and maintain a database schema and the data inside the actual database. SQL Server, Oracle, MS Access, and MySQL are all examples of Relational Database Management Systems (RDBMS).
Which is the correct sequence in the process of database creation?
CREATE DATABASE
CREATE TABLE
INSERT INTO
What is the relationship between queries and reports?
A query selects and retrieves the correct data, whereas a report formats and summarizes the output.
What term is defined as the ability of a database to increase in size as more information is added to it without increasing costs at the same rate?
Scalability
What statements best describes data persistence?
Persistent data is data that is stored permanently in a database. Data in memory is lost once the processing is completed. Data in a database is stored persistently and securely so that it can be used again in the future.
Why would a flat file system not be the optimum choice for data storage for an online shopping cart application?
A flat file system doesn’t support multiple concurrent users.
