Question 1

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

Accepted Answer

Google Analytics does not directly measure the accessibility of a website. It focuses on user interactions such as device type, session duration, and bounce rate, rather than assessing how accessible a website is for users with disabilities.

Question 2

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.

Accepted Answer

Large businesses are less likely to switch from one DBMS to another due to the significant investments (both financial and time) they have already made in their current systems. This includes the cost of licenses, training, and migrating data, which can be prohibitively expensive and complex.

Question 3

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)

Accepted Answer

ODBC (Open Database Connectivity) is not a data file format; it is a standard API for accessing database management systems (DBMS). The other options (CSV, XLSX, and PPTX) are file formats, but PPTX is not commonly used for exporting data from DBMS; it is primarily used for presentations.

Question 4

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

Accepted Answer

Volume in the context of big data refers to the sheer amount of data generated and stored across various sources. It highlights the scale of data collection and management challenges.

Question 5

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)

Accepted Answer

A framework provides a standardized way to build and deploy applications. It includes a set of pre-built components, libraries, and tools that developers can use to streamline the development process, ensuring faster and more consistent software development.

Question 6

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

Accepted Answer

The answer of Which of the following is a technology...

Question 7

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

Accepted Answer

Back-end technologies are responsible for server-side operations, including reading and writing files and communicating with databases, which is why they run on a server.

Question 8

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)

Accepted Answer

LAMP (Linux, Apache, MySQL, PHP) is a popular, open source, back-end software stack.

Question 9

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

Accepted Answer

Graph databases are commonly used for AI applications because they efficiently handle and analyze complex relationships and interconnected data, which are often required in AI tasks.

Question 10

Google searches and social media postings that direct traffic to a website are known as _____.
A)conversions
B)channels
C)bounces
D)sessions

Accepted Answer

Channels are the means through which traffic is directed to a website, including Google searches and social media postings.

Question 11

Which of the following is a metalanguage designed for the exchange of data on the web?
A)UML
B)URL
C)XML
D)HTTP

Accepted Answer

XML (Extensible Markup Language) is a metalanguage designed for the exchange of data on the web. It allows for the creation of custom tags to facilitate the sharing of structured data across different information systems, particularly via the Internet.

Question 12

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

Accepted Answer

A class in object-oriented programming is essentially a blueprint or template from which objects are created. It defines the properties (attributes) and behaviors (methods) that the instantiated objects will have.

Question 13

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

Accepted Answer

In an Object-Oriented Database Management System (OODBMS), an object is a set of related attributes (properties or data) along with the actions (methods) that are associated with the set of attributes. This encapsulation of data and behavior is a fundamental concept of object-oriented programming and database management.

Question 14

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

Accepted Answer

JavaScript Object Notation (JSON) is widely used for storing and transporting data, especially in web applications where data is sent from a server to a client's webpage. It is lightweight and easy for humans to read and write, as well as for machines to parse and generate.

Question 15

JSON data is shared in _____.
A)opening and closing tags
B)data schemas
C)comma-separated notation
D)key/value pairs

Accepted Answer

JSON data is structured in key/value pairs, making it easy to read and map directly to data structures in most programming languages.

Question 16

Which of the following is not a high-level programming language?
A)C++
B)Java
C)Assembler
D)PHP

Accepted Answer

Assembler is not a high-level programming language; it is a low-level programming language designed for specific types of processors, translating assembly language into machine code.

Question 17

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)

Accepted Answer

Binary Large Object (BLOB) is the correct term for a data type that can store large amounts of complex data such as images, multimedia files, and other binary formats.

Question 18

Which of the following is not a defining characteristic of big data?
A)velocity
B)variety
C)virtual
D)volume

Accepted Answer

Big data is characterized by three main attributes: volume (the amount of data), velocity (the speed of data in and out), and variety (the range of data types and sources). "Virtual" is not considered a defining characteristic of big data.

Question 19

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

Accepted Answer

OLAP (Online Analytical Processing) databases are designed for complex analytical and ad-hoc queries, typically in data warehousing scenarios. They are not categorized under NoSQL databases. NoSQL databases include types like graph databases, document databases, and wide column stores, which are designed for high scalability and flexibility to handle unstructured or semi-structured data.

Question 20

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)

Accepted Answer

XQuery is specifically designed for querying XML data, which is a common format for web-based documents and similarly structured data repositories.

Quiz 1: Introduction to Database Management

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

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

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

When referring to big data, volume means _____.

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 a technology that data scientists use to store and analyze big data?

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

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

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

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

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

In object-oriented technologies, what is a class?

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

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

JSON data is shared in _____.

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

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?

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