WGU D426 (V2) REVISED
EXAM/198QUESTIONS WITH
100% Correct Solutions/ Graded
A+
The relationship that describes how one attribute's value can determine another's -
-Functional Dependency
-An attribute determining the value of another attribute - -Determinant
-Unique and minimal attribute determining non-key attributes - -Candidate Key
-Defines and manages database structures - -DDL
-Manipulates data: adding, deleting, modifying - -DML
-Manages user accounts and permissions - -DCL
-Commands: CREATE, DROP, ALTER, TRUNCATE, RENAME - -DDL
-Stored view that updates when underlying data changes - -Materialized View
-Computed view not stored in memory - -Virtual View
-Information describing data elements - -Metadata
-Ordered collection of elements in parentheses - -Tuple
-Percentage of table rows a query selects - -Hit Ratio
-Directly reads blocks without using an index - -Table Scan
-Reads index blocks to locate table blocks - -Index Scan
-Database splits the index until a match is found - -Binary Search
-Database object mapping tables to a file - -Tablespace
-Specifies tables and keys, also called a schema - -Logical Design
-Specifies how tables are stored on media - -Physical Design
-Components and relationships in a computer system - -Architecture
-Direct interface with database users, includes APIs - -Tools
-Interprets and compiles queries - -Query Processor
, -Link between tools and query processor - -Connection
-Manages communication between tools and query parser - -Connection Manager
-Translates query instructions to file system commands - -Storage Engine
-Accesses data on storage media, includes logs and user data - -File System
-Stores reusable information in memory - -Cache Manager
-Retains file system data blocks for reuse - -Buffer Manager
-Hierarchical arrangement - -Multi-tier architecture
-Multi-tier with web browsers and servers over the internet - -Web architecture
-Software emulating a complete computing environment - -Virtual Machine
-Database offered as a cloud service - -Cloud Database
-Statement from which another is inferred - -Premise
-A system with multiple processors that can run multiple tasks simultaneously.
They can be configured to have shared memory, shared storage, or neither - -
Parallel Computer
-Any device, such as a computer or printer, connected to a network - -Node
-Group of nodes on a LAN with separate OS instances - -Cluster
-Database on a parallel computer or cluster - -Parallel Database
-Database on multiple computers connected by a WAN - -Distributed Database
-Updates data on multiple nodes of a distributed database - -Distributed
Transactions
-Updates data on a single node of a distributed database - -Local Transaction
-States a database can't be Consistent, Available, and Partition-tolerant
simultaneously - -CAP Theorem
-Database with replicas on separate devices - -Replicated database
-Entire catalog on a single node - -Central Catalog
-Catalog copy on each node - -Replicated Catalog
-Real-time, detailed data for specific business functions - -Operational Data
EXAM/198QUESTIONS WITH
100% Correct Solutions/ Graded
A+
The relationship that describes how one attribute's value can determine another's -
-Functional Dependency
-An attribute determining the value of another attribute - -Determinant
-Unique and minimal attribute determining non-key attributes - -Candidate Key
-Defines and manages database structures - -DDL
-Manipulates data: adding, deleting, modifying - -DML
-Manages user accounts and permissions - -DCL
-Commands: CREATE, DROP, ALTER, TRUNCATE, RENAME - -DDL
-Stored view that updates when underlying data changes - -Materialized View
-Computed view not stored in memory - -Virtual View
-Information describing data elements - -Metadata
-Ordered collection of elements in parentheses - -Tuple
-Percentage of table rows a query selects - -Hit Ratio
-Directly reads blocks without using an index - -Table Scan
-Reads index blocks to locate table blocks - -Index Scan
-Database splits the index until a match is found - -Binary Search
-Database object mapping tables to a file - -Tablespace
-Specifies tables and keys, also called a schema - -Logical Design
-Specifies how tables are stored on media - -Physical Design
-Components and relationships in a computer system - -Architecture
-Direct interface with database users, includes APIs - -Tools
-Interprets and compiles queries - -Query Processor
, -Link between tools and query processor - -Connection
-Manages communication between tools and query parser - -Connection Manager
-Translates query instructions to file system commands - -Storage Engine
-Accesses data on storage media, includes logs and user data - -File System
-Stores reusable information in memory - -Cache Manager
-Retains file system data blocks for reuse - -Buffer Manager
-Hierarchical arrangement - -Multi-tier architecture
-Multi-tier with web browsers and servers over the internet - -Web architecture
-Software emulating a complete computing environment - -Virtual Machine
-Database offered as a cloud service - -Cloud Database
-Statement from which another is inferred - -Premise
-A system with multiple processors that can run multiple tasks simultaneously.
They can be configured to have shared memory, shared storage, or neither - -
Parallel Computer
-Any device, such as a computer or printer, connected to a network - -Node
-Group of nodes on a LAN with separate OS instances - -Cluster
-Database on a parallel computer or cluster - -Parallel Database
-Database on multiple computers connected by a WAN - -Distributed Database
-Updates data on multiple nodes of a distributed database - -Distributed
Transactions
-Updates data on a single node of a distributed database - -Local Transaction
-States a database can't be Consistent, Available, and Partition-tolerant
simultaneously - -CAP Theorem
-Database with replicas on separate devices - -Replicated database
-Entire catalog on a single node - -Central Catalog
-Catalog copy on each node - -Replicated Catalog
-Real-time, detailed data for specific business functions - -Operational Data
