WGU D426 V2 SOLVED 100%
CORRECT!!
The relationship (within the relation) that describes how the value of one attribute may be used to find the value of another attribute. - Answer Functional Dependency An attribute that can be used to find the value of another attribute in the relation. - Answer Determinant Value can be used to find the value of every other non-key attribute in the table.Unique and minimal. - Answer Candidate Key Define & manage database structures - Answer DDL Adding, deleting, and modifying data - Manipulates data stored in a database. - Answer DML Used to create user accounts, manage permissions and access. - Answer DCL Includes CREATE, DROP, ALTER, TRUNCATE, RENAME - Answer DDL A view created and stored on the database. Underlying data is changed and also updated in this view. Uses memory space. - Answer Materialized View Not stored in memory. Only computed when used or accessed. - Answer Virtual View The data about the data. Describes elements such as columns, names, and data type. - Answer Metadata Ordered collection of elements in parentheses. - Answer Tuple % of table rows selected by a query - Answer Hit Ration Reads blocks directly, without accessing an index. - Answer Table Scan Reads index blocks sequentially in order to locate the needed table blocks. - Answer Index Scan Database repeatedly splits the index in two until it finds a match. - Answer Binary Search Database object that maps one or more tables to a single file. - Answer Tablespace Specifies tables, columns, and keys. Implements database requirements in a specific database system. Also called a schema. - Answer Logical Design Specifies indexes, table structures, and partitions. Specifies how tables are organized on storage media. - Answer Physical Design 1 / 2
WGU D426 V2 SOLVED 100%
CORRECT!!
Components of a computer system and the relationships between components. - Answer Architecture Interact directly with database users and administrators and send queries to the query processor. Includes Connectors & APIs, Workbench, and utility programs. - Answer Tools Interprets queries. Compiles queries into low-level instructions for the storage engine. Creates a plan to modify the database or retrieve data, and returns query results to the application. - Answer Query Processor Link between tools and query processor - Answer Connection Creates connections and manages communication between tools and query parser.
- Answer Connection Manager
- / 2
Translates the query processor instructions into low-level file system commands that modify or retrieve data. - Answer Storage Engine Accesses data on storage media. Data stored on storage media and organized in files. Contains 3 types of data: - User data (tables & indexes) - Log files (record of any changes) - Data dictionary (aka: catalog directory of tables, columns, keys, indexes in a relational database). One row for each database object. - Answer File System Stores reusable information in main memory. - Answer Cache Manager Retains data blocks from the file system for possible reuse. - Answer Buffer Manager Arranged in hierarchy - Answer Multi-tier architecture Multi-tier consisting of web browsers and web servers communicating over the internet. - Answer Web architecture A software layer that emulates a complete, independent computing environment. - Answer Virtual Machine A database offered as a PaaS cloud service. - Answer Cloud Database A statement or proposition from which another statement is inferred. - Answer Premise Multiple processors managed by a single operating system instance.Shared memory - share the same memory and storage media.Shared storage - share storage media only.Shared nothing - Answer Parallel Computer Group of computers connected by LAN or WAN - Answer Node