Western Governors University D 426
SQL D427 Applications Exam CORRECT DETAILED
ANSWERS (VERIFIED ANSWERS) NEWEST
UPDATED VERSION |GUARANTEED PASS A+
Terms in this set (25)
Children living within the boundaries of two 3
school districts will be attending one of four
different schools.
How many entities are present in the
narrative?
Which data type will store "2022-01-10 datetime
14:22:12" as a temporal value without loss of
3 multiple choice options
information?
A data set currently contains horse details. A Many-to-Many
new requirement specifies that horses can
be entered into competitions.
What is the cardinality of the horse-to-
competition relationship?
What is a primary function of a Database Storing, retrieving, and managing data
Management System (DBMS)?
, What is the role of SQL in a database It is used to query and manipulate data
system?
Which term refers to a unique identifier for Primary Key
a record in a database table?
The School table will have the following CREATE TABLE School
columns: ( SchoolID INT
SchoolID—positive integer UNSIGNED,
SchoolName—variable-length string, SchoolName VARCHAR(50),
maximum 50 characters DateConstructed DATE,
DateConstructed—date OperatingBudget DECIMAL(3,1) UNSIGNED,
OperatingBudget—positive decimal value of Classification CHAR(1),
up to 99.9, with one decimal place President VARCHAR(20)
Classification—fixed-length string with one );
character SHOW COLUMNS FROM School
President—variable-length string, maximum
20 characters
Write an SQL statement to create the
School table.
Do not add any additional constraints to any
column beyond what is stated.
Note: If you want to test the output of your
code, place the following query at the
end of your code, replacing [table_name]
with the name of your table:
SHOW COLUMNS FROM [table_name];
The Rating table has the following columns: CREATE TABLE Movie
RatingCode—variable-length string, ( Title VARCHAR(30),
maximum 5 characters, primary key RatingCode VARCHAR(5),
RatingDescription—variable-length string, FOREIGN KEY (RatingCode) REFERENCES
maximum 30 characters Rating(RatingCode)
The Movie table should have the following );
columns:
Title—variable-length string, maximum 30
characters
RatingCode—variable-length string,
maximum 5 characters
Genre—variable-length string, maximum
30 characters
Year—positive integer indicating the year
the movie was released
Write SQL statements to create the Movie
table. Designate the RatingCode column in
the Movie table as a foreign key to the
RatingCode column in the Rating table.
Note: If you want to test the output of your
code, place the following query at the
end of your code, replacing [table_name]
with the name of your table:
SHOW COLUMNS FROM [table_name];
SQL D427 Applications Exam CORRECT DETAILED
ANSWERS (VERIFIED ANSWERS) NEWEST
UPDATED VERSION |GUARANTEED PASS A+
Terms in this set (25)
Children living within the boundaries of two 3
school districts will be attending one of four
different schools.
How many entities are present in the
narrative?
Which data type will store "2022-01-10 datetime
14:22:12" as a temporal value without loss of
3 multiple choice options
information?
A data set currently contains horse details. A Many-to-Many
new requirement specifies that horses can
be entered into competitions.
What is the cardinality of the horse-to-
competition relationship?
What is a primary function of a Database Storing, retrieving, and managing data
Management System (DBMS)?
, What is the role of SQL in a database It is used to query and manipulate data
system?
Which term refers to a unique identifier for Primary Key
a record in a database table?
The School table will have the following CREATE TABLE School
columns: ( SchoolID INT
SchoolID—positive integer UNSIGNED,
SchoolName—variable-length string, SchoolName VARCHAR(50),
maximum 50 characters DateConstructed DATE,
DateConstructed—date OperatingBudget DECIMAL(3,1) UNSIGNED,
OperatingBudget—positive decimal value of Classification CHAR(1),
up to 99.9, with one decimal place President VARCHAR(20)
Classification—fixed-length string with one );
character SHOW COLUMNS FROM School
President—variable-length string, maximum
20 characters
Write an SQL statement to create the
School table.
Do not add any additional constraints to any
column beyond what is stated.
Note: If you want to test the output of your
code, place the following query at the
end of your code, replacing [table_name]
with the name of your table:
SHOW COLUMNS FROM [table_name];
The Rating table has the following columns: CREATE TABLE Movie
RatingCode—variable-length string, ( Title VARCHAR(30),
maximum 5 characters, primary key RatingCode VARCHAR(5),
RatingDescription—variable-length string, FOREIGN KEY (RatingCode) REFERENCES
maximum 30 characters Rating(RatingCode)
The Movie table should have the following );
columns:
Title—variable-length string, maximum 30
characters
RatingCode—variable-length string,
maximum 5 characters
Genre—variable-length string, maximum
30 characters
Year—positive integer indicating the year
the movie was released
Write SQL statements to create the Movie
table. Designate the RatingCode column in
the Movie table as a foreign key to the
RatingCode column in the Rating table.
Note: If you want to test the output of your
code, place the following query at the
end of your code, replacing [table_name]
with the name of your table:
SHOW COLUMNS FROM [table_name];
