Examen
2024 WGU D426 V2 EXAM QUESTIONS AND CORRECT DETAILED ANSWERS AGRADE
- Grado
- Institución
WGU D426 V2 EXAM QUESTIONS AND CORRECT DETAILED ANSWERS AGRADE
[Mostrar más]Vista previa 3 fuera de 25 páginas
Vista previa 3 fuera de 25 páginas
Añadir al carrito
Añadir al carrito
Vendedor
Seguir
STUVIAGRADES
Comentarios recibidos
Vista previa del contenido
WGU D426 V2 200+ EXAM QUESTIONS AND CORRECT DETAILEDANSWERS AGRADE
1. The relationship (within the relation) that describes how the value of one
attribute may be used to find the value of another attribute.: Functional Depen-
dency
2. An attribute that can be used to find the value of another attribute in the
relation.: Determinant
3. Value can be used to find the value of every other non-key attribute in the
table. Unique and minimal.: Candidate Key
4. Define & manage database structures: DDL
5. Adding, deleting, and modifying data - Manipulates data stored in a data-
base.: DML
6. Used to create user accounts, manage permissions and access.: DCL
7. Includes CREATE, DROP, ALTER, TRUNCATE, RENAME: DDL
8. A view created and stored on the database. Underlying data is changed and
also updated in this view. Uses memory space.: Materialized View
,9. Not stored in memory. Only computed when used or accessed.: Virtual View
10. The data about the data. Describes elements such as columns, names, and
data type.: Metadata
11. Ordered collection of elements in parentheses.: Tuple
12. % of table rows selected by a query: Hit Ration
13. Reads blocks directly, without accessing an index.: Table Scan
14. Reads index blocks sequentially in order to locate the needed table
blocks.: Index Scan
15. Database repeatedly splits the index in two until it finds a match.: Binary
Search
16. Database object that maps one or more tables to a single file.: Tablespace
17. Specifies tables, columns, and keys. Implements database requirements in
a specific database system. Also called a schema.: Logical Design
18. Specifies indexes, table structures, and partitions. Specifies how tables
are organized on storage media.: Physical Design
19. Components of a computer system and the relationships between compo-
nents.: Architecture
20. Interact directly with database users and administrators and send queries
to the query processor. Includes Connectors & APIs, Workbench, and utility
programs.: Tools
, 21. 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.: Query Processor
22. Link between tools and query processor: Connection
Los beneficios de comprar resúmenes en Stuvia estan en línea:
Garantiza la calidad de los comentarios
Compradores de Stuvia evaluaron más de 700.000 resúmenes. Así estas seguro que compras los mejores documentos!
Compra fácil y rápido
Puedes pagar rápidamente y en una vez con iDeal, tarjeta de crédito o con tu crédito de Stuvia. Sin tener que hacerte miembro.
Enfócate en lo más importante
Tus compañeros escriben los resúmenes. Por eso tienes la seguridad que tienes un resumen actual y confiable. Así llegas a la conclusión rapidamente!
Preguntas frecuentes
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.
100% de satisfacción garantizada: ¿Cómo funciona?
Nuestra garantía de satisfacción le asegura que siempre encontrará un documento de estudio a tu medida. Tu rellenas un formulario y nuestro equipo de atención al cliente se encarga del resto.
Who am I buying this summary from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller STUVIAGRADES. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy this summary for 17,12 €. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
45,681 summaries were sold in the last 30 days
Founded in 2010, the go-to place to buy summaries for 14 years now