MIS 380 - ALL QUIZ QUESTIONS QUESTIONS AND CORRECT
DETAILED ANSWERS (VERIFIED ANSWERS) |ALREADY
GRADED A+||BRAND NEW
Refer to the Teacher and Class tables. What is the result of the SET
NULL foreign key action when Bryan McNeal's TeacherID is changed
to 45672? (Ch.2) Ans✓✓✓The Web Development TeacherID is set to
NULL
A _____ is a collection of values with no inherent order. (Ch.2)
Ans✓✓✓set
Evaluate the given data and determine the correct result from the
statement. (Ch.2) Ans✓✓✓485
A _____ is a collection of values that are of the same type.
Ans✓✓✓column
When only one value exists in each cell, a table is known to be _____.
Ans✓✓✓nomalized
A value that is used in a computation is known as a/an _____.
Ans✓✓✓operand
In the Reservation table below, a room may be reserved several times, so
the RoomNumber column is not unique. To ensure that a room can only
be reserved by only one guest for the day, the minimal primary key
, consists of which columns? (Ch.2) Ans✓✓✓(RoomNumber,
DateOfStay)
In MySQL, what is the result of TRUE AND NULL? Ans✓✓✓NULL
Which data type should a database use to store negative numbers?
Ans✓✓✓INT
Refer to the Teacher and Class tables. When Bryan McNeal was deleted
from the Teacher table, the TeacherID for the Web Development course
was automatically changed to 11234. Which foreign key action is the
TeacherID likely using? (Ch.2) Ans✓✓✓SET DEFAULT
Refer to the Teacher and Class tables. Which foreign key action updates
the TeacherID for the Web Development course when Bryan McNeal's
TeacherID is updated to 45672? (Ch.2) Ans✓✓✓CASCADE
A database administrator creates a new relational database, and a
primary key is assigned within a table to assist with governing data.
What does the administrator accomplish with this structural rule?
Ans✓✓✓Unique identification of individual rows in the table
In MySQL, what is the result of TRUE OR NULL? Ans✓✓✓TRUE
A NULL value represents _____ data. Ans✓✓✓missing
DETAILED ANSWERS (VERIFIED ANSWERS) |ALREADY
GRADED A+||BRAND NEW
Refer to the Teacher and Class tables. What is the result of the SET
NULL foreign key action when Bryan McNeal's TeacherID is changed
to 45672? (Ch.2) Ans✓✓✓The Web Development TeacherID is set to
NULL
A _____ is a collection of values with no inherent order. (Ch.2)
Ans✓✓✓set
Evaluate the given data and determine the correct result from the
statement. (Ch.2) Ans✓✓✓485
A _____ is a collection of values that are of the same type.
Ans✓✓✓column
When only one value exists in each cell, a table is known to be _____.
Ans✓✓✓nomalized
A value that is used in a computation is known as a/an _____.
Ans✓✓✓operand
In the Reservation table below, a room may be reserved several times, so
the RoomNumber column is not unique. To ensure that a room can only
be reserved by only one guest for the day, the minimal primary key
, consists of which columns? (Ch.2) Ans✓✓✓(RoomNumber,
DateOfStay)
In MySQL, what is the result of TRUE AND NULL? Ans✓✓✓NULL
Which data type should a database use to store negative numbers?
Ans✓✓✓INT
Refer to the Teacher and Class tables. When Bryan McNeal was deleted
from the Teacher table, the TeacherID for the Web Development course
was automatically changed to 11234. Which foreign key action is the
TeacherID likely using? (Ch.2) Ans✓✓✓SET DEFAULT
Refer to the Teacher and Class tables. Which foreign key action updates
the TeacherID for the Web Development course when Bryan McNeal's
TeacherID is updated to 45672? (Ch.2) Ans✓✓✓CASCADE
A database administrator creates a new relational database, and a
primary key is assigned within a table to assist with governing data.
What does the administrator accomplish with this structural rule?
Ans✓✓✓Unique identification of individual rows in the table
In MySQL, what is the result of TRUE OR NULL? Ans✓✓✓TRUE
A NULL value represents _____ data. Ans✓✓✓missing
