Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
35 Cards in this Set
- Front
- Back
What type of database exists in many separate locations throughout a network or the Internet?
|
Answer: distributed |
|
What is DBMS?
|
Answer: software |
|
What was Megan’s Law designed to do?
|
Answer: create a list of names and addresses of people convicted of crimes against children. |
|
In the database pictured in the accompanying figure, which of the following is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses?
|
Answer: field |
|
Most DBMSs include a feature, as shown in the middle image within the accompanying figure, which has a graphical user interface to assist users with retrieving data. What is this feature called?
|
Answer: QBE (Query By Example) |
|
Which term is used to describe the practice that users’ access privileges are limited to the lowest level necessary to perform required tasks?
|
Answer: principle of least privilege |
|
What is a feature that has a graphical user interface to assist users with retrieving data?
|
Answer: QBE (query by example) |
|
A user of a database such as that pictured in the accompanying figure refers to a record as what?
|
Answer: row |
|
In a database which of the following is a connection within the data?
|
Answer: relationship |
|
A checkout clerk with this level of privileges to the email addresses in a discount warehouse database could view the addresses but not change them. What is this level of privileges called?
|
Answer: read-only |
|
You create a database that stores data in tables that consist of rows and columns. Each row has a primary key, and each column has a unique name. Which data model did you use?
|
Answer: relational |
|
If you are running a check that applies a formula to the primary key, what kind of check are you running?
|
Answer: check digit |
|
Who was the inventor of the relational database model?
|
Answer: E. F. Codd (Edgar F. Codd) |
|
Which of the following does a back end interact with?
|
Answer: DBMS (DataBase Management System) |
|
SQL stands for which of the following?
|
Answer: Structured Query Language |
|
Which of the following consists of rules and standards that define how a database organizes data?
|
Answer: data model |
|
What is the term for a feature that has a graphical user interface to assist users with retrieving data?
|
Answer: QBE (Query By Example) |
|
Which of the following languages consists of simple, English-like statements that allow users to specify the data to display, print, or store?
|
Answer: query |
|
What does the S in SQL stand for?
|
Answer: Structured (Structured Query Language) |
|
Which of the following is a request for specific data from a database?
|
Answer: query |
|
What is another term used for data dictionary?
|
Answer: repository |
|
Which of the following is an item that contains data, as well as the actions that read or process the data?
|
Answer: object |
|
A DBMS uses which of the following to perform validation checks?
|
Answer: data dictionary |
|
In what kind of recovery does the DBMS use the log to undo any changes made to a database during a certain period?
|
Answer: backward |
|
What is the process of presenting data graphically as charts, maps, or other pictorial formats in order to understand the resulting information easily?
|
Answer: data visualization |
|
Which of the following statements about data types is FALSE?
|
Answer: Text data types are used for lengthy memos. |
|
Which of the following is a collection of data organized in a manner that allows access, retrieval, and use of that data?
|
Answer: database |
|
Analysts often refer to the three ____’s when describing characteristics of Big Data.
|
Answer: V's (Volume, Velocity and Variety) |
|
Which of the following statements is FALSE about relational databases?
|
Answer: Applications best suited for relational databases are those whose data can be organized into a three-dimensional table. |
|
What involves showing users exactly how they will use the new hardware and software in the system?
|
Answer: training |
|
A table that has rows and columns is what type of table?
|
Answer: two-dimensional |
|
In your school’s database, in which of the following is all of the information about a particular student stored?
|
Answer: a record |
|
What type of database are organizations MOST LIKELY to use for payroll, accounts receivable, inventory, and invoicing?
|
Answer: a relational database |
|
Which of the following is a nonprocedural language that enables users and software developers to access data in a database?
|
Answer: 4GL (4th Generation Language) |
|
Which of the following refers to the different formats to represent or store data for use by humans and computer applications?
|
Answer: variety |