CH5 – Flashcards
Unlock all answers in this set
Unlock answersquestion
The purpose of a database is to ________.
answer
store lists of data involving multiple themes
question
A ________ is a self-describing collection of integrated records.
answer
Database
question
Which of the following best describes a byte in a database?
answer
It is a character of data.
question
In a database, bytes are grouped into ________.
answer
Columns
question
In a database, columns are also called ________.
A) records
answer
Fields
question
In a database, rows are also called ________.
answer
Records
question
In a database, the collection of data for all columns is called a ________.
answer
Record
question
In a database, a group of similar rows is called a ________.
answer
Table
question
In a database, a table is also called a ________.
answer
File
question
Which of the following best describes the metadata in a database?
answer
special data that describes the structure of a database
question
In a database, a column or group of columns that identifies a unique row in a table is known as a ________.
answer
Key
question
In a database, columns that are keys of a different table than the one in which they reside are known as ________ keys.
answer
Foreign
question
Databases that carry their data in the form of tables and represent relationships using foreign keys are called ________ databases.
answer
Relational
question
In a database, a table is formally referred to as a ________.
answer
Relation
question
Data that describe the data contained in a database are called ________.
answer
Metadata
question
A(n) ________ is a program that is used to create, process, and administer a collection of self-describing integrated records.
answer
database management system (DBMS)
question
Which of the following is a database management system (DBMS) product from Microsoft?
answer
SQL Server
question
________ is a popular enterprise database management system (DBMS) product from IBM.
answer
DB2
question
Which of the following is a function of the database management system (DBMS)?
answer
processing a database by inserting or modifying data
question
The database management system (DBMS) provides applications for processing operations such as ________.
answer
inserting or deleting information
question
SQL stands for ________.
answer
Structured Query Language
question
________ is an international standard language that is used for processing a database.
answer
Structured Query Language
question
One of the important functions of a database management system (DBMS) is to provide the necessary tools for ________.
answer
administering the database
question
Which of the following is considered an administrative function of the database management system (DBMS)?
answer
adding structures to improve the performance of database applications
question
Monitoring the performance of a database after providing solutions for improving its performance is an activity of the DBMS pertaining to ________.
answer
Administration
question
Conducting training to ensure that users and operations personnel know and understand recovery procedures is a task associated with the DBMS ________.
answer
Administration
question
A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.
answer
database application
question
Which of the following elements of a database application helps in the insertion of new data and the deletion of existing data?
answer
Forms
question
Which of the following elements of a database application presents data in a structured manner using sorting, grouping, filtering, and other operations?
answer
Reports
question
Which of the following elements of a database application provides security, data consistency, and special-purpose processing?
answer
application programs
question
Traditional database application programs are written in object-oriented languages like ________.
answer
Visual Basic
question
Which of the following is true of browser-based database applications?
answer
They are displayed and processed using html, html5, or css3.
question
Browser-based database applications differ from traditional applications in that they ________.
answer
are usually open to the public
question
Which of the following is a major drawback of multi-user processing of a database?
answer
lost-update problem
question
Which of the following is a drawback of the relational database processing model?
answer
It was never a natural fit with business documents.
question
Which of the following is true of the relational database processing model?
answer
It represents relationships with the help of foreign keys.
question
One of the reasons for the appearance of new styles of nonrelational database processing is the need for ________.
answer
storing data types such as images, audio, and videos in organizations
question
Which of the following is a nonrelational data store developed by Amazon.com?
answer
Dynamo
question
________ refers to software products that support very high transaction rates, processing relatively simple data structures, replicated on many servers in the cloud.
answer
NoSQL DBMS
question
The conversion of the existing traditional databases in organizations to NoSQL databases is ________.
answer
unnecessary when relational databases meet the needs of organizations
