D427 Data Management Applications Pre-Assessment questions and complete verified correct answers

D427 Data Management Applications Pre-Assessment
questions and complete verified correct answers

1.4: San Francisco, CA
94110 USA
How many attributes are present in the address fragment?
2.TrackingNumber: The Package table has the following
columns: Weight—decimal
Description—optional variable length
string LastChangedDate—date
TrackingNumber—integer
Which column should be designated the primary key for the Package
table?
3.DATETIME: Which data type will store "2022-01-10 14:22:12" as a
temporal value without loss of information?
4.CREATE, ALTER DROP: Which SQL command is an example of data
definition language (DDL)?
5.The update would be rejected by the database.: How would a database
engine process an update that violates a RESTRICT referential integrity
constraint?
6.CREATE TABLE Member
( ID INT UNSIGNED,
FirstName
VARCHAR(100),
MiddleInitial CHAR(1),
LastName VARCHAR(100),
DateOfBirth DATE,
AnnualPledge DECIMAL(8,2) UNSIGNED
);: The Member table will have the following columns:
ID—positive integer
FirstName—variable-length string with up to 100
characters MiddleInitial—fixed-length string with 1
character LastName—variable-length string with up
to 100 characters DateOfBirth—date
AnnualPledge—positive decimal value representing a cost of up to
$999,999, with 2 digits for cents
Write a SQL statement to create the Member table.
7.CREATE TABLE
Movie( Title
VARCHAR(30),
RatingCode VARCHAR(5),
1/
11

, D427 Data Management Applications Pre-Assessment
questions and complete verified correct answers
FOREIGN KEY(RatingCode) REFERENCE Rating(RatingCode)
);: The Rating table has the following columns:
RatingCode—variable-length string, primary key
RatingDescription—variable-length string
The Movie table should have the following columns:




2/
11