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