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