WGU C170 Focused on MSQL Code Problem Set Exam Questions with Complete Answers 2024/2025
5 views 0 purchase
Course
WGU 170
Institution
WGU 170
WGU C170 Focused on MSQL Code Problem Set Exam Questions with Complete Answers 2024/2025
Create a brand-new table. - correct answer CREATE TABLE tableName (
column1 datatype,
column2 datatype,
column3 datatype
Delete an entire table along with all the table rows from a database. - corre...
Delete an entire table along with all the table rows from a database. - correct answer
DROP TABLE tableName;
Data Type: Integer with range 0-255 - correct answer TINYINT UNSIGNED
Data Type: Integer with range 0-65,535 - correct answer SMALLINT UNSIGNED
Data Type: Integer with range 0-16,777,215 (16.8 million) - correct answer
MEDIUMINT UNSIGNED
Data Type: Integer with range 0 - 4,294,967,295 (4.3 billion) - correct answer
INTEGER UNSIGNED
can also use:
INT UNSIGNED
Data Type: Integer with range 0 - 2^64 -1 - correct answer BIGINT UNSIGNED
Data Type: Use for things like prices with a set number of decimal places. IE: A store
that sells items up to $10,000.00. - correct answer DECIMAL(M,D) where M = number
of significant digits
D= number of digits after decimal point.
,IE: Store with prices up to $10,000.00 would use
DECIMAL(7,2)
Data Type: Approximate decimal numbers with range -3.4E+38 to 3.4E+38 (uses only 4
bits of data) - correct answer FLOAT
Data Type: Approximate decimal numbers with range -1.8E+308 to 1.8E+308 (uses 8
bits of data) - correct answer DOUBLE
Data Type: Format 'YYYY-MM-DD' - correct answer DATE
Data Type: Format 'hh:mm:ss' - correct answer TIME
Data Type: Format 'YYYY-MM-DD hh:mm:ss' - correct answer DATETIME
Data Type: Fixed length string of N characters - correct answer CHAR(N)
Data Type: Variable length string up to N characters - correct answer VARCHAR(N)
After creating a table, this code is used to fill in the rows. Can also be used to add in
new rows later on. - correct answer INSERT INTO...VALUES
, Select all columns from a table - correct answer SELECT *
FROM tableName;
Create a new database - correct answer CREATE DATABASE databaseName;
Delete an entire database and all associated tables. - correct answer DROP
DATABASE databaseName;
Lists all databases. - correct answer SHOW DATABASES;
Lists all tables in a particular database. - correct answer USE databaseName;
SHOW TABLES;
List all columns in a table from a database. - correct answer USE databaseName;
SHOW TABLES;
SHOW COLUMNS
FROM tableName;
Create a new column on an existing table. - correct answer ALTER TABLE tableName
Add columnName DataType;
Modify a column name or data type in an existing table. - correct answer ALTER
TABLE tableName
CHANGE columnName newColumnName newDataType;
Delete a column in an existing table. - correct answer ALTER TABLE
DROP columnName;
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 KieranKent55. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
