Deck 2: The Relational Model: Introduction, Qbe, and Relational Algebra

Question 1

Which of the following is not a database policy area that database administrators typically are responsible for?

A)analyzing sales and expenses
B)granting access privileges
C)creating and testing a disaster recovery plan
D)setting up proper database security

Answer 1

A

Question 2

Which of the following SQL statements allows a user named mgarcia to select, insert, update, delete, and create a constraint in the Products table?

A)ALLOW ALL ON Products TO mgarcia;
B)GRANT SELECT FROM Products TO mgarcia;
C)GIVE PRIVILEGES ON Products TO mgarcia;
D)GRANT ALL ON Products TO mgarcia;

Answer 2

D

Question 3

Which of the following is a relatively new career in the database industry?

A)DBA
B)database operations manager
C)chief information officer
D)data scientist

Answer 3

D

Question 4

Which database professional primarily focuses on system administration such as installation, performance, and maintenance?

A)application DBA
B)product manager
C)system DBA
D)data operations manager

Question 5

Data scientists look for patterns and trends in data to discover new opportunities and solutions.

Question 6

The database architect focuses on database design.

Question 7

_____ is a large set of nontraditional data that may be used to gain meaningful business insights or predict significant business events.

A)A virtual sandbox
B)Hot data
C)Big data
D)Business intelligence

Question 8

Which of the following is generally not considered a traditional business operation for all sizes of businesses?

A)data warehousing
B)billing
C)payroll
D)accounts receivable

Question 9

Which of the following is not a major category of responsibility for typical database administrators?

A)database technical functions
B)database administrative functions
C)data-entry management
D)database policy formation and enforcement

Question 10

A _____specifies the ongoing and emergency actions and procedures required to ensure data remains available if an event such as a cyberattack or hurricane occurs.

A)mission-critical plan
B)database operation plan
C)disaster recovery plan
D)data modeling plan

Question 11

Which of the following database professionals is most likely to manage indexes?

A)database operations manager
B)performance analyst
C)database architect
D)data modeler

Question 12

What is the primary focus of the latest emerging careers in the database industry?

A)management and security of internal, transactional data
B)analysis of internal, external, and big data
C)compliance management
D)installation and training of enterprise database management systems

Question 13

What acronym refers to the traditional business operations of general ledger, accounts payable, and payroll?

A)GAP
B)GLAPPR
C)GENAPP
D)GENLEG

Question 14

The hardware, software, and database that users and regular applications of the company use is called the _____.

A)production system
B)test system
C)sandbox
D)cold site

Question 15

Which of the following is typically not a requirement for a successful career as a database administrator?

A)educational credentials
B)direct contact with customers
C)industry certifications
D)successful business experience

Question 16

A database administrator (DBA) usually reports directly to the chief financial officer (CFO).

Question 17

What do you call the log of all database maintenance, with information such as dates, license keys, and issues or updates?

A)archive
B)cloud backup
C)data warehouse
D)run-book

Question 18

Which of the following is generally not considered a source of big data?

A)online reviews
B)social media posts
C)comments on blogs
D)sales transactions

Question 19

A data analyst is generally responsible for improving the performance of a database.

Question 20

The primary task of a database administrator (DBA) is to ensure that a database is available as needed and is protected and secured from unauthorized users and activities.

Question 21

A(n) _____ analyzes massive sets of internal, external, and big data to help an organization make faster and better decisions.

A)data visualizer
B)data scientist
C)system DBA
D)application DBA

Question 22

Which of the following is not a typical qualification for a data scientist?

A)strong data modeling skills
B)experience with big data technologies
C)data visualization skills
D)advanced degree in computer science

Question 23

Which of the following positions is a typical prerequisite for a data scientist?

A)product manager
B)chief information officer
C)statistician
D)chief security officer

Question 24

Which of the following is not a technology that a data warehouse administrator typically manages?

A)business intelligence (BI)
B)extract, transform, load (ETL)
C)Online Analytical Processing (OLAP)
D)spyware/malware detection software (SMDS)

Question 25

_____ represents information in the form of a chart, diagram, or picture.

A)Business modeling
B)Big data
C)Data visualization
D)Data normalization

Question 26

Which of the following is not a programming language commonly used by data scientists?

A)Hadoop
B)C#
C)SQL
D)Python

Question 27

What do data scientists typically look for as they analyze data?

A)mathematical errors
B)database performance indicators
C)missing data
D)patterns and trends

Question 28

Which of the following database professionals uses programming algorithms and applies statistics to analyze large sets of data?

A)data entry technician
B)data scientist
C)application DBA
D)data modeler

Question 29

Which of the following database professionals most likely helps others understand patterns in data in formats other than lists, summarized reports, and other statistical presentations?

A)data scientist
B)data visualization expert
C)business analyst
D)data modeler

Question 30

_____ is an open source distributed processing framework for managing and processing very large sets of data.

A)GLAPPR
B)Hadoop
C)Python
D)SQL Server

Question 31

Which of the following is one of the most identifiable entry-level database industry job titles?

A)chief security officer
B)data analyst
C)application DBA
D)data visualization expert

Question 32

Which of the following is not a typical area that a database operations manager focuses on?

A)security
B)government regulations
C)database performance
D)backup and recovery

Question 33

Which of the following database professionals would focus on how large-scale research produces better products?

A)data archivist
B)data visualization expert
C)database operations manager
D)data scientist

Question 34

Which of the following is not one of the top five database certifications?

A)MySQL Certified Database Analyst
B)IBM Certified Database Administrator-DB2
C)Oracle Certified Professional, MySQL Database Administrator
D)Microsoft SQL Server database certification

Question 35

Which of the following is not true about the database industry?

A)Most job outlook articles predict that the database industry will continue with high growth.
B)New certifications on emerging database technologies are constantly being developed.
C)Traditional data management and more recent data analysis positions are both in high demand.
D)Positions as a data analyst or data scientist continue to grow, but not other database fields.

Question 36

A _____ completes the statistical and graphical analysis of internal data such as sales figures and operational expenses to help an organization make faster and better decisions.

A)data archivist
B)database operations manager
C)task-oriented DBA
D)data analyst

Question 37

Data visualization is not a feature of which software product?

A)Microsoft Excel
B)Tableau
C)Microsoft Visio
D)Hadoop

Question 38

Which of the following does a data analyst typically work with?

A)data compliance issues
B)database maintenance
C)business transactions
D)government regulations

Question 39

Which of the following is not a typical qualification for a data analyst?

A)strong graphic design skills
B)Bachelor's degree in computer science
C)Microsoft Access and Excel skills
D)strong SQL skills

Question 40

Which of the following database professionals most likely uses SQL to summarize and analyze data to extract trends, insights, and knowledge?

A)database architect
B)task-oriented DBA
C)system DBA
D)database analyst

Question 41

Which of the following SQL statements rescinds privileges for user kchen05 to create constraints and delete data in the Customers table?

A)REVOKE ALL ON Customers TO kchen05;
B)REVOKE CONSTRAINTS, DELETE ON Customers TO kchen05;
C)REVOKE REFERENCES, DELETE ON Customers TO kchen05;
D)RESCIND REFERENCES, DELETE ON Customers TO kchen05;

Question 42

What do organizations install to detect and stop cyberattack threats at the point of attack?

A)backup protocols
B)disaster recovery plans
C)biometric technologies
D)spyware/malware detection software

Question 43

_____ the design of a database includes creating and deleting indexes, minimizing the complexity of each view, and changing the table design.

A)Normalizing
B)Tuning
C)Synchronizing
D)Testing

Question 44

A _____ is a duplicate instance of a single, shared database to balance the workload among CPUs.

A)parallel database system
B)sandbox
C)test system
D)archived database system

Question 45

Describe what a data visualization expert does to support an organization's efforts.

Question 46

Discuss the steps that organizations take to protect their data against hard drive failures and electrical power interruptions or outages.

Question 47

Compare traditional database careers with new emerging database careers.

Question 48

What is the DBA's role with regard to access privileges?

Question 49

Describe the role of the data scientist in an organization, including technology businesses.

Question 50

Which of the following laws does not govern data access, retention, and destruction?

A)Sarbanes-Oxley (SOX) Action
B)Hatch Act
C)Health Insurance Portability and Accountability Act (HIPAA)
D)Presidential Records Act