Deck 1: Introduction to Database Management

Question 1

What is a goal of a distributed database?

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.

Answer 1

D

Question 2

What do you call the prediction that the number of transistors on a chip is likely to double every two years?

A)Hopper's Theorem
B)Moore's Law
C)Open Architecture Law
D)Ruby on Rails

Answer 2

B

Question 3

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

Answer 3

False

Question 4

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?

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

Question 5

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 _____.

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

Question 6

NoSQL database system refers to "not only SQL."

Question 7

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

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

Question 8

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

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

Question 9

Which database technology optimizes data for querying, analyzing, and reporting?

A)Open Database Connectivity (ODBC)
B)online transaction processing (OLTP)
C)online analytical processing (OLAP)
D)Unified Modeling Language (UML)

Question 10

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

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

Question 11

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

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

Question 12

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

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

Question 13

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

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

Question 14

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

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

Question 15

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

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

Question 16

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

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

Question 17

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

Question 18

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

Question 19

Some organizations use legacy programs for years to avoid the time and effort of converting to a new system.

Question 20

What do you call an arrangement of location data with three levels, such as cities within states within countries?

A)hierarchy
B)virtualized
C)framework
D)snapshot

Question 21

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

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

Question 22

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

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 23

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

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

Question 24

When referring to big data, volume means _____.

A)types of data, including text, numbers, pictures, video, and clicks
B)the amount of data from many sources
C)the speed at which the data is created
D)the loudness or softness of audio data

Question 25

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

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

Question 26

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

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

Question 27

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

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

Question 28

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

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 29

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

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

Question 30

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

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

Question 31

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

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

Question 32

In object-oriented technologies, what is a class?

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 33

In an OODBMS, a(n) _____ is a set of related attributes along with the actions that are associated with the set of attributes.

A)data type
B)object
C)level
D)key/value pair

Question 34

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

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

Question 35

JSON data is shared in _____.

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

Question 36

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

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

Question 37

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

A)Extensible Data Schema (XSD)
B)online analytical processing (OLAP)
C)binary large object (BLOB)
D)special complex object (SCOB)

Question 38

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

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

Question 39

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

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

Question 40

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

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

Question 41

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

Question 42

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

Question 43

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

Question 44

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?

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

Question 45

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

Question 46

What type of Excel chart compares values across geographical locations?

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

Question 47

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

Question 48

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

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

Question 49

Which of the following is not software that is primarily used for data visualization?

A)Tableau
B)Microsoft Power BI
C)Adobe Dreamweaver
D)Microsoft Excel

Question 50

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

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