100% tevredenheidsgarantie Direct beschikbaar na betaling Zowel online als in PDF Je zit nergens aan vast
logo-home
WGU D426 EXAM NEWEST WITH WELL NARRATED ANSWERS,UPGRADED €20,91   In winkelwagen

Tentamen (uitwerkingen)

WGU D426 EXAM NEWEST WITH WELL NARRATED ANSWERS,UPGRADED

 7 keer bekeken  0 keer verkocht
  • Vak
  • Instelling

1. database application: software that helps business users interact with database systems. 2. database administrator: responsible for securing the database system against unauthorized users. and enforces procedures for user access and database system availability. 3. authorization: Many data...

[Meer zien]

Voorbeeld 2 van de 11  pagina's

  • 18 augustus 2024
  • 11
  • 2024/2025
  • Tentamen (uitwerkingen)
  • Vragen en antwoorden
avatar-seller
WGU D426 EXAM NEWEST WITH WELL NARRATED
ANSWERS,UPGRADED 2024-2025
1. database application: software that helps business users interact with database
systems.
2. database administrator: responsible for securing the database system against
unauthorized users. and enforces procedures for user access and database system
availability.
3. authorization: Many database users should have limited access to specific ta-
bles, columns, or rows of a database. Database systems authorize individual users
to access specific data.
4. rules: Database systems ensure data is consistent with structural and business
rules
5. query processor: interprets queries, creates a plan to modify the database or
retrieve data, and returns query results to the application.
6. query optimization: ensure the most efficient instructions are executed on the
data.
7. storage manager: translates the query processor instructions into low-level
file-system commands that modify or retrieve data. Database sizes range from
megabytes to many terabytes, so the storage manager uses indexes to quickly
locate data.
8. transaction manager: ensures transactions are properly executed. The transac-
tion manager prevents conflicts between concurrent transactions. The transaction
manager also restores the database to a consistent state in the event of a transaction
or system failure.
9. INSERT: inserts rows into a table
10. SELECT: retrieves data from a table
11. UPDATE: modifies data in a table
12. DELETE: deletes rows in a table
13. CREATE TABLE: creates a new table by specifying the table and column names.
Each column is assigned a data type that indicates the format of column values.
Data types can be numeric, textual, or complex.
14. INT: stores integer values
15. DECIMAL: Stores fractional numeric values
16. VARCHAR: stores textual values
17. DATE: stores year, month, day
18. analysis phase: specifies database requirements without regard to a specific
database system. Requirements are represented as entities, relationships, and at-
tributes. An entity is a person, place, activity, or thing. A relationship is a link between
entities, and an attribute is a descriptive property of an entity. AKA conceptual
design, entity-relationship modeling, and requirements definition.



, D426 WGU
Study online at https://quizlet.com/_fcu9gv
19. logical design phase: implements database requirements in a specific data-
base system. For relational database systems, logical design converts entities,
relationships, and attributes into tables, keys, and columns.
20. physical design: adds indexes and specifies how tables are organized on
storage media. Physical design affects query processing speed but never affects
the query result.
21. Data independence: allows database administrators to improve query perfor-
mance by changing the organization of data on storage devices, without affecting
query results.
22. application programming interface (API): To simplify the use of SQL with
a general-purpose language, database programs typically use an application pro-
gramming interface.
23. MySQL Command-Line Client: a text interface included in the MySQL Server
download. MySQL Server returns an error code and description when an SQL
statement is syntactically incorrect or the database cannot execute the statement.
24. tuple: an ordered collection of elements enclosed in parentheses
25. a table has...: a name, a fixed tuple of columns, and a varying set of rows.
26. A column has...: a name and a data type.
27. a row is...: an unnamed tuple of values. Each value corresponds to a column
and belongs to the column's data type.
28. a data-type is...: a named set of values, from which column values are drawn.
29. Business rules: based on business policy and specific to a particular database
30. literals: Explicit values that are string, numeric, or binary. Strings must be
surrounded by single quotes or double quotes. Binary values are represented with
x '0' where the 0 is any hex value.
31. keywords: Words with special meaning.
32. identifiers: Objects from the database like tables, columns, etc.
33. comments: Statement intended only for humans and ignored by the database
when parsing an SQL statement.
34. Data Definition Language (DDL): defines the structure of the database.
35. Data Query Language (DQL): retrieves data from the database.
36. Data Manipulation language (DML): manipulates data stored in a database
37. Data Control Language (DCL): controls database user access
38. Data Transaction Language (DTL): manages database transactions.
39. empty table: table without rows
40. ALTER TABLE: adds, deletes, or modifies columns on an existing table.
41. BIGINT: 8 bytes
42. INTEGER / INT: 4 bytes
43. MEDIUMINT: 3 bytes.

Voordelen van het kopen van samenvattingen bij Stuvia op een rij:

Verzekerd van kwaliteit door reviews

Verzekerd van kwaliteit door reviews

Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!

Snel en makkelijk kopen

Snel en makkelijk kopen

Je betaalt supersnel en eenmalig met iDeal, creditcard of Stuvia-tegoed voor de samenvatting. Zonder lidmaatschap.

Focus op de essentie

Focus op de essentie

Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!

Veelgestelde vragen

Wat krijg ik als ik dit document koop?

Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.

Tevredenheidsgarantie: hoe werkt dat?

Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.

Van wie koop ik deze samenvatting?

Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper ANTONYCARLOS. Stuvia faciliteert de betaling aan de verkoper.

Zit ik meteen vast aan een abonnement?

Nee, je koopt alleen deze samenvatting voor €20,91. Je zit daarna nergens aan vast.

Is Stuvia te vertrouwen?

4,6 sterren op Google & Trustpilot (+1000 reviews)

Afgelopen 30 dagen zijn er 82185 samenvattingen verkocht

Opgericht in 2010, al 14 jaar dé plek om samenvattingen te kopen

Start met verkopen
€20,91
  • (0)
  Kopen