Database exam 3

A query creates a Cartesian join between one table with 5 records and another with 20 records. How many records are displayed in the results - 25 - 15 - 100 - 4

100

In Microsoft Access, what do you need to decrypt an Encrypted database - Backup software - A password - An administrator account - 128-Bit decryption software

A password

A ________ is a field that contains unique data for each record in the table but is not used as the primary key field for security or other reasons - Alternate key - Secondary key - Associate key - Backup key

Alternate Key

Which of the following is a database-as-a-service product - SQL server - Amazon relational Database Service - Oracle - Apache Database Service

Amazon relational database service

In object-oriented technologies, what is a class - A characteristic of an object - A collection of data types - Something an object can do - An object that functions as a blueprint for more objects

An object that functions as a blueprint for more objects

What is the primary focus of the latest emerging careers in the database industry - Compliance management - Analysis of internal, external, and big data - Installation and training of enterprise database management systems - Management and security of internal, transactional data

Analysis of internal, external, and big data

Which of the following is not a database policy area that database administrators typically are responsible for - Granting access privileges - Creating and testing a disaster recovery plan - Analyzing sales and expenses - Setting up proper database security

Analyzing sales and expenses

Which of the following is not a high-level programming language - C++ - PHP - Java - Assembler

Assembler

In an entity-relationship model (ERM), what information appears in ovals - Attributes - Relationships - Entities - Dependencies

Attributes

what technique is used to identify the person who is attempting to access the DBMS - Encryption - Synchronization - Viewing - Authentication

Authentication

Because __________ read and write files as as communicate with a centralized database, they run on a server - Back-end technologies - Browsers - Front-end technologies - Client applications

Back-end technologies

Which of the following is not a common security feature used by database management systems - Encryption - Authentication - Backward recovery - Authorization

Backward recovery

A _______ is a special data type for complex data such graphics, drawings, photographs, video, and sound - Online analytical processing (OLAP) - Binary large object (BLOB) - Special complex object (SCOB) - Extensible data schema (XSD)

Binary large object (BLOB)

Which of the following does a data analyst typically work with - Database maintenance - Government regulations - Data compliance issues - Business transactions

Business transactions

Google searches and social media postings that direct traffic to a website are known as _________ - Sessions - Bounces - Channels - Conversions

Channels

In Database Design Language (DBDL), which items do you underline - Columns that make up the primary key - Columns that make up the foreign key - Table names - Data types

Columns that make up the primary key

In an entity-relationship model (ERM) for a many to many relationship what do you call the middle entity that links two other tables - Composite entity - Consolidated entity - Secondary entity - Linking entity

Composite entity

How might you resolve an inappropriate Cartesian join - Connect the two tables through a third junction table - Convert the join type to a RIGHT join - Convert the join type to a LEFT join - Change the query to an update query

Connect the two tables through a third junction table

The acronym CRUD stands for - Catalog, report, user, data - Commit, recover, undo, and decrypt - Credentials, read-only, unique, double - Create, read, update, and delete

Create, read, update, and delete

Which of the following. is a type of E-R diagram - Database design language (DBDL) - Access Database Documenter - Crow's foot notation - Entity tree notation

Crow's foot notation

A __________ is a one-page grouping of key performance indicators (KPIs) that allow decision makers to evaluate and act on important data - Stylesheet - Dashboard - Snapshot - Box-and-whisker chart

Dashboard

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 - Data analyst - Data archivist - Task-oriented DBA - Database operations manager

Data analyst

Which of the following is one of the most identifiable entry-level database industry job titles - Database visualization expert - Application DBA - Data analyst - Chief security

Data analyst

Which of the following is information that the Access Database Documenter does not provide - All objects in the database - Data in each field - Fields in each table - Relationships between tables

Data in each field

Which concept of a DBMS means that you change the database structure without requiring you to change the programs that access the database - Data integrity constraints - Key integrity constraints - Field independence - Data independence

Data independence

What type of constraints help to ensure the accuracy and consistency of field values - Key integrity constraints - Referential constraints - Data integrity constraints - Security constraints

Data integrity constraints

Which of the following is a valid reason for creating a one-to-one relationship between two tables - The tables are rarely updated - One table would otherwise not participate in a relationship - The tables create a Cartesian join - The data needs to be imported from separate sources

Data needs to be imported from separate sources

A ___________ analyzes massive sets of internal, external, and big data to help an organization make faster and better decisions - Data visualizer - System DBA - Data scientist - Application DBA

Data scientist

Which of the following database professionals uses programming algorithms and applies statistics to analyze large sets of data - data scientist - Data entry technician - Data modeler - Application DBA

Data scientist

Which of the following database professionals would focus on how large-scale research produces better products - Data scientist - Data visualization expert - Database operations manager - Data archivist

Data scientist

Which type of data integrity constraint States that the value entered for any field should be consistent with the data type for that field - Format - Secondary - Data type - Legal value

Data type

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 - Data visualization expert - Data scientist - Data modeler - Business analyst

Data visualization expert

Which of the following is not a typical qualification for a data scientist - Strong data modeling skills - Data visualization skills - Experience with big data technologies - Advanced degree in computer science

Data visualization skills

__________ refers to the hardware and software an organization needs to address the analytical requirements of users without detracting from traditional operations - Data warehouse architecture - Encapsulation - Local area network - Fat client architecture

Data warehouse architecture

Which of the following is generally not considered a traditional business operations for all sizes of business - Payroll - Accounts receivable - Billing - Data warehousing

Data warehousing

Which of the following database professionals most likely uses SQL to summarize and analyze data to extract trends, insights, and knowledge - Database analyst - System DBA - Database architect - Task-oriented DBA

Database analyst

Which of the following is typically not a requirement for a successful career as a database administrator - Successful business experience - Industry certifications - Direct contact with customers - Educational credentials

Direct contact with customers

A ________ is a single logical database that is physically divided among computers at several sites on a network - Back-end database - Distributed database - Virtual database - Cloud database

Distributed database

Which of the following does not describe the data in a data warehouse - Nonvolatile - Dynamic - Integrated - Subject-oriented

Dynamic

To support data independence, you should _________ in an SQL SELECT command - Explicitly list all the required fields - Use the * wildcard to represent all fields - Only list fields from a single table - Avoid using more than five fields

Explicitly list all the required fields

Which fields should you index in a table - Fields that are commonly used for sorting - Fields that contain sensitive data - Every field - Fields that are not part of a relationship

Fields that are commonly used for sorting

What can you create in Access to show data in a single record and all its related records - Related user views - one-to-one relationship - Form and subform - Lookup reports

Form and subform

Which of the following is not a common service provided by a database management system - Update and retrieve data - Provide catalog services - Recover data - Format user views, forms, and reports

Format user views, forms, and reports

A _________ is a set of standards, development tools, and software libraries that help programmers develop software solutions faster and with more consistency - Data warehouse - Management information system (MIS) - Framework - Fat client

Framework

Which of the following demostrates the concept of a distributed database - Git - CRUD - ACID - LAMP

Git

Which of the following types of NoSQL database systems are commonly used for artificial intelligence (AI) applications - Graph database - Document database mangement system - Wide column store - Key/value database

Graph database

_________ are actions that are performed on resources or files at the server - HTTP methods - Solutions stacks - SQL scripts - SQL keywords

HTTP methods

___________ is an open source distributed processing framework for managing and processing very large sets of data - GLAPPR - Python - Hadoop - SQL server

Hadoop

Which of the following is a technology that data scientists use to store and analyze big data - Wordpress - Hadoop - XQuery - SQLite

Hadoop`

Which of the following laws does not govern data access, retention, and destruction - Health insurance portability and accountability act (HIPAA) - Hatch act - Presidential records act - Sarbones-Oxley (SOX) action

Hatch act

During which process do you typically create an entity-relationship diagram - Information-level design - Maintenance - Physical-level design - Troubleshooting user views

Information-level design

Which Access feature restricts a field to a special format for entering data - Input Mask - Lookup properties - Validation text property - Object dependencies

Input mask

What is a goal of a distributed database - It should allow access to only a handful of trusted users - It should feel and work like a single database to users - It should provide an open architecture that organizations can customize as needed - It should automatically normalize data

It should feel and work like a single database to users

___________ is a format for storing and transporting data often used when data is sent from a server to a webpage - Element markup language (EML) - Uniform resource locator (URL) - Javascript object notation (JSON) - Unified modeling language (UML)

Javascript object notation (JSON)

Because you cannot directly create a many-to-many relationship between two tables, what must you create to link the tables together - Cartesian join - entity-relationship diagram - secondary table - junction table

Junction table

JSON data is shared in _________ - Opening and closing tags - Comma-separated notation - Key/value pairs - Data schemas

Key/value pairs

Which go the following statements is true about selecting a DBMS - Large businesses are unlikely to switch from one DBMS to another because they have already made significant investments in their systems - It is common for most organizations to conduct an independent analysis to to compare DBMSs on an annual basis - Businesses often convert the majority of their data from one DBMS to another, even if they have been using one system for years - An important consideration when selecting a DBMS is that it supports COBAL

Large businesses are unlikely to switch from one DBMS to another because they have already made significant investments in their systems

Which of the following fields would you most likely index but set index's unique property to no - EmployeeID - LastName - OfficeNumber - StreetAddress

LastName

If you want to constrain a Bonus field to values, 250, 500, and 750, what type of constraint should you apply - Integrity - Legal values - Fieldname - Expression

Legal values

Which properties do you set to display a list of possible values that are helpful when you enter or update data in a foreign key fields - Lookup properties - Indexed properties - Subdatasheet properties - Foreign Key List properties

Lookup Properties

Which of the following Access features provides a drop-down list of values for a field - Subdatasheet - Subform - Relationship report - Lookup field

Lookup field

In a database catalog, ________ includes information about the relationships, views, indexes, and properties - An after image - Metadata - A transaction - Authentication

Metadata

What do you call the predication that the number of transistors on a chip is likely to double every two years - Moore's law - Open architecture law - Hopper's theorem - Ruby on Rails

Moore's law

Which of the following is not one of the top five database certifications - Microsoft SQL Server database certification - Oracle Certified professional, MySQL database administrator - IBM certified database administrator ---DB2 - MySQL certified database analyst

MySQL certified database analyst

Which of the following is not a type of NoSQL database system - OLAP database - Wide column store - Document database management system - Graph database

OLAP database

In an OODBMS a __________ is a set of related attributes along with the actions that are associated with the set of attributes - Data type - Object - Key/value pair - Level

Object

In a database for a health care clinic, a medical specialty is listed once in the Specialties table, but each speciality may be linked too many doctors in the Doctors table. What type of relationship do the Specialties and Doctors tables have - One to one - Many to many - Many to one - One to many

One to many

What type of relationship do two tables have when their primary keys match - Many-to-many - One-to-one - Many-to-one - One-to-many

One-to-one

A _________ is a duplicate of a single, shared database to balance the workload amount CPUs - Sandbox - Parallel database system - Archived database system - Test system

Parallel database system

What do data scientists typically look for as they analyze data - Patterns and trends - Mathematical errors - Missing data - Database performance indicators

Patterns and trends

Which of the following database professionals is most likely to manage indexes - Data mideler - Database operations manager - Performance analyst - Database architect

Performance analyst

Building the entities, attributes, constraints and relationships in a particular RDBMS is called - Conceptual design - Entity relationship diagram - Physical-level design - Information-level design

Physical-level design

Which of the following is not true about the database industry - Traditional data management and more recent data analysis positions are both in high demand - New certifications on emerging database technologies are constantly being developed - Positions as a database analyst or data scientist continue to grow, but not other database fields - Most job outlook articles predict that the database industry will continue with high growth

Positions as a data analyst or data scientist continue to grow, but not other database fields

Which of the following items is not identified in relational database design documentation - Attributes needed for each normalized entity - Possible user views for each entity - Primary key field for each entity - Proper one-to-many relationships between the entities

Possible user views for each entity

Which of the following is not a common data file format that database management systems use to export data - Comma-separated values (CSV) - Excel workbook (XLSX) - Open database connectivity (ODBC) - Powerpoint presentation (PPTX)

Powerpoint Presentation (PPTX)

What do key integrity constraints consist of - Primary key and foreign key constraints - Primary key and alternative key constraints - Authorization permissions - Smart card limitations

Primary key and foreign key constraints

The hardware, software, and database that users and regular applications the company use is called the __________ - Test system - Sandbox - Cold site - Production system

Production system

Which of the following SQL statements rescinds privileges for user kcchen05 to create constraints and delete data in the Customers table - REVOKE REFERENCES, DELETE ON Customers TO kchen05; - RESCIND REFERENCES, DELETE ON Customers TO kchen05; - REVOKE ALL ON Customers TO kchen05; - REVOKE CONSTRAINTS, DELETE ON Customers TO kchen05;

REVOKE REFERENCES, DELETE ON Customers TO kchen05;

_________ is the process of returning a database that has encountered a problem to a state known to be correct - Isolating - Recovery - Committing - Cataloging

Recovery

A one-to-many relationship with ________ means that a record in the parent table must be established before a related record in the child table can be entered - Referential integrity - Alternate keys - Cardinality - Access restrictions

Referential integrity

Which of the following Access tools shows the database schema - Navigation pane - Object Dependencies pane - Relationship report - System catalog

Relationship report

The E-R model (ERM) represents entities, attributes, and - Relationships - Views - Indexes - Properties

Relationships

Which of the following is not of Codd's 12 rules for distributed databases - Reliance on a central site - Continuous operation - Hardware independence - Location transparency

Reliance on a central site

What do you call the log of all database maintenance, with information such as dates, license keys, and issues or updates - Data warehouse - Archive - Cloud backup - Run-book

Run-book

Which of the following is generally not considered a source of big data - Social media posts - Sales transactions - Online reviews - Comments on blogs

Sales transactions

A _______ represents a field or combination of fields that may not be unique, but is commonly used for retrieval and thus should be indexed - Alternate key - Secondary key - Indexed key - Combo key

Secondary key

In the following Database Design Language (DBDL) notation, what does SK stand for mployees (EmpID, LastName, FirstName, SSN, DeptNum) AK SSNSK LastName, FirstName FK DeptNum à Departments - SQL key - Subkey - Secondary key - Start key

Secondary key

Which of the following is an authentication tool in which information used to identify a user is stored on a physical card - Biometrics - Smart card - Sign-in - Password

Smart card

Git and Github operate on what type of distributed database model - Snapshot - Master-slave - Object-oriented - Client/server

Snapshot

A ________ contains software components that are well documented and have a proven track records of working well together - Enterprise-level system - Solution stack - HTTP method - web app

Solution stack

Which of the following is not a technology that a data warehouse administrator typically manages - Extract, transform, load (ETL) - Online analytical processing (OLAP) - Business intelligence (BI) - Spyware/malware detection software (SMDS)

Spyware/ malware detection software (SWDS)

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 - Pie chart - Waterfall chart - Sunburst chart - Radar chart

Sunburst chart

What do you call applying and reconciling updates from various copies of a database with the master copy - Replication - Synchronization - Authentication - Atomicity

Synchronization

In an entity-relationship model (ERM), what does a diamond represent - The "many" part of the relationship - The "one" part of the relationship - The relationship - An entity

The relationship

What is the purpose of an index - To improve database performance when queries request a sort order for records - To store unique data for each record in the table - To identify primary, secondary, and alternate keys - To show which database objects depend on each other

To improve database performance when request a sort order for records

Which of the following does a DBMS log typically not include for each transaction - Transaction ID - User responsible for the transaction - After image - Before image

User responsible for the transaction

Which of the following is information that Access system catalogs do not maintain - Users, user groups, and privileges - Properties of the relationships between tables - Tables and fields included in the database - Indexed fields

Users, user groups, and privileges

In cloud computing, although many clients share the same resources, a company's systems operate as if they were running on their own distributed system because of __________ - Embedded analytics - Abstraction - Crowdsourcing - Virtualization

Virtualization

How does Access handle concurrent updates - Through time timestamping - Restricting the database to one user at a time - With record-level locking - with file-level locking

With record-level locking

Which of the following is a language for querying web-based documents and similarly strutted data repositories - XQuery - Extensible schema definition (XSD) - XSL Transformations (XSLT) - Extensible Stylesheet Language (XSL)

XQuery