Question 1

Which of the following could be described as a contemporary implementation of centralized architecture?

Accepted Answer

A)  cloud computing 
B)  distributed databases 
C)  client/server architecture 
D)  peer-to-peer computing 
A)  cloud computing 
B)  distributed databases 
C)  client/server architecture 
D)  peer-to-peer computing

Question 2

Which of the following is a technology that data scientists use to store and analyze big data?

Accepted Answer

A)  WordPress 
B)  XQuery 
C)  Hadoop 
D)  SQLite 
A)  WordPress 
B)  XQuery 
C)  Hadoop 
D)  SQLite

Question 3

Which of the following is not one of Codd's 12 rules for distributed databases?

Accepted Answer

A)  continuous operation 
B)  reliance on a central site 
C)  location transparency 
D)  hardware independence 
A)  continuous operation 
B)  reliance on a central site 
C)  location transparency 
D)  hardware independence

Question 4

Big data typically keeps track of common business transactions, such as accounts receivable and payroll.
​

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is a language for querying web-based documents and similarly structured data repositories?

Accepted Answer

A)  XQuery 
B)  XSL Transformations (XSLT) 
C)  Extensible Stylesheet Language (XSL) 
D)  Extensible Schema Definition (XS
D)  
A)  XQuery 
B)  XSL Transformations (XSLT) 
C)  Extensible Stylesheet Language (XSL) 
D)  Extensible Schema Definition (XS
D)

Question 6

Which of the following does not describe the data in a data warehouse?

Accepted Answer

A)  integrated 
B)  subject-oriented 
C)  nonvolatile 
D)  dynamic 
A)  integrated 
B)  subject-oriented 
C)  nonvolatile 
D)  dynamic

Question 7

What is a goal of a distributed database?

Accepted Answer

A)  It should allow access to only a handful of trusted users. 
B)  It should provide an open architecture that organizations can customize as needed. 
C)  It should automatically normalize data. 
D)  It should feel and work like a single database to users. 
A)  It should allow access to only a handful of trusted users. 
B)  It should provide an open architecture that organizations can customize as needed. 
C)  It should automatically normalize data. 
D)  It should feel and work like a single database to users.

Question 8

Which of the following is a metalanguage designed for the exchange of data on the web?

Accepted Answer

A)  UML 
B)  URL 
C)  XML 
D)  HTTP 
A)  UML 
B)  URL 
C)  XML 
D)  HTTP

Question 9

A _____ is a single logical database that is physically divided among computers at several sites on a network.

Accepted Answer

A)  virtual database 
B)  back-end database 
C)  distributed database 
D)  cloud database 
A)  virtual database 
B)  back-end database 
C)  distributed database 
D)  cloud database

Question 10

JSON data is shared in _____.

Accepted Answer

A)  opening and closing tags 
B)  data schemas 
C)  comma-separated notation 
D)  key/value pairs 
A)  opening and closing tags 
B)  data schemas 
C)  comma-separated notation 
D)  key/value pairs

Question 11

NoSQL database system refers to "not only SQL."

Accepted Answer

A) True 
 B)False

Question 12

The data in a data warehouse is often made available to users through the direct use of SQL SELECT statements.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following types of NoSQL database systems are commonly used for artificial intelligence (AI) applications?

Accepted Answer

A)  document database management system 
B)  wide column store 
C)  graph database 
D)  key/value database 
A)  document database management system 
B)  wide column store 
C)  graph database 
D)  key/value database

Question 14

Compare how centralized systems were used when mainframes dominated data processing to how they are currently used.

Accepted Answer

In the past, centralized processing was

Question 15

Discuss four of Codd's 12 rules for a distributed database and his goal in formulating them.

Accepted Answer

Codd's 12 rules for a distributed databa

Question 16

What do you call a setup where Microsoft Access is stored on a file server and three trusted users access the database from their local computers?

Accepted Answer

A)  local computer architecture 
B)  client/server architecture 
C)  cloud computing 
D)  distributed architecture 
A)  local computer architecture 
B)  client/server architecture 
C)  cloud computing 
D)  distributed architecture

Question 17

In _____, clients perform the presentation functions, a database server performs the database functions, and application servers perform the business functions.

Accepted Answer

A)  three-tier architecture 
B)  open architecture 
C)  online transaction processing 
D)  centralized processing 
A)  three-tier architecture 
B)  open architecture 
C)  online transaction processing 
D)  centralized processing

Question 18

A _____ is a one-page grouping of key performance indicators (KPIs) that allow decision makers to evaluate and act on important data.

Accepted Answer

A)  box-and-whisker chart 
B)  stylesheet 
C)  dashboard 
D)  snapshot 
A)  box-and-whisker chart 
B)  stylesheet 
C)  dashboard 
D)  snapshot

Question 19

A _____ is a set of standards, development tools, and software libraries that help programmers develop software solutions faster and with more consistency.

Accepted Answer

A)  fat client 
B)  data warehouse 
C)  framework 
D)  Management Information System (MIS) 
A)  fat client 
B)  data warehouse 
C)  framework 
D)  Management Information System (MIS)

Question 20

Which of the following statements is true about selecting a DBMS?

Accepted Answer

A)  It is common for most organizations to conduct an independent analysis to compare DBMSs on an annual basis. 
B)  Large businesses are unlikely to switch from one DBMS to another because they have already made significant investments in their systems. 
C)  An important consideration when selecting a DBMS is that it supports COBOL. 
D)  Businesses often convert the majority of their data from one DBMS to another, even if they have been using one system for years. 
A)  It is common for most organizations to conduct an independent analysis to compare DBMSs on an annual basis. 
B)  Large businesses are unlikely to switch from one DBMS to another because they have already made significant investments in their systems. 
C)  An important consideration when selecting a DBMS is that it supports COBOL. 
D)  Businesses often convert the majority of their data from one DBMS to another, even if they have been using one system for years.

Which of the following could be described as a contemporary implementation of centralized architecture?

Which of the following is a technology that data scientists use to store and analyze big data?

Which of the following is not one of Codd's 12 rules for distributed databases?

Big data typically keeps track of common business transactions, such as accounts receivable and payroll.

Which of the following is a language for querying web-based documents and similarly structured data repositories?

Which of the following does not describe the data in a data warehouse?

What is a goal of a distributed database?

Which of the following is a metalanguage designed for the exchange of data on the web?

A _____ is a single logical database that is physically divided among computers at several sites on a network.

JSON data is shared in _____.

NoSQL database system refers to "not only SQL."

The data in a data warehouse is often made available to users through the direct use of SQL SELECT statements.

Which of the following types of NoSQL database systems are commonly used for artificial intelligence (AI) applications?

Compare how centralized systems were used when mainframes dominated data processing to how they are currently used.

Discuss four of Codd's 12 rules for a distributed database and his goal in formulating them.

What do you call a setup where Microsoft Access is stored on a file server and three trusted users access the database from their local computers?

In _____, clients perform the presentation functions, a database server performs the database functions, and application servers perform the business functions.

A _____ is a one-page grouping of key performance indicators (KPIs) that allow decision makers to evaluate and act on important data.

A _____ is a set of standards, development tools, and software libraries that help programmers develop software solutions faster and with more consistency.

Which of the following statements is true about selecting a DBMS?

Introduction to Database Management

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: SQL

The Relational Model: Advanced Topics

Database Design: Normalization

Database Design: Relationships

Database Management Systems Processes and Services

Database Industry Careers

Filters

Exam 9: Database Industry Trends

Which of the following could be described as a contemporary implementation of centralized architecture?

Which of the following is a technology that data scientists use to store and analyze big data?

Which of the following is not one of Codd's 12 rules for distributed databases?

Big data typically keeps track of common business transactions, such as accounts receivable and payroll. ​

Which of the following is a language for querying web-based documents and similarly structured data repositories?

Which of the following does not describe the data in a data warehouse?

What is a goal of a distributed database?

Which of the following is a metalanguage designed for the exchange of data on the web?

A _____ is a single logical database that is physically divided among computers at several sites on a network.

JSON data is shared in _____.

NoSQL database system refers to "not only SQL."

The data in a data warehouse is often made available to users through the direct use of SQL SELECT statements.

Which of the following types of NoSQL database systems are commonly used for artificial intelligence (AI) applications?

Compare how centralized systems were used when mainframes dominated data processing to how they are currently used.

Discuss four of Codd's 12 rules for a distributed database and his goal in formulating them.

What do you call a setup where Microsoft Access is stored on a file server and three trusted users access the database from their local computers?

In _____, clients perform the presentation functions, a database server performs the database functions, and application servers perform the business functions.

A _____ is a one-page grouping of key performance indicators (KPIs) that allow decision makers to evaluate and act on important data.

A _____ is a set of standards, development tools, and software libraries that help programmers develop software solutions faster and with more consistency.

Which of the following statements is true about selecting a DBMS?

Introduction to Database Management

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: SQL

The Relational Model: Advanced Topics

Database Design: Normalization

Database Design: Relationships

Database Management Systems Processes and Services

Database Industry Careers

Filters

Big data typically keeps track of common business transactions, such as accounts receivable and payroll.