study guide

What does the following statement return? SELECT SUBSTRING('Excellent',3,4)

'cell'

Which of the following values violate the CHECK constraint below? CREATE TABLE Customer ( CustomerId INT AUTO_INCREMENT, Name VARCHAR(60), Age INT CHECK (Age BETWEEN 18 AND 50), ShippingAddress VARCHAR(200), PRIMARY KEY (CustomerId) );

(456, "Sarah Mcgraw", 61, "12301 270th PI, Seattle, WA 98126")

In the Reservation table below, a room may be reserved several times, so the RoomNumber column is not unique. To ensure that a room can only be reserved by only one guest for the day, the minimal primary key consists of which columns?

(RoomNumber, DateOfStay)

A table has columns A,B,C,D; Candidate keys (A,B) and C primary key (A,B) if D-> A is the only dependency, aside from dependencies on candidate keys the table is in _____ normal form.

***** don't know *****

Choose the recovery log that is generated by the schedule below

1. start T1 2. start T2 3. update T1, AID, Aoriginal, Anew 4. commit T1 5. update T2, BID, Boriginal, Bnew 6. undo T2, BID, Boriginal 7. rollback T2

A time dimension table tracks throughout a day by minute. How many rows does the table contain?

1440

Refer to the schedule below. The initial value of B is 7 and C is 3. What is the value of A after conflicting schedule executes?

2

how many bytes does POINT(18.5 -20) require in internal MySQL format?

24

How many columns are created by the SQL statement below? CREATE TABLE Supplier ( SupplierId INT, CompanyName VARCHAR(40), ContactName VARCHAR(50), City VARCHAR(40), Country VARCHAR(40), Phone VARCHAR(30) );

6

how many types are possible for elements of a JSON document

6

which violates the check constraint CHECK (Age BETWEEN 18 and 50)?age: NULL, 20, 61, 50

61

A data dimension table tracks data for two years. How many rows does the table contain

730

Refer to the schedule below. The initial value of B is 7 and C is 3. What is the value of A after the schedule executes

8

What option is found on the Schemas tab in MySQL Workbench?

A list of available databases

How are blocks read with a single-level index scan?

A scan reads all index blocks to find table blocks that contain selected rows. The table blocks are then read.

Which statement creates a primary key constraint on the ID column of the Employee table?

ALTER TABLE Employee ADD PRIMARY KEY (ID);

A developer wishes to link to a database with a utility created in C. Which MySQL component does the developer use for the link?

API

What links a host programming language to a database system

API

which of the following database programming techniques is commonly used with OOP languages?

API

REFER to the table and schedule below. The UPDATE statement in transaction T1 holds an exclusive lock on the Class table. With strict two-phase locking, when does the SELECT statement in transaction T2 execute?

After the ROLLBACK statement in T1 execute

A database team plans the creation of a new database. During which phase does the team capture data requirements?

Analysis

In the following ER diagram, what does 'AlbumTitle' represent

Attribute

A table is in _____ normal form when all dependencies are on unique columns.

Boyce-Codd ***not sure***

In MySQL, which of the following SQL operations always commits immediately

CREATE

The following tables describe parts and companies that supply parts: CREATE TABLE Part ( PartID SMALLINT, PartName VARCHAR(30, PartSupplierCode CHAR(3), PRIMARY KEY (PartID), FOREIGN KEY (PartSupplierCode) REFERENCES Supplier (SupplierCode) ); CREATE TABLE Supplier ( SupplierCode CHAR(3), SupplierName VARCHAR(30), PostalCode CHAR(5), PRIMARY KEY (SupplierCode) ); The following query selects all possible combinations of part names and supplier names. What XXX completes the query? SELECT PartName, SupplierName FROM Part XXX;

CROSS JOIN Supplier

when using a SQL statement to create a table, which data type is used to store a fractional value?

DECIMAL

In a PHP application using PDO, a _____ consists of the host, port, and name of the database that will be used to establish a connection to the database.

Data Source Name

The statement below is an example from which SQL sublanguage? SELECT ProductName FROM Product;

Data Transaction Language

Raw data that is copied from multiple data sources is called what?

Data lake

What does a a user that interacts with a database use to read and write data

Database management system

Which table type do plural attributes become?

Dependent

In a data warehouse that uses a dimensional design, a StudentID column is found in which table?

Dimension

The _____ keyword helps the compiler identify embedded SQL statements in a program.

EXEC SQL

What is the difference between ENUM type and the SET type?

Each ENUM value has exactly one element, each SET value can have many elements

A database administrator creates a MySQL statement with incorrect syntax. What does MySQL Workbench display when the statement is executed?

Error Code

Which of the following required keywords specifies if the trigger will affect all rows of the table?

FOR EACH ROW

ShipPartCode is a foreign key in the Shipment table. ShipPartCode refers to the primary key PartCode of the Part table. What replaces XXX in the following statement? CREATE TABLE Shipment ( ShipNumber INT UNSIGNED, ShipPartCode CHAR(3) NOT NULL, Quantity SMALLINT UNSIGNED, PRIMARY KEY (ShipNumber), XXX );

FOREIGN KEY (ShipPartCode) REFERENCES Part (PartCode)

Which goes in the table on the "many" side of a one-many relationship?

Foreign key

Where is the list of attribute types

Glossary

_____ is a recovery technique that creates a nearly synchronized backup of the primary database on another database server.

Hot backup

which statements should replace XXX and YYY to execute the SELECT statement when the teacherID value is valid?

IF teachID IS NOT NULL THEN, END IF

An organization deploys computer processing power and storage through a cloud provider's ______ services

Iaas

When performing a search, which scan type is fastest?

Index

What is a characteristic of a logical index?

Index does not change when a row moves to a new block.

What type of join is executed by the following relational algebra expression? Department⋈Department.Manager=Employee.IDEmployee

Inner

The teacher table is the ______. SELECT LastName, FirstName, CourseTitle FROM Teacher INNER JOIN Class ON Teacher.TeacherID = Class.TeacherID;

Left Table

A _____ is a part of the concurrency system that monitors, grants, and releases locks.

Lock Manager

Which concept relates to software that reads and writes data in a database

Management system

_____ is not a relational algebra operation

Merge

In MySQL, if Salary is NULL then Salary > 5000 is _____ and Salary IS NOT NULL is _____

NULL, FALSE

which type of database system is optimized for big data?

NoSQL

What foreign key action should be added to ensure that if a supplier is removed from the Supplier table, the products associated with the same supplier are also removed? CREATE TABLE Product ( ProductId INT NOT NULL AUTO_INCREMENT, ProductName Varchar(50), UnitPrice DECIMAL(5,2), SupplierId INT< PRIMARY KEY (ProductId), FOREIGN KEY (SupplierId) References Supplier(SupplierId) _____ );

ON DELETE CASCADE

What foreign key action should be added to ensure that if a supplier is removed from the Supplier table, the products associated with the same supplier are also removed? CREATE TABLE Product ( ProductId INT NOT NULL AUTO_INCREMENT, ProductName VARCHAR(50), UnitPrice DECIMAL(5,2), SupplierId INT, PRIMARY KEY (ProductId), FOREIGN KEY (SupplierId) REFERENCES Supplier(SupplierId) _____);

On DELETE CASCADE

select the correct WKT syntax for a polygon

POLYGON( (0 0, 20 10, 10 20, 0 0) )

An organization uses a database and application development tools through a cloud provider's ______ services

Paas

Which principle defines data independence

Physical design never affects query results

in MySQL with InnoDB, how are primary and secondary indexes created?

Primary indexes are automatically created for each primary key. Secondary indexes are created automatically for all foreign keys.

In the SQL code below, which of the following is an identifier?UPDATE Product SET UnitPrice = 9.50 WHERE ProductId = 20;

Product

what should be added so NULL values are not allowed in ProductName?

ProductName VARCHAR(50) NOT NULL

Complete the ORDER BY clause to sort the Products by ProductName alphabetically, then in decreasing Quantity. SELECT ProductName, Size, Quantity, SupplierId FROM Product ORDER BY _____;

ProductName, Quantity DESC

Which term describes the meaning of an attribute value?

Qualifier

Which of the following is NOT a replica type?

Query

which statement should replace XXX? CREATE FUNCTION GetTeacherID(teacherLastName VARCHAR(20)) RETURNS INT XXX BEGIN DECLARE... ... ... END;

READS SQL DATA

in which isolation level can dirty reads occur

Read uncommitted

Which relational algebra operation is denoted by the Greek letter p?

Rename

Refer to the sequence below. What is the isolation level of of transaction E?

Repeatable read

Refer to the tables. Which products are returned by the query below? SELECT ProductName FROM Product P WHERE NOT EXISTS (SELECT * FROM Sales WHERE ProductID = P.ProductID);

Romper, Pajama set

What approach can a database administrator use to assess the effectiveness of indexes when investigating slow queries?

Run EXPLAIN on queries

Refer to the initial Class table, SQL transaction, and final Class table, below. Which SAVEPOINT identifier is used to produce the final Class table?

S2

_____ allows all executed database instructions to be rolled back and to be restored in a prior transaction state.

SAVEPOINT

The _____ SQL statement does not alter any database data

SELECT

Refer to the Customer table. Which query returns the result table below?

SELECT State, COUNT(*) FROM Customer GROUP BY State HAVING COUNT(*) > 1; FROM DIFFERENT QUESTION: SELECT RewardsMember, COUNT(*) FROM Customer GROUP BY RewardsMember;

a database administrator uses which two SQL statements to view and then modify existing customer balances with a late fee?

SELECT, UPDATE

A database administrator wants to correlate pairs of rows from the same table. Which type of join should the database administrator use?

Self-join

Which isolation level prevents dirty, non-repeatable, and phantom reads?

Serializable

_____ entities have many common attributes and relationships.

Similar

The analysis phase of database design includes which process?

Specifying requirements that are NOT dependent on a specific database system.

What does SQL stand for?

Structured Query Language

What design consideration would apply to a database that has special performance requirements?

Structuring data properly on storage media

The table below tracks grades received by students in courses, Scores of a 90 and above receive an A grade, 80 to 89, to a B, and so on. What column(s), if any, must be removed to achieve third normal form?

StudentName and LetterGrade only

The entity Book includes Paperback, Hardcover, and Digital books. The attribute ChapterCount applies to both PaperBack and HardCover but not Digital. Digital has a TextToSpeech attribute. Which entity type is Digital?

Subtype

A database designer wants to create three tables: Supplier, Product, and Country. The Supplier table has a CountryID column with values that must appear in the Country table's CountryID column. The Product table has a ProductID column. Which table's CREATE TABLE statement(s) must specify a FOREIGN KEY?

Supplier

Which column is best to replace XXX in the SQL statement below? CREATE TABLE Supplier ( SupplierID INT AUTO_INCREMENT, CompanyName VARCHAR(40), ContactName VARCHAR(50), Phone VARCHAR(30), PRIMARY KEY (XXX) );

SupplierID

In MySQL, what is the result of TRUE or NULL?

TRUE

What object maps one or more tables to a single file?

Tablespace

What is wrong in the following query? SELECT Sales.OrderID, Customer.FirstName, Customer.LastName FROM Sales INNER JOIN Customer ON CustomerID = CustomerID;

The CustomerID prefix is missing

What is wrong with the syntax of this XML?

The XML syntax is correct

What causes the generation of a NULL primary key value when using a view in an INSERT statement

The base table primary key is not included in the view table.

Which statement is NOT an advantage of using a view table?

The creation of a new base table is always up to date

What are two characteristics of an efficient bitmap index?

The database can quickly determine the block containing a table row from the index row number. Any indexed column contains relatively few distinct values.

In a MongoDB shell, what happens when the following command executes? db.movies.insert({ name: "What About Bob?", year: 1991 })

The document is added to the collection with a generated _id

Why would mysql.connector.connect() throw an exception in a Connector/Python program?

The function was called with a username that does not have access to the database.

An inventory view table is defined with a WHERE clause that specifies ShelfNumber = 25. An INSERT adds a new item to ShelfNumber 20. What happens when the WITH CHECK OPTION is not specified in the CREATE VIEW statement?

The item appears in the base table but not in the view table

If a database system is processing three queries as part of a transaction and the third query fails, what happens to the transaction?

The successful query results are reversed, and the transaction is canceled.

Which deadlock management technique automatically rolls back a transaction when a lock is not released in a fixed amount of time

Timeout

Which MySQL layer interacts directly with database user and administrators

Tools

A database contains several relationships. Which is a valid relationship name?

Toys-Contains-Dolls

A recovery system should manage which three failure scenarios?

Transaction failure, System failure, and Storage media failure

The _____ modeling convention is commonly used for software development as well as ER modeling.

Unified Modeling Language (UML)

A big data application generates 20,000 data entries per second. This rate is called what?

Velocity

The EmployeeWorkplace table has a composite key of (EmployeeID, WorkspaceID). Workhours depends on (EmployeeID, WorskspaceID), and EmployeeLastName depends on EmployeeID. Which column must be removed so EmployeeWorkspace is in second normal form?

WorkspaceID

Which document type is commonly used by document databases?

XML

how does a list partition assign rows to partition?

a return value from a partition expression that uses VALUES IN

a primary replica has failed in a document database. what happens as a result?

a secondary replica becomes active

Which of the following is NOT true about the INSERT statement?

a single INSERT statement can only add one row

With column-oriented storage, a block stores values for _____.

a single column

the time required to read or write the first byte of data is known as ______

access time

MySQL stores JSON values as _____

an internal binary format

What is the fan-out for a multi-level index where index entries are 32 bytes and index blocks are 10 kilobytes?

approximately 300

the database designer creates an _____ when no suitable single-column or composite primary key exists

artificial key

In an online bank application that transfers funds from a checking account to a savings account, if a debit is made successfully from the checking account, the _____ property ensures that the corresponding credit is made to the savings account

atomicity

In a federated database, a(n) _______ database operates independently of other databases

autonomous

Branches that are similar in length in an index hierarchy are _____.

balanced

A user-defined type is defined in terms of a _____ type.

base

A relational database uses row-oriented storage to store an entire row within one ______

block

A transaction _____ indicates the starting and ending statement of a database transaction.

boundary

Hash index entries are assigned to _____.

buckets

in a multi-table, a _____ column is available in all interleaved tables

cluster key

A _______ index is an index on a non-unique sort column

clustering

The PosgreSQL ARRAY type is an example of a _____ type.

collection

a document database stores data as _____ , while a relational database stores data as _____.

collections, tables

which of the following is characteristic of a B-tree index, but not a B+tree index?

column values do not repeat at lower levels

a database administrator normalizes a table to boyce-codd normal form. this involves identifying dependencies on non-unique _____.

columns

a hierarchy in a dimension table contains a series of _____ where each has a _____ relationship to the next

columns, one-many

In Connector/J, executeQuery(statement) executes the SQL code associated with the statement object. Prior to execution, executeQuery() _____.

compiles the SQL unless the same SQL was compiles in the previous executeQuery() call

The primary key of a table created from a many-many relationship is the _____ of the foreign keys that refer to related tables.

composite

In a data lake, data is often loaded _____ rather than _____.

continuously, periodically

A/An _____ is a subquery that contains a reference to a table that also appears in the outer query.

correlated subquery

which of the following is an example of database programming?

creating a web application using Java and SQL

A _____ at the end of a relationship depicts cardinality "many".

crow's foot symbol

which of the following connector/python cursor properties returns the number of items affected by a query?

cursor.rowcount

A buffer manager retains _____ from the _____ to reduce data access time.

data blocks, file system

a database admin uses a SHOW statement to retrieve information about objects in a database. This information is contained in a _______

data dictionary

For reporting purposes, an organization establishes a(n) _____, which is separate from the operational database.

data warehouse

what command results in an empty students collection?

db.students.remove({})

In a _____, all transactions come to a halt and remain at a standstill until one of the transactions is aborted.

deadlock

Geographic data is _____.

defined with reference to the surface of the earth

which database role focuses on database storage, response times, and optimization?

designer

During database design, an ER _____ and _____ are usually developed in parallel.

diagram, glossary

An organization has a main office and three satellite locations. Data specific to each location is stored locally in which configuration?

distributed

what is an optional attribute?

each entity instance can have zero attribute values **not sure**

A retailer is using a cloud-based transaction database and is experiencing sales fluctuations through the year. The ability for cloud resources to adapt to such change in utilization is called _____.

elasticity

The query below is an _____? SELECT LastName, FirstName, CourseTitle FROM Teacher INNER JOIN Class ON Teacher.TeacherID = Class.TeacherID

equijoin

in the query processor layer, the query optimizer generates a/an _____

execution plan

A primary key of a ________ is the composite of the foreign keys that reference a _______

fact table, dimension table

given the autos collection, complete the statement to return all documents db.autos._____({year:{_____} })

find, $gte: 2012

When implementing relationships, each many-one relationship becomes a _____ key.

foreign

In a one-one relationship, the ____ key is often placed in the table with fewer rows. This minimizes the number of _____ values.

foreign, NULL

In a weak table, a _____ key references the identifying table _____ key

foreign, primary

When data is produced and stored as numeric, textual, or visual information, it varies in _____.

format

A column contains grades from 0 to 10, but a WHERE clause specifies values from 0 to 100. A _____ index can be used to modify the column values and process the queries.

function

A database admin configures replication for a distributed database. Which technique applies updates to any available node?

group replication

a complex type ______.

has a richer internal structure than a simple type

A _____ partition requires partition expression with positive integer values.

hash

which table structure might use the modulo function to locate rows?

hash

A _____ assigns each row to a group of linked blocks, called a bucket.

hash table

A subset of table rows is called a _____.

horizontal partition

When creating an ER diagram, an identifying relationship always connects a(n) _____ entity and a(n) _____ entity.

identifying, weak

Operational data changes _____, while analytic data is updated ______.

in real time, at fixed intervals

when a table is assigned to a tablespace, where is the index stored?

in the same tablespace as the table

In some ER modeling conventions, strong entities are called ______ and weak entities are called _____.

independent, dependent

_____ means each vertex in a graph database contains a pointer to all connected vertices

index-free adjacency

The heap table structure is optimized for _____.

inserting new rows

During a data _____ phase, a database administrator refreshes a data warehouse and replaces incompatible keys with consistent values.

integration

In an online bank application that transfers funds from a checking account to a savings account, the _____ property ensures that another transaction sees the transferred funds in one account or the other, but not in both, nor in neither

isolation

Denormalization eliminates _____ queries, and therefore, query performance is improved.

join

UPDATE, SELECT, and ORDER BY are _____ in an SQL statement

keywords

Which graph database physical structure might combine a graph and a relational database?

layered

When using the MySQL Workbench GUI, which icon will execute an SQL statement?

lightning bolt

a database administrator is updating one of the tables in the database. which of the following techniques can prevent other database administrators from doing concurrent transactions to the same table?

locking

when implementing a ____ relationship, a new table contains two foreign keys, referring to the primary keys of the related tables

many-many

When a database stores view data, it uses a _____ that depends on data in a corresponding _____.

materialized view, view table

Denormalization is a process of intentionally introducing redundancy and is achievable by _____ tables.

merging

An R-tree has a ____ index with index entries containing ____.

multi-level, MBRs

elements of the _____ type can be repeated and are not ordered

multiset

in MySQL, spatial values ____ numeric values

must be converted to numeric values using spatial functions prior to comparing with

what occurs when a distributed database experiences a network error and nodes cannot communicate?

network partition

For integrity purposes, a distributed transaction requires all or _____ nodes to be updated in order to complete the transaction.

no

In a first normal table, the ______ depends on the ______.

non-key columns, primary key

Redundancy may occur when a column depends on a _____ column.

non-unique

a database administrator uses ______ to eliminate redundancy. This is done by decomposing a table into two or more tables in higher normal form.

normalization

In a table, columns are _____ and rows are _____.

not ordered, ordered

A database designer interviews a sales team that will be using a new database, During the interview, the designer documents entities as ______ and relationships as _____

nouns, verbs

In the relational algebra, compatible tables have the same _____.

number of columns and data types

the sort column in a sorted table determines the _____ row order

physical

which principle defines data independence?

physical design never affects query results

In database APIs, ____ a query is a term used when compiling happens before executing the query.

preparing

how does a database system protect data when concurrent transactions occur?

preventing multiple transactions with the same data at the same time

A column, or group of columns, that serves as the unique identifier in a relational database table is called a/an _____.

primary key

In a logical index, pointers to table blocks are replaced with _____ values.

primary key

Using a cloud-based database comes with risk. _____ is a regulatory risk.

privacy

which of the following database programming techniques is an extension of the SQL language that is typically used for database applications?

procedural SQL

API defines ____ for applications written in a procedural programming language and _____ for applications in object-oriented languages.

procedure calls, classes

when a user interacts with a database, they can use a _____ to modify data with commands

query language

A document that sequentially writes all the database operations is known as a/an ______

recovery log

an operational database contains tables in third normal form. this design reduces _____

redundancy

Each course must be offered by at least one department. In the Department-Offers-Course relationship, Department is a(n) _____ entity

required

a database designer installs MySQL community edition to create a database. which account does the designer use to gain full control of MySQL?

root

In the relational model, an unnamed tuple of values is a ______.

row

Which statements should replace XXX and YYY in the Connector/Python program?

row[1], row[0]

Vertices in a graph database are similar to _____ in a relational table.

rows

A single-level index is a file that contains column values and pointers to _____ containing the column _____.

rows, value

A _______ is a sequential order of database instructions for multiple transactions

schedule

A database _____ is the implementation of database requirements in SQL with CREATE TABLE statements

schema

Redundancy is possible in a _____ normal form table when one non-key column depends on another non-key column.

second

A magnetic disk groups data into _____.

sectors

in _____ data, each element is named, and element types are not explicitly declared

semistructured

in order to locate rows selected by a query, an index scan reads index blocks _____.

sequentially

A _____ is a collection of values with no inherent order

set

One goal of object-relational database technology is to _____.

simplify database programming

When concurrently processing instructions, a shared memory computer works well with a common data set in a _________ memory space

single

the bottom level of a multi-level index is a ______ index

sorted single-level

in MySQL with InnoDB, tables with a primary key have a _____ structure, while those without a primary key have a _____ structure

sorted, heap

In terms of database architecture, which component translates the query processor instructions into low-level file-system commands and is responsible for indexing the data?

storage manager

The primary key of a _____ table is identical to the primary key of a supertype table.

subtype

Attributes and relationships that are shared by several entities may be moved to a new _____ entity

supertype

given the Oracle Database statement below, what is PlaceType? CREATE TYPE HomeType UNDER PlaceType ( );

supertype

Attributes of a _____ entity apply to all _____ entities

supertype, subtype

When an entity-relationship model is implemented in SQL, an entity typically becomes a _______

table

When an entity-relationship model diagram is implemented within SQL, entities typically become ______. and relationships typically become ______.

tables, foreign keys

When an entity-relationship model is implemented in SQL, entities typically become ______, and relationships become ______.

tables, foreign keys

When a table is updated and the index block has no free space for a new index entry, what happens?

the block splits

in a MongoDB shell, what happens when the following command executes? db.movies.insert({ name: "what about bob?", year:1991})

the document is added to the collection with a generated _id

a user creates a table by using a SQL statement. the data type VARCHAR(11) is part of the statement. what does the value of (11) represent?

the number of characters allowed for the data type

In two dimensions, a minimum bounding rectangle is the _____?

the smallest rectangle aligned with the X- and Y-axes that contains a spatial value

A table is in _____ normal form if, whenever a nonkey column A depends on column B, then B is unique.

third

A database _____ is a unit of work that is treated as a whole. it is either completed as a unit or failed as a unit.

transaction

A database _______ is a unit of work that is treated as a whole. It is either completed as a unit or failed as a unit.

transaction

the username and password for the database in the configuration file of a web application is incorrect, so the web application cannot connect to the database. which failure scenario best describes this example?

transaction failure

In order to run a program with Embedded SQL, the compiler _____.

translates the SQL code to the host language first, and then to an executable program

SQLAlchemy is a library that facilitates the communication between Python programs and databases. Most of the times, this library is used as an Object Relational Mapper (ORM) tool that translates Python classes to tables on relational databases and automatically converts function calls to SQL statements.

true

true or false: SQLAlchemy is a library that facilitates the communication between Python programs and databases

true

A replicated database maintains at least _____ or more replicas on _____ storage devices.

two, separate

each value of a ____ attribute describes at most one entity instance

unique

In the recovery log below, line 6 is a/an _____. 1. start T1 2. start T2 3. update T1, AID, Aoriginal, Anew 4. commit T1 5. update T2, BID, Boriginal, Bnew 6. undo T2, BID, Boriginal 7. rollback T2

update record

To fulfill data processing requirements in a growing transactional database, _____ scales up by increasing processing power of a limited number of systems.

vertical scaling

what is a concern with using an in-memory database?

volatility

A model has Shipment, Product, and Shipper entities. The Shipment entity has no unique attributes. Each shipment is identified by ProductNumber, ShipperCode, and ShipmentDate. Shipment is a(n) _____ entity.

weak

_____ architecture is an example of a modern multi-tier architecture

web

A NoSQL database that represents data as a key with multiple values is called a _____ database.

wide column

a _____ database stores related data as column families

wide column

In a primary/secondary replica update for a distributed database, secondary nodes are updated _____.

with independent local transactions