• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 2 out of 12 pages
Exam (elaborations)

D426 Study Guide – Complete With Correct Solutions

Document preview thumbnail
Preview 2 out of 12 pages

D426 Study Guide – Complete With Correct Solutions

Content preview

D426 Study Guide – Complete With Correct Solutions

Database Application Right Ans - software that helps business users
interact with database systems

Database Administrator Right Ans - Responsible for securing the database
system against unauthorized users. Enforces procedures for user access and
database system availability.

Authorization Right Ans - Many database users should have limited access
to specific tables, columns, or rows of a database. Database systems authorize
individual users to access specific data.

Rules Right Ans - Database systems ensure data is consistent with
structural and business rules.

Query Processor Right Ans - interprets queries, creates a plan to modify
the database or retrieve data, and returns query results to the application.

Query Optimization Right Ans - ensures the most efficient instructions are
executed on the data

Storage Manager Right Ans - translates the query processor instructions
into low-level file-system commands that modify or retrieve data.

Transaction Manager Right Ans - Ensures transactions are properly
executed. Prevents conflicts between concurrent transactions. Restores the
database to a consistent state in the event of a transaction or system failure.

INSERT Right Ans - Inserts rows into a table

SELECT Right Ans - Retrieves data from a table.

UPDATE Right Ans - Modifies data in a table.

DELETE Right Ans - Deletes rows from a table.

CREATE TABLE Right Ans - Creates a new table by specifying the table and
column names.

, Data Type Right Ans - Indicates the format of column values. Can be
numeric, textual, or complex.

INT Right Ans - Stores integer values

DECIMAL Right Ans - Stores fractional numeric values.

VARCHAR Right Ans - Stores textual values

DATE Right Ans - Stores year, month, and day.

Analysis Phase Right Ans - Specifies database requirements without regard
to a specific database system. Requirements are represented as entities,
relationships, and attributes. An entity is a person, place, or thing. A
relationship is a link between entities, and a attribute is a descriptive property
of an entity.

Analysis Right Ans - Has many names, such as conceptual design, entity-
relationship modeling, and requirements definition.

Logical Design Phase Right Ans - Implements database requirements in a
specific database system. Converts the entity-relationship model into tables,
columns, and keys for a particular database system.

Physical Design Phase Right Ans - Adds indexes and specifies how tables
are organized on storage media. Affects query processing speed but never
affects the query result.

Data Independence Right Ans - The principle that physical design never
affects query results. Allows database designers to tune query performance
without changes to application programs.

Tuple Right Ans - an ordered collection of elements enclosed in
parentheses. Ex: (a, b, b) and (c, b, a).

Table Right Ans - Has a name, a fixed tuple of columns, and a varying set of
rows.

Document information

Uploaded on
January 8, 2025
Number of pages
12
Written in
2024/2025
Type
Exam (elaborations)
Contains
Questions & answers
$11.49

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
NorthWest
4.1
(175)
Sold
849
Followers
673
Items
6785
Last sold
2 days ago




Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions