Question 1

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)  C

Question 2

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 3

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 A

Question 4

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

Question 5

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.

Question 6

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 7

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 8

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 9

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 10

In cloud computing, although many clients share the same resources, a company's systems operate as if they were running on their own dedicated system because of _____.

Accepted Answer

A) abstraction 
B) crowdsourcing 
C) embedded analytics 
D) virtualization 
A) abstraction 
B) crowdsourcing 
C) embedded analytics 
D) virtualization

Question 11

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

You use OLAP software to access a(n) _____.

Accepted Answer

A) server farm 
B) proprietary architecture 
C) OLAP table 
D) data warehouse 
A) server farm 
B) proprietary architecture 
C) OLAP table 
D) data warehouse

Question 15

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 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

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 20

Identify the type of data stored in data warehouses and how organizations use it. Use the terms "snapshot" and "data mining" in your answer.

Accepted Answer

A data warehouse contains read-only snap

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

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

In object-oriented technologies, what is a class?

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

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

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 is not one of Codd's 12 rules for distributed databases?

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

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

In cloud computing, although many clients share the same resources, a company's systems operate as if they were running on their own dedicated system because of _____.

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

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

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

You use OLAP software to access a(n) _____.

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

JSON data is shared in _____.

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

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

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

Identify the type of data stored in data warehouses and how organizations use it. Use the terms "snapshot" and "data mining" in your answer.

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

Database Industry Trends

Filters

Exam 1: Introduction to Database Management

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

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

In object-oriented technologies, what is a class?

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

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

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 is not one of Codd's 12 rules for distributed databases?

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

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

In cloud computing, although many clients share the same resources, a company's systems operate as if they were running on their own dedicated system because of _____.

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

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

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

You use OLAP software to access a(n) _____.

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

JSON data is shared in _____.

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

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

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

Identify the type of data stored in data warehouses and how organizations use it. Use the terms "snapshot" and "data mining" in your answer.

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

Database Industry Trends

Filters

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