WGU D426 EXAM (Latest updated Exam) WITH 100% ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
ACCURATE SOLUTIONS ||//|\\||
Data - Definition - Precise Answer ✔✔Numeric, textual, visual, or audio information that
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
describes real-world systems ||//|\\|| ||//|\\||
Scope - Data - Precise Answer ✔✔Amount of data produced & collected can vary
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Format - Data - Precise Answer ✔✔Data may be produced as numbers, text, image, audio, or
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
video
Access - Data - Precise Answer ✔✔Some data sources are private while others are made publicly
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
available
Analog - Data - Precise Answer ✔✔Encoded as continuous variations on various physical media
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Digital - Data - Precise Answer ✔✔Encoded as 0s & 1s on electronic & magnetic media
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Operational Data - Data - Precise Answer ✔✔Conduct daily business function ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Analytic Data - Data - Precise Answer ✔✔To understand, manage, and plan business
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Database - Definition - Precise Answer ✔✔Collection of data in a structures format
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Database System (DBMS) - Databases - Precise Answer ✔✔Software that reads & writes data in
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
a database
||//|\\||
In-Memory Database - Database - Precise Answer ✔✔Database that stores data in main memory, ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
instead of or in addition to storage media
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
,Embedded Database - Database - Precise Answer ✔✔Database that is packaged with a ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
programming language ||//|\\||
Federated Database - Database - Precise Answer ✔✔Collection of 2+ participating databases
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
underneath a coordinating software layer ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Autonomous Database - Federated Database - Database - Precise Answer ✔✔Operates ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
independently of other participating databases ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Heterogeneous Databases - Federated Database - Database - Precise Answer ✔✔Either run under ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
different database systems of have incompatible schema ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Middleware - Federated Database - Database - Precise Answer ✔✔Software lies between ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
application programs & database software ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Global Catalog - Federated Database - Database - Precise Answer ✔✔Directory of participating
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
database objects (tables, columns, indexesw) ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Global Query Processor - Federated Database - Database - Precise Answer ✔✔Decomposes a
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
federated query into queries for each participating database ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Database Wrapper - Federated Database - Database - Precise Answer ✔✔Converts decomposed
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
queries to the appropriate syntax for each participating database
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Nickname - Federated Database - Database - Precise Answer ✔✔Federated database name for a ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
participating database object (tables & columns) ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
User Mapping - Federated Database - Database - Precise Answer ✔✔Associates a federated
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
database user with a participating database user ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Query - Databases - Precise Answer ✔✔Request to retrieve or change data in a database
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
, CAP - Database - Precise Answer ✔✔Cannot simultaneously be: Consistent (conforms to all rules
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
at all times, Available (nodes must respond to queries at all times), Partition-Tolerant (database
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
functions when network partition occurs) ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Replica - Database - Precise Answer ✔✔Copy of entire database; high availability, fast ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
concurrent reads, local reads, slow updates ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Storage Arrays - Replica - Database - Precise Answer ✔✔Manage replicas internally without
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
database intervention ||//|\\||
Database Application - Databases - Precise Answer ✔✔Software that helps business users ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
interact with database systems ||//|\\|| ||//|\\|| ||//|\\||
Performance - File & Database Systems Shared by Many Users - Precise Answer ✔✔When many ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
users & applications simultaneously access large databases, query response time degrades rapidly
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Authorization - File & Database Systems Shared by Many Users - Precise Answer ✔✔Many ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
database users should have limited access to specific tables, columns, or rows of database ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Security - File & Database Systems Shared by Many Users - Precise Answer ✔✔Database ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
systems ensure authorized users only access permissible data ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Rules - File & Database Systems Shared by Many Users - Precise Answer ✔✔Database systems
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
ensure data is consistent with structural & business rules ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Recovery - File & Database Systems Shared by Many Users - Precise Answer ✔✔Database ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
systems must recover from failures & restore database to a consistent state without loss of data
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Transaction - Definition - Precise Answer ✔✔Group of queries that must be either completed or ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
rejected as a whole ||//|\\|| ||//|\\|| ||//|\\||
ACCURATE SOLUTIONS ||//|\\||
Data - Definition - Precise Answer ✔✔Numeric, textual, visual, or audio information that
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
describes real-world systems ||//|\\|| ||//|\\||
Scope - Data - Precise Answer ✔✔Amount of data produced & collected can vary
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Format - Data - Precise Answer ✔✔Data may be produced as numbers, text, image, audio, or
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
video
Access - Data - Precise Answer ✔✔Some data sources are private while others are made publicly
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
available
Analog - Data - Precise Answer ✔✔Encoded as continuous variations on various physical media
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Digital - Data - Precise Answer ✔✔Encoded as 0s & 1s on electronic & magnetic media
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Operational Data - Data - Precise Answer ✔✔Conduct daily business function ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Analytic Data - Data - Precise Answer ✔✔To understand, manage, and plan business
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Database - Definition - Precise Answer ✔✔Collection of data in a structures format
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Database System (DBMS) - Databases - Precise Answer ✔✔Software that reads & writes data in
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
a database
||//|\\||
In-Memory Database - Database - Precise Answer ✔✔Database that stores data in main memory, ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
instead of or in addition to storage media
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
,Embedded Database - Database - Precise Answer ✔✔Database that is packaged with a ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
programming language ||//|\\||
Federated Database - Database - Precise Answer ✔✔Collection of 2+ participating databases
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
underneath a coordinating software layer ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Autonomous Database - Federated Database - Database - Precise Answer ✔✔Operates ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
independently of other participating databases ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Heterogeneous Databases - Federated Database - Database - Precise Answer ✔✔Either run under ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
different database systems of have incompatible schema ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Middleware - Federated Database - Database - Precise Answer ✔✔Software lies between ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
application programs & database software ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Global Catalog - Federated Database - Database - Precise Answer ✔✔Directory of participating
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
database objects (tables, columns, indexesw) ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Global Query Processor - Federated Database - Database - Precise Answer ✔✔Decomposes a
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
federated query into queries for each participating database ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Database Wrapper - Federated Database - Database - Precise Answer ✔✔Converts decomposed
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
queries to the appropriate syntax for each participating database
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Nickname - Federated Database - Database - Precise Answer ✔✔Federated database name for a ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
participating database object (tables & columns) ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
User Mapping - Federated Database - Database - Precise Answer ✔✔Associates a federated
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
database user with a participating database user ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Query - Databases - Precise Answer ✔✔Request to retrieve or change data in a database
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
, CAP - Database - Precise Answer ✔✔Cannot simultaneously be: Consistent (conforms to all rules
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
at all times, Available (nodes must respond to queries at all times), Partition-Tolerant (database
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
functions when network partition occurs) ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Replica - Database - Precise Answer ✔✔Copy of entire database; high availability, fast ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
concurrent reads, local reads, slow updates ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Storage Arrays - Replica - Database - Precise Answer ✔✔Manage replicas internally without
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
database intervention ||//|\\||
Database Application - Databases - Precise Answer ✔✔Software that helps business users ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
interact with database systems ||//|\\|| ||//|\\|| ||//|\\||
Performance - File & Database Systems Shared by Many Users - Precise Answer ✔✔When many ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
users & applications simultaneously access large databases, query response time degrades rapidly
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Authorization - File & Database Systems Shared by Many Users - Precise Answer ✔✔Many ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
database users should have limited access to specific tables, columns, or rows of database ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Security - File & Database Systems Shared by Many Users - Precise Answer ✔✔Database ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
systems ensure authorized users only access permissible data ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Rules - File & Database Systems Shared by Many Users - Precise Answer ✔✔Database systems
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
ensure data is consistent with structural & business rules ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Recovery - File & Database Systems Shared by Many Users - Precise Answer ✔✔Database ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
systems must recover from failures & restore database to a consistent state without loss of data
||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
Transaction - Definition - Precise Answer ✔✔Group of queries that must be either completed or ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\|| ||//|\\||
rejected as a whole ||//|\\|| ||//|\\|| ||//|\\||
