5.1 Explain database concepts and the purpose of a database.
Why is a query an important tool in database processing?
A query allows a user to extract only the data needed from a database by selecting specific rows and columns from a table.
How do Relational Database Management Systems (RDBMS) handle multiple users accessing the same database concurrently?
Multiple users can view the same record at the same time. If more than one user attempts to update the same record at the same time, the RDBMS locks that record so that only one user at a time can update.
Which would be the LEAST desirable architecture option for a database that requires a high degree of scalability?
One-tier
Microsoft SQL Server is an example of what?
RDBMS
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?
Row
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
Which language is typically used by Relational Database Management Systems (RDBMS) to maintain data?
Structured Query Language (SQL)
Why might a table called "Products" in a relational database have twelve rows?
There are twelve products.
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.
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.
What is a database?
A database is a collection of related data organized in a structured manner for easier access.
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.
Why do a report and a query work well together?
A query can be used to extract only the data based on specified criteria, while a report can format and summarize the data making it easier to read and interpret.
What is the relationship between queries and reports?
A query selects and retrieves the correct data, whereas a report formats and summarizes the output.
Which statement is NOT true regarding the relationship between a table and its components?
A table always has the same number of columns as it has rows.
Which is the correct sequence in the process of database creation?
CREATE DATABASE CREATE TABLE INSERT INTO
Which of the following statements best describes data persistence?
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.
Which is the BEST example of importing data to populate a database?
Data records that are already stored in a digital format can be loaded directly into a database.
What are the steps in the process of creating a database?
Determine how the database will be used by clients, where it will be hosted, and what information it will store.
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
In which order are the rows typically stored in a relational table?
The order in which they were entered into the database