100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
Previously searched by you
WGU D427 DATA MANAGEMENT APPLICATIONS OA FINAL EXAM MULTIPLE CHOICE & QUERY BASED QUESTIONS ALL 250 QUESTIONS AND VERIFIED CORRECT ANSWERS LATEST 2024$12.49
Add to cart
WGU D427 DATA MANAGEMENT APPLICATIONS OA FINAL EXAM MULTIPLE CHOICE &
QUERY BASED QUESTIONS ALL 250 QUESTIONS AND VERIFIED CORRECT ANSWERS
LATEST 2024
1. These operations relational algebra
are collectively
called
and are
the theoretical foun-
dation of the SQL
language. Since the
result of relational
operations is always
a table, the result of
an SQL query is also
a table.
2. Relational Algebra selects a subset of rows of a table.
operation: Select
3. Relational Algebra eliminates one or more columns of a table.
operation: Project
4. Relational Algebra lists all combinations of rows of two tables.
operation: Product *In the example, the product operation selects all
combinations of Employee (table) and Department
(table) rows
5. Relational Algebra combines two tables by comparing related columns.
operation: Join
, WGU D427 DATA MANAGEMENT APPLICATIONS OA FINAL EXAM MULTIPLE CHOICE &
QUERY BASED QUESTIONS ALL 250 QUESTIONS AND VERIFIED CORRECT ANSWERS
LATEST 2024
6. Relational Algebra selects all rows of two tables.
operation: Union
7. Relational Algebra selects rows common to two tables.
operation: Intersect
8. Relational Algebra selects rows that appear in one table but not another.
operation: Differ-
ence
9. Relational Algebra changes a table name.
operation: Rename
10. Relational Algebra computes functions over multiple table rows, such as
operation: Aggre- sum and count.
gate
11. Relational rules are constraints
implemented as SQL
and
enforced by the data-
base system.
12. Name 3 relational Unique Primary Key
rules: Unique Column Names
No duplicate rows
13. Business rules business policy
are based
on
and spe-
cific to a particular
database.
14. The mathemati- Data Type
cal term "Do-
main" is synony-
mous with what
Database term?
, WGU D427 DATA MANAGEMENT APPLICATIONS OA FINAL EXAM MULTIPLE CHOICE &
QUERY BASED QUESTIONS ALL 250 QUESTIONS AND VERIFIED CORRECT ANSWERS
LATEST 2024
15. The database term Column
"column" is synony-
mous with what File
System term?
16. What is SQL? a high-level computer language for storing, manipu-
lating, and retrieving data.
17. SQL syntax type: Lit- Explicit values that are string, numeric, or binary.
eral Strings must be surrounded by single quotes or dou-
ble quotes.Binary values are represented with x'0'
where the 0 is any hex value.
18. What is the defini- Words with special meaning. (i.e. commands)
tion of an SQL Key-
word?
19. SQL identifiers are tables, columns, etc.
objects from the
database like:
20. A statement intend- Comment
ed only for humans
and ignored by the
database when pars-
ing an SQL state-
ment., is considered
what?
21. The command: 2
INSERT INTO Stu-
dent
VALUES (888 ,
, WGU D427 DATA MANAGEMENT APPLICATIONS OA FINAL EXAM MULTIPLE CHOICE &
QUERY BASED QUESTIONS ALL 250 QUESTIONS AND VERIFIED CORRECT ANSWERS
LATEST 2024
'Smith', 'Jim', 3.0) ;
Has how many
clauses?
22. SQL Sublanguage: Defines the structure of the database.
Data Definition Lan- *The primary commands are: CREATE, ALTER,
guage (DDL) DROP, TRUNCATE, & RENAME
23. SQL Sublanguage: retrieves data from the database.
Data Query Lan- *Primary command being SELECT
guage (DQL)
24. SQL Sublanguage: manipulates data stored in a database.
Data Manipulation *The primary commands are: INSERT, UPDATE,
Language (DML) DELETE, & MERGE
25. SQL Sublanguage: controls database user access.
Data Control Lan-
guage (DCL)
26. SQL Sublanguage: manages database transactions.
Data Transaction *commits data to a database, rolls back data from a
Language (DTL) database, and creates savepoints.
27. A single executing database system instance
copy of a database
system is called
what?
28. The state- SHOW
ment provides data-
base users and
administrators with
information about
databases, the data-
base contents (ta-
bles, columns, etc.),
and server status in-
formation.
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 tivakiok. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.
