Written by students who passed Immediately available after payment Read online or as PDF Wrong document? Swap it for free 4.6 TrustPilot
logo-home
Exam (elaborations)

WGU - C170 - Data Management Applications 2023/2024

Rating
-
Sold
-
Pages
3
Grade
A+
Uploaded on
10-02-2023
Written in
2022/2023

WGU - C170 - Data Management Applications 2023/2024 Create Database Syntax Ans- CREATE DATABASE db_name; Simple SFW query syntax Ans- SELECT * FROM db_name WHERE column_name operator value; Cardinality: Inside or outside? Ans- Outside Modality: Inside or outside? Ans- Inside What commands are used with data definition? Ans- create, alter, drop, truncate, comment, rename What commands are used with data manipulation? Ans- Select, Insert, Update, Delete, Merge, Call, Explain Plan, Lock Table Create Table Syntax Ans- CREATE TABLE table_name ( column_name1 data_type(size), column_name2 data_type(size), ); What does AUTO_INCREMENT attribute do for numeric values? Ans- It generates a series of unique identifier values. CREATE VIEW SYNTAX Ans- CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition Primary Key Syntax Ans- CREATE TABLE table_name ( column1 data_type(size) PRIMARY KEY (column1) ); Create Index Syntax Ans- CREATE INDEX index_name ON table_name(column_name) Insert syntax Ans- INSERT INTO table_name VALUES (value1,value2,value3,...); Grant command syntax Ans- GRANT privileges ON object TO user; Drop Syntax: Table, Index, Database Ans- DROP TABLE table_name; ALTER TABLE table_name DROP INDEX index_name; DROP DATABASE database_name Count() Syntax Ans- SELECT COUNT(column_name) FROM table_name; returns # of values in a column SELECT COUNT(*) FROM table_name; returns number of records in a table Inner Join Description Ans- Returns all rows when there is at leas

Show more Read less
Institution
Course

Content preview

WGU - C170 - Data Management
Applications 2023/2024
Create Database Syntax Ans- CREATE DATABASE db_name;



Simple SFW query syntax Ans- SELECT * FROM db_name WHERE column_name operator value;



Cardinality: Inside or outside? Ans- Outside



Modality: Inside or outside? Ans- Inside



What commands are used with data definition? Ans- create, alter, drop, truncate, comment, rename



What commands are used with data manipulation? Ans- Select, Insert, Update, Delete, Merge, Call,
Explain Plan, Lock Table



Create Table Syntax Ans- CREATE TABLE table_name

(

column_name1 data_type(size),

column_name2 data_type(size),

);



What does AUTO_INCREMENT attribute do for numeric values? Ans- It generates a series of unique
identifier values.



CREATE VIEW SYNTAX Ans- CREATE VIEW view_name AS

SELECT column_name(s)

FROM table_name

WHERE condition

Written for

Course

Document information

Uploaded on
February 10, 2023
Number of pages
3
Written in
2022/2023
Type
Exam (elaborations)
Contains
Questions & answers

Subjects

$10.79
Get access to the full document:

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

Get to know the seller

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.
CertifiedGrades Chamberlain College Of Nursing
Follow You need to be logged in order to follow users or courses
Sold
145
Member since
3 year
Number of followers
61
Documents
8739
Last sold
1 month ago
High Scores

Hi there! Welcome to my online tutoring store, your ultimate destination for A+ rated educational resources! My meticulously curated collection of documents is designed to support your learning journey. Each resource has been carefully revised and verified to ensure top-notch quality, empowering you to excel academically. Feel free to reach out to consult with me on any subject matter—I'm here to help you thrive!

3.9

38 reviews

5
21
4
6
3
2
2
3
1
6

Recently viewed by you

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