Database Management Quiz Lesson 1

Microsoft Access is just a DBMS. True False

False

Paradox is the only major survivor of the "bloodbath of PC DBMS products." True False

False

Sequenced Query Language (SQL) is an internationally recognized standard language that is understood by all commercial database management system products. True False

False

The CODASYL DBTG model structured data relationships as a tree structure. True False

False

The DBMS ranked as being the "easiest to use" in the text is Microsoft's SQL Server. True False

False

The DBMS ranked as having the "most power and features" in the text is IBM's DB2. True False

False

The database application is responsible for concurrency control. True False

False

The largest databases in e-commerce are the order entry databases. True False

False

Which statement is not true about the relational model? It was developed by E. F. Codd. It resulted in the DBMS product DB2. It was first proposed in 1970. It was developed at Oracle.

It was developed at Oracle.

Which of the following database systems is not enterprise-class? Microsoft Access Oracle Database Microsoft SQL Server IBM DB2

Microsoft Access

Microsoft Access is a low-end product intended for individuals and small workgroups. True False

True

Referential integrity constraints are rules about what data values are allowed in certain columns. True False

True

The 1977 edition of this text contained a chapter on the relational model, and that chapter was reviewed by E. F. Codd. True False

True

The DBMS ranked as being the "most difficult to use" in the text is Oracle Corporation's Oracle Database. True False

True

The DBMS ranked as having the "least power and features" in the text is Microsoft Access. True False

True

The NoSQL movement should really be called a NoRelational movement. True False

True

The current DBMS engine in Microsoft Access is called ADE. True False

True

The database management system (DBMS) is responsible for enforcing referential integrity constraints. True False

True

The database management system (DBMS) is responsible for inserting, modifying, reading, and deleting data. True False

True

The description of a database's structure that is stored within the database itself is called the metadata. True False

True

The e-commerce companies use Web activity databases to determine which items on a Web page are popular and successful. True False

True

The purpose of a database is to help people keep track of things. True False

True

The relational model was first proposed in 1970 by E. F. Codd at IBM. True False

True

Twitter and Facebook use NoSQL databases. True False

True

XML Web services allow database processing to be shared across the Internet. True False

True

In every database, not just the databases discussed in this book, table names are capitalized. True False

False

Microsoft Access may use which of the following DBMS engines? ADE SQL Server Oracle Both ADE and SQL Server are correct

Both ADE and SQL Server are correct

Which of the following statements is true about Web 2.0? It requires the Android Operating System. It allows users to add content to Web sites. Twitter and Facebook are examples of Web 2.0 sites. Both It allows users to add content to Web sites and Twitter and Facebook are examples of Web 2.0 sites are correct

Both It allows users to add content to Web sites and Twitter and Facebook are examples of Web 2.0 sites are correct

Microsoft Access includes ________. a DBMS an application generator a Web server Both a DBMS and an application generator are correct

Both a DBMS and an application generator are correct

A database stores ________. data relationships applications Both data and relationships are correct

Both data and relationships are correct

Business organizations have resisted adopting object-oriented database management systems because ________. the cost of purchasing OODBMS packages is prohibitively high the cost of converting data from relational databases to OODBMSs is too high most large organizations have older applications that are not based on object oriented programming Both the cost of converting data from relational databases to OODBMSs is too high and most large organizations have older applications that are not based on object oriented programming are correct

Both the cost of converting data from relational databases to OODBMSs is too high and most large organizations have older applications that are not based on object oriented programming are correct

A program whose job is to create, process and administer databases is called a ________. Database Modeling System Data Business Model System Relational Model Manager Database Management System

Database Management System

Which of the following is not an XML Web service standard? WSDL Ethernet UDDI SOAP

Ethernet

A database design is rarely a redesign of an existing database. True False

False

A database is a self-describing collection of non-integrated tables. True False

False

A database is called self-describing because it reduces data duplication. True False

False

Business organizations have resisted adopting object-oriented database systems because the cost of purchasing OODBMS packages is prohibitively high. True False

False

Enterprise Resource Planning (ERP) is an example of a data mining application. True False

False

In an Enterprise-class database system, a database application accesses the database data. True False

False

In an Enterprise-class database system, business users interact directly with the DBMS, which directly accesses the database data. True False

False

This database component can be used as part of applications and for administration tasks. Tables Stored procedures Triggers Metadata

Stored procedures

The industry standard supported by all major DBMSs that allows tables to be joined together is called ________. Structured Question Language (SQL) Sequential Query Language (SQL) Structured Query Language (SQL) Standard Question Language (SQL)

Structured Query Language (SQL)

Which of the following statements is not true for an enterprise-class database system? The DBMS accesses the database data. The application generates SQL statements. The database application(s) interact(s) with the DBMS. The database application(s) directly access(es) the database data.

The database application(s) directly access(es) the database data.

Which of the following statements is not true about client-server architecture? The server usually runs the DBMS on it. Most Web applications are supported by client-server. The client initiates a request. The server is usually a tablet or smartphone.

The server is usually a tablet or smartphone.

Which of the following statements is not true for primary keys in a relational database system? They can be part of relational integrity constraints. They can be used to create relationships between tables. They must contain numeric data. They uniquely identify a row in a table.

They must contain numeric data.

This database component is used to maintain database accuracy and enforce data constraints. Tables Stored procedures Metadata Triggers

Triggers

A database design may be part of a new systems development project. True False

True

A database management system (DBMS) creates, processes and administers databases. True False

True

A database shows data in tables and the relationships among the rows in those tables. True False

True

A database system is typically defined as its four components: users, database applications, the DBMS and the databases. True False

True

All database applications get and put database data by sending SQL statements to the DBMS. True False

True

Applications are computer programs used directly by users. True False

True

Bill Gates has said that "XML is the lingua-franca of the Internet Age." True False

True

Data Language/I (DL/I) structured data relationships as a tree structure. True False

True

Data is recorded facts and figures; information is knowledge derived from data. True False

True

Databases are a key component of e-commerce order entry, billing, shipping and customer support. True False

True

Databases based on the CODASYL standard are based on the network data model. True False

True

Databases record data in such a way that they can produce information. True False

True

Each row in a database table is also known as a record. True False

True

In Microsoft Access, you can use ODBC to connect to SQL Server in place of the ADE database engine. True False

True

In a database, each table stores data about a different type of thing. True False

True

In an Enterprise-class database system, a database application interacts with the DBMS. True False

True

In database systems, indexes are held in the database. True False

True

Indexes are data structures that speed searching of database data. True False

True

Integrated tables store both data and the relationships among the data. True False

True

For database development, the most important Web-related technology to emerge in recent years is ________. XML FTP OODBMS HTTP

XML

A database designed to implement requirements for a reporting application needed by the Sales department is a database being designed ________. from existing non-database data as a new systems development project as a redesign of an existing database Both from existing non-database data and as a new systems development project are correct

as a new systems development project

A database designed to combine two databases used by the Sales department is a database being designed ________. from existing data as a new systems development project as a redesign of an existing database Both from existing data and as a new systems development project are correct

as a redesign of an existing database

Database professionals use ________ as specific data sources for studies and analyses. data models entity-relationship data modeling normalization data marts

data marts

In database systems, the DBMS enforces rules about which user can perform which action when. The rules are known as ________. data reading control referential integrity constraints concurrency control data modification control

concurrency control

A database consists of integrated tables, which store ________. reports data and relationships among the data forms Both reports and forms are correct

data and relationships among the data

A very popular development technique used by database professionals to adopt a database design to a new or changing requirement is known as ________. database migration entity-relationship data modeling normalization data models

database migration

An online drugstore such as Drugstore.com is an example of a(n) ________. enterprise resource planning system single-user database application e-commerce database application multiuser database application

e-commerce database application

The predecessor(s) of database processing was (were) ________. hierarchical models network models file managers the relational data model

file managers

A database designed using spreadsheets from the Sales department is a database being designed ________. as a redesign of an existing database as a NoSQL database from existing data as a new systems development project

from existing data

The purpose of a database is to ________. store data in tables help people keep track of things maintain data on different things in different tables create tables of rows and columns

help people keep track of things

A database is considered self-describing because ________. it reduces data duplication all the users' data is in one place it contains a listing of all the programs that use it it contains a description of its own structure

it contains a description of its own structure

A Customer Resource Management (CRM) system is an example of a(n) ________. multiuser database application single-user database application e-commerce database application digital dashboard

multiuser database application

Database professionals use a set of principles called ________ to guide and assess database design. data models normalization entity-relationship data modeling database extraction

normalization

Database professionals use a set of principles called ________ to guide and assess database design. entity-relationship data modeling database extraction normalization data models

normalization

In database systems, the DBMS enforces rules about which data can be written in certain columns. The rules are known as ________. data insertion control referential integrity constraints concurrency control data modification control

referential integrity constraints

A sales contact manager used by a salesperson is an example of a(n) ________. multiuser database application single-user database application data mining application e-commerce database application

single-user database application

For database development, a challenge to the relational model and the use of SQL is known as ________. the XML movement the Web services movement the NoSQL movement the SOAP movement

the NoSQL movement

In an enterprise-class database system, reports are created by ________. the database the database management system (DBMS) the user the database application

the database application

Modern microcomputer personal DBMS products ________. are supplied by several well-established manufacturers were essentially made obsolete by Microsoft Access are not true DBMS products have poor response time

were essentially made obsolete by Microsoft Access