Question 1

Explain how new application development projects might select a relational DBMS and give an example of their selection.

Accepted Answer

Although new application development projects, such as one creating a new web app or forming a startup business, have flexibility in terms of choosing database management software. other technologies such as the programming tools used to build the app or services of the business influence the selection. These projects consider the solution stack in which their other software participates and identify the relational DBMS used in the stack. For example, if the organization uses Linux as an operating system and Perl, PHP, or Python as a programming language, they will most like choose MySQL as their relational DBMS.

Question 2

Google searches and social media postings that direct traffic to a website are known as _____.

Accepted Answer

A)  conversions 
B)  channels 
C)  bounces 
D)  sessions 
A)  conversions 
B)  channels 
C)  bounces 
D)  sessions B

Question 3

_____ means that when using a distributed database, users feel that the data they work with comes from a single central database.

Accepted Answer

A)  Replication transparency 
B)  Continuous operation 
C)  Fragmentation transparency 
D)  Network independence 
A)  Replication transparency 
B)  Continuous operation 
C)  Fragmentation transparency 
D)  Network independence C

Question 4

Which of the following is information that Google Analytics does not provide?

Accepted Answer

A)  type of device used to access a website 
B)  accessibility of a website 
C)  session duration 
D)  bounce rate 
A)  type of device used to access a website 
B)  accessibility of a website 
C)  session duration 
D)  bounce rate

Question 5

What type of Excel chart would you create to compare the relative amount of sales between different categories of products within different regions as proportionally sized rings?

Accepted Answer

A)  Pie chart 
B)  Sunburst chart 
C)  Waterfall chart 
D)  Radar chart 
A)  Pie chart 
B)  Sunburst chart 
C)  Waterfall chart 
D)  Radar chart

Question 6

Because _____ read and write files as well as communicate with a centralized database, they run on a server.

Accepted Answer

A)  front-end technologies 
B)  back-end technologies 
C)  client applications 
D)  browsers 
A)  front-end technologies 
B)  back-end technologies 
C)  client applications 
D)  browsers

Question 7

_____ is a format for storing and transporting data often used when data is sent from a server to a webpage.

Accepted Answer

A)  Unified Modeling Language (UML) 
B)  JavaScript Object Notation (JSON) 
C)  Uniform Resource Locator (URL) 
D)  Element Markup Language (EML) 
A)  Unified Modeling Language (UML) 
B)  JavaScript Object Notation (JSON) 
C)  Uniform Resource Locator (URL) 
D)  Element Markup Language (EML)

Question 8

A(n) _____ is a special data type for complex data such graphics, drawings, photographs, video, and sound.

Accepted Answer

A)  Extensible Data Schema (XS
D)  
B)  online analytical processing (OLAP) 
C)  binary large object (BLO
B)  
D)  special complex object (SCO
B)  
A)  Extensible Data Schema (XS
D)  
B)  online analytical processing (OLAP) 
C)  binary large object (BLO
B)  
D)  special complex object (SCO
B)

Question 9

Which of the following is not a defining characteristic of big data?

Accepted Answer

A)  velocity 
B)  variety 
C)  virtual 
D)  volume 
A)  velocity 
B)  variety 
C)  virtual 
D)  volume

Question 10

Which of the following is not a type of NoSQL database system?

Accepted Answer

A)  OLAP database 
B)  graph database 
C)  document database management system 
D)  wide column store 
A)  OLAP database 
B)  graph database 
C)  document database management system 
D)  wide column store

Question 11

In a centralized database architecture, a single, centrally located computer system processes all data.

Accepted Answer

A) True 
 B)False

Question 12

Git and GitHub operate on what type of distributed database model?

Accepted Answer

A)  snapshot 
B)  master-slave 
C)  client/server 
D)  object-oriented 
A)  snapshot 
B)  master-slave 
C)  client/server 
D)  object-oriented

Question 13

Which of the following is considered a very popular, open source, back-end software stack?

Accepted Answer

A)  LAMP (Linux, Apache, MySQL, PHP) 
B)  WINS (Windows, Internet Information Services, .NET, SQL Server) 
C)  Ruby on Rails (Ruby, Rails, SQLite) 
D)  MEAN (MongoDB, Express.js, AngularJS, Node.js) 
A)  LAMP (Linux, Apache, MySQL, PHP) 
B)  WINS (Windows, Internet Information Services, .NET, SQL Server) 
C)  Ruby on Rails (Ruby, Rails, SQLite) 
D)  MEAN (MongoDB, Express.js, AngularJS, Node.js)

Question 14

Which of the following is a data visualization tool that typically summarizes data from three or more fields?

Accepted Answer

A)  PivotChart 
B)  histogram 
C)  dashboard 
D)  graph database 
A)  PivotChart 
B)  histogram 
C)  dashboard 
D)  graph database

Question 15

In object-oriented technologies, what is a class?

Accepted Answer

A)  an object that functions as a blueprint for more objects 
B)  a characteristic of an object 
C)  something an object can do 
D)  a collection of data types 
A)  an object that functions as a blueprint for more objects 
B)  a characteristic of an object 
C)  something an object can do 
D)  a collection of data types

Question 16

What type of Excel chart compares values across geographical locations?

Accepted Answer

A)  Globe chart 
B)  Atlas chart 
C)  GPS chart 
D)  Map chart 
A)  Globe chart 
B)  Atlas chart 
C)  GPS chart 
D)  Map chart

Question 17

Which of the following is not a common data file format that database management systems use to export data?

Accepted Answer

A)  comma-separated values (CSV) 
B)  Excel workbook (XLSX) 
C)  Open Database Connectivity (ODB
C)  
D)  PowerPoint presentation (PPTX) 
A)  comma-separated values (CSV) 
B)  Excel workbook (XLSX) 
C)  Open Database Connectivity (ODB
C)  
D)  PowerPoint presentation (PPTX)

Question 18

_____ refers to the hardware and software an organization needs to address the analytical requirements of users without detracting from traditional operations.

Accepted Answer

A)  Encapsulation 
B)  Fat client architecture 
C)  Data warehouse architecture 
D)  Local area network 
A)  Encapsulation 
B)  Fat client architecture 
C)  Data warehouse architecture 
D)  Local area network

Question 19

Explain when you are likely to use a NoSQL DBMS and when you are likely to use an object-oriented DBMS.

Accepted Answer

NoSQL is often used for web apps, recomm

Question 20

Which of the following is not a high-level programming language?

Accepted Answer

A)  C++ 
B)  Java 
C)  Assembler 
D)  PHP 
A)  C++ 
B)  Java 
C)  Assembler 
D)  PHP

Explain how new application development projects might select a relational DBMS and give an example of their selection.

Google searches and social media postings that direct traffic to a website are known as _____.

_____ means that when using a distributed database, users feel that the data they work with comes from a single central database.

Which of the following is information that Google Analytics does not provide?

What type of Excel chart would you create to compare the relative amount of sales between different categories of products within different regions as proportionally sized rings?

Because _____ read and write files as well as communicate with a centralized database, they run on a server.

_____ is a format for storing and transporting data often used when data is sent from a server to a webpage.

A(n) _____ is a special data type for complex data such graphics, drawings, photographs, video, and sound.

Which of the following is not a defining characteristic of big data?

Which of the following is not a type of NoSQL database system?

In a centralized database architecture, a single, centrally located computer system processes all data.

Git and GitHub operate on what type of distributed database model?

Which of the following is considered a very popular, open source, back-end software stack?

Which of the following is a data visualization tool that typically summarizes data from three or more fields?

In object-oriented technologies, what is a class?

What type of Excel chart compares values across geographical locations?

Which of the following is not a common data file format that database management systems use to export data?

_____ refers to the hardware and software an organization needs to address the analytical requirements of users without detracting from traditional operations.

Explain when you are likely to use a NoSQL DBMS and when you are likely to use an object-oriented DBMS.

Which of the following is not a high-level programming language?

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

Explain how new application development projects might select a relational DBMS and give an example of their selection.

Google searches and social media postings that direct traffic to a website are known as _____.

_____ means that when using a distributed database, users feel that the data they work with comes from a single central database.

Which of the following is information that Google Analytics does not provide?

What type of Excel chart would you create to compare the relative amount of sales between different categories of products within different regions as proportionally sized rings?

Because _____ read and write files as well as communicate with a centralized database, they run on a server.

_____ is a format for storing and transporting data often used when data is sent from a server to a webpage.

A(n) _____ is a special data type for complex data such graphics, drawings, photographs, video, and sound.

Which of the following is not a defining characteristic of big data?

Which of the following is not a type of NoSQL database system?

In a centralized database architecture, a single, centrally located computer system processes all data.

Git and GitHub operate on what type of distributed database model?

Which of the following is considered a very popular, open source, back-end software stack?

Which of the following is a data visualization tool that typically summarizes data from three or more fields?

In object-oriented technologies, what is a class?

What type of Excel chart compares values across geographical locations?

Which of the following is not a common data file format that database management systems use to export data?

_____ refers to the hardware and software an organization needs to address the analytical requirements of users without detracting from traditional operations.

Explain when you are likely to use a NoSQL DBMS and when you are likely to use an object-oriented DBMS.

Which of the following is not a high-level programming language?

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