WGU D426 OA EXAM 150 QUESTIONS AND C0RRECT ANSWERS ALREADY GRADED A+ .
5 views 0 purchase
Course
WGU D426
Institution
WGU D426
WGU D426 OA EXAM 150 QUESTIONS AND C0RRECT ANSWERS ALREADY GRADED A+ .
Adding, deleting, and modifying data - Manipulates data stored in a database. – ANSWER DML
Used to create user accounts, manage permissions and access. - ANSWERDCL
Includes CREATE, DROP, ALTER, TRUNCATE, RENAME - ...
WGU D426 OA EXAM 150 QUESTIONS AND
C0RRECT ANSWERS ALREADY GRADED A+ 2024-
2025.
Adding, deleting, and modifying data - Manipulates data stored in a database. –
ANSWER DML
Used to create user accounts, manage permissions and access. - ANSWERDCL
Includes CREATE, DROP, ALTER, TRUNCATE, RENAME - ANSWERDDL
% of table rows selected by a query - ANSWERHit Ration
Reads blocks directly, without accessing an index. - ANSWERTable Scan
Reads index blocks sequentially in order to locate the needed table blocks. -
ANSWERIndex Scan
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
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
Components of a computer system and the relationships between components. -
Link between tools and query processor – ANSWER Connection
Creates connections and manages communication between tools and query parser. –
ANSWER Connection Manager
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller maleek. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $20.49. You're not tied to anything after your purchase.
