OMIS 452 Questions and Answers
Save
Practice questions for this set
Learn 1 /7 Study with Learn
;
Choose an answer
A user creates a table by using a SQL
When using the MySQL Command- statement. The data type
1 Line Client, which character ends a 2 VARCHAR(11) is part of the
command? statement. What does the value of
(11) represent?
A foreign key in which all columns
What does a user that interacts with a
3 4 are NULL is known as a _____ foreign
database use to read and write data?
key?
Don't know?
Terms in this set (32)
, A user creates a table by The number of characters allowed for the data type.
using a SQL statement. The
data type VARCHAR(11) is
part of the statement.
What does the value of (11)
represent?
How does a database Preventing multiple transactions with the same data at
system protect data when the same time.
concurrent transactions
occur?
Redundancy is possible in second
a _____ normal form table
when one non-key column
depends on another non-
key column.
The EmployeeWorkspace WorkspaceID
table has a composite key
of (EmployeeID,
WorkspaceID). WorkHours
depends on (EmployeeID,
WorkspaceID), and
EmployeeLastName
depends on EmployeeID.
Which column must be
removed so
EmployeeWorkspace is in
second normal form?
A foreign key in which all fully NULL
columns are NULL is
known as a _____ foreign
key?
What data type stores BLOB
binary values?
Save
Practice questions for this set
Learn 1 /7 Study with Learn
;
Choose an answer
A user creates a table by using a SQL
When using the MySQL Command- statement. The data type
1 Line Client, which character ends a 2 VARCHAR(11) is part of the
command? statement. What does the value of
(11) represent?
A foreign key in which all columns
What does a user that interacts with a
3 4 are NULL is known as a _____ foreign
database use to read and write data?
key?
Don't know?
Terms in this set (32)
, A user creates a table by The number of characters allowed for the data type.
using a SQL statement. The
data type VARCHAR(11) is
part of the statement.
What does the value of (11)
represent?
How does a database Preventing multiple transactions with the same data at
system protect data when the same time.
concurrent transactions
occur?
Redundancy is possible in second
a _____ normal form table
when one non-key column
depends on another non-
key column.
The EmployeeWorkspace WorkspaceID
table has a composite key
of (EmployeeID,
WorkspaceID). WorkHours
depends on (EmployeeID,
WorkspaceID), and
EmployeeLastName
depends on EmployeeID.
Which column must be
removed so
EmployeeWorkspace is in
second normal form?
A foreign key in which all fully NULL
columns are NULL is
known as a _____ foreign
key?
What data type stores BLOB
binary values?
