DATA MANAGEMENT APPLICATION WGU D427 ACTUAL
EXAM LATEST 2024/2025 QUESTIONS AND VERIFIED
CORRECT ANSWERS/ ALREADY GRADED A++
DDL - ANSWER ALTER
DDL - ANSWER DROP
DDL - ANSWER CREATE
DQL - ANSWER SELECT
DCL - ANSWER GRANT
DCL - ANSWER REVOKE
DML - ANSWER INSERT
.
DML - ANSWER UPDATE
DML - ANSWER DELETE
DTL - ANSWER COMMIT
DTL - ANSWER ROLLBACK
DTL - ANSWER SAVEPOINT
DDL - ANSWER ALTER, DROP, CREATE
DQL - ANSWER SELECT
DML - ANSWER INSERT, UPDATE, DELETE
DCL - ANSWER GRANT, REVOKE
DTL - ANSWER COMMIT, ROLLBACK, SAVEPOINT.
Synonyms for TABLE - ANSWER MATH: Relation
Files: File
,Synonyms for COLUMN - ANSWER MATH: Attribute
FILE: Field
Synonyms for ROW - ANSWER MATH: Tuple
FILE: Record
Synonyms for DATA TYPE - ANSWER MATH: Domain
FILE: Data Type :)
What language defines the structure of the database. AKA deals with
tables - ANSWER DDL
What language retrieves data from the database. - ANSWER DQL
What language manipulates data stored in a database. AKA deals with
rows - ANSWER DML
What language controls database user access. - ANSWER DC.
DDL - ANSWER Create, Alter, Drop, Rename, Truncate
DML - ANSWER Delete, Update, Insert, Select
DML - ANSWER changes/chooses rows of data
DDL - ANSWER changes table structure/columns
CREATE VIEW - ANSWER CREATE VIEW ... AS
SELECT
FROM
GROUP BY - ANSWER Used when you are asked to list or aggregate the
data
COUNT, SUM, AVG,MAX,MIN
by/per/in each category
DELETE - ANSWER DELETE FROM
WHERE
,INSERT - ANSWER INSERT INTO
VALUES
DROP VIEW - ANSWER DROP VIEW view_name;
UPDATE - ANSWER UPDATE
SET
WHERE
SET=NULL
SELECT - ANSWER SELECT
WHERE
FROM
CREATE INDEX - ANSWER CREATE INDEX
ON
ALTER - ANSWER ALTER TABLE
ADD/DROP/ CHANGE
TINYINT - ANSWER Signed range: -128 to 127
Unsigned range: 0 to 255
SMALLINT - ANSWER Signed range: -32,768 to 32,767
Unsigned range: 0 to 65,535
MEDIUMINT - ANSWER Signed range: -8,388,608 to 8,388,607
Unsigned range: 0 to 16,777,215
BIGINT - ANSWER Signed range: -263 to 263 -1
Unsigned range: 0 to 264 -1
TRUNCATE - ANSWER Deletes records but keeps table for future use.
Add Column to Table - ANSWER Alter table Table_1
Add column Coulmn_1 Datatype;
Remove Table Column - ANSWER Alter Table Table_1
Drop Column_1;
, Change Column Name - ANSWER Alter Table Table_1
Rename Old_column to New_Column Datatype;
Change Datatype - ANSWER Alter Table Table_1
Modify Column_1 Datatype;
Insert values into table - ANSWER Insert into Table_1 (Column_1,
Column_2, etc)
Values (Column_1_value, Column_2_value, etc),
(Column_1_value_2, Column_2_value_2, etc);
Delete row from Table - ANSWER delete from Table_1 where Value = X
Create Table with Auto Increment and Primary Key - ANSWER Create
Table Table_1(
Column_1 Datatype Auto_Increment NOT NULL Primary Key,
Column_6 Datatype Default 'TX' NOT NULL,
Column_7 DatatypeUnique
);
Create Table with Check - ANSWER Create Table Table_1(
Column_1 Datatype AUTO_INCREMENT Primary Key,
Column_2 Datatype (15) NOT NULL,
Column_3 Datatype check (Column_3 in('Egyptian Arab', 'Holsteiner',
'Quarter Horse', 'Paint', 'Saddlebred')),
Column_4 Datatype check (Height between '10.0' and '20.0'),
Column_5 Datatype check (BirthDate >= '2015,1,1')
);
Create Table with PK and FK - ANSWER create Table LessonSchedule (
HorseID smallInt unsigned NOT NULL,
StudentID smallint unsigned,
LessonDateTime DateTime NOT NULL,
CONSTRAINT PK_Lesson PRIMARY KEY (HorseID, LessonDateTime),
Foreign Key (HorseID) References Horse(ID) ON Delete Cascade,
Foreign Key (StudentID) References Student(ID) On Delete Set NULL
);
Add Column to Table - ANSWER Alter table Table_1
ADD Column Column_1 Datatype;