30 Questions
What is the purpose of a database?
To help people track things of interest to them
How are enormous datasets commonly referred to?
Big Data
In a database table, what are rows also known as?
Records
What is the naming convention used for column names in this textbook?
Written with an initial capital letter
How are table names written in this textbook?
With all capital letters
What does each row in a database table store data about?
An occurrence or instance of the thing of interest
What is the term used to describe the functions of a database management system?
Metadata
Which learning objective involves gaining an understanding of tables and relationships?
1.4
What term is used to define the process of designing a new database system?
New systems development
Which objective involves understanding the history and development of database processing?
1.13
What components are explained in the context of an enterprise-class database system?
Query optimization and indexes
Which term defines what is contained within a database?
Database content
What characteristic of HTTP was a problem at first in Web Databases?
Stateless characteristic
Which era mentions the use of open source DBMS products like MySQL and PostgresQL?
Web Databases 1995-Present
What technology provides tremendous benefits to Web-based database applications according to the text?
XML
Which movement is geared toward processing large datasets using nonrelational data structures?
Big Data
Which type of companies rely on cloud computing services according to the text?
Many companies hosting servers, applications, and data
What product is NOT mentioned as part of the Big Data technologies in the text?
MySQL
Who created the relational database model?
An IBM engineer named E.F. Codd
What mathematical concept is the relational database model based on?
Relational algebra
What type of database was designed to easily store data encapsulated in OOP objects?
Object-oriented database
What type of database is used for online analytical processing (OLAP) and business intelligence (BI) systems?
Data warehouse
What protocol is used to connect Web pages over the Internet?
Hypertext Transfer Protocol (HTTP)
Which of these statements about the relational database model is true?
It was based on relational algebra
What is the main characteristic of a self-describing database?
It is capable of storing a description of its contents
What is metadata in a self-describing database?
Data about data
What is Microsoft Access primarily intended for?
Individual users and small workgroups
What strategy does Microsoft Access employ regarding database technology?
It hides much of the underlying database technology from the user
Which table in the USER_TABLES table has 4 columns?
STUDENT
Which table in the USER_COLUMNS table has a column named 'ClassNumber'?
Both CLASS and GRADE
Test your knowledge on the fundamentals, design, and implementation of databases with a focus on the importance of databases in Internet Web applications and smartphone apps, nature and characteristics of databases, database applications, tables, and relationships.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free