FINAL COMP SCI 221 QUESTIONS AND ANSWERS LATEST
UPDATE
A _____ constraint is used to define a column value that is not NULL when no
value is provided.
A default constraint is used to define a column value that is not NULL when no value is
provided. A default constraint specifies a default value for a column when an INSERT or
UPDATE statement does not provide a value for the column.
What does a user that interacts with a database use to read and write data?
Users typically use SQL (Structured Query Language) to read and write data from a
database. SQL is a standard programming language used to create, modify, and query
databases. It is widely used and supported by most DBMSs and database access
interfaces.
If a database system is processing three queries as part of a transaction and the
third query fails, what happens to the transaction?
If a database system is processing a transaction and one of the queries within the
transaction fails, the entire transaction will be rolled back. This means that any changes
made by the queries that have been processed before the failure will be undone, and
the database will be restored to its state before the transaction began. This is known as
atomic behavior, and it is a fundamental property of transactions in database systems.
By ensuring that transactions are either completed in their entirety or not completed at
all, databases can maintain the integrity and consistency of the data they store.The
successful query results are reversed, and the transaction is canceled.
An entity named Stadium contains a primary key SeatNumber and a plural
attribute SeatReservation which records spectator seat assignments. During
implementation, the plural attributes move to a new table named _____.
If the plural attribute "SeatReservation" in the "Stadium" entity is moved to a new table,
the new table could be named "SeatReservations" or "SeatAssignments" to reflect the
fact that it contains records of seat assignments for spectators. The name of the new
table could also include a reference to the "Stadium" entity, such as
"StadiumSeatReservations" or "StadiumSeatAssignments". It is important to choose a
descriptive and meaningful name for the new table to help ensure that its purpose and
contents are clear to anyone who may need to work with it.
In the following ER diagram, what does 'AlbumTitle' represent?
Two tables connected by a line. The first table has header Artist with entries ID,
Fname, Lname. The second table has a header Album with entries ID, AlbumYear,
AlbumTitle. The word Records appears above the line.
In the given ER diagram, the "AlbumTitle" attribute represents the title of an album
recorded by an artist. The diagram shows two tables: an "Artist" table with the attributes
"ID", "Fname", and "Lname", and an "Album" table with the attributes "ID", "AlbumYear",
and "AlbumTitle". The word "Records" appears above the line connecting the two
tables, indicating that there is a relationship between the two entities. This relationship
can be interpreted as follows: an artist records one or more albums, and each album is
, recorded by a specific artist. The "AlbumTitle" attribute is part of the "Album" table and
represents the title of the album recorded by the artist.
In a relational database model, which concept refers to a finite sequence of
values that are derived from defined domains?
In a relational database model, a column refers to a finite sequence of values that are
derived from defined domains.
A column, also known as an attribute, is a field in a database table that stores a specific
piece of data for each record in the table. Each column has a unique name and is
associated with a specific data type, which defines the kind of values that can be stored
in the column. For example, a column with the data type "integer" can only store whole
numbers, while a column with the data type "text" can store alphanumeric characters.
When only one value exists in each cell, a table is known to be _____.
When only one value exists in each cell of a table, the table is known to be in first
normal form (1NF).
First normal form is a property of a table in a relational database that indicates that the
table is organized in a way that satisfies certain rules. One of the main rules of 1NF is
that each cell in the table must contain only a single value, and not a combination of
values or a list of values. This ensures that the data in the table is atomic, meaning that
it cannot be divided into smaller units without losing its meaning.
Other rules of 1NF include the requirement that each column in the table must have a
unique name, and that the table must not have any repeating groups of columns. These
rules help to ensure that the data in the table is well-structured and easy to work with.
By following the rules of 1NF, it is easier to design and implement efficient and effective
database systems.
normalized
A value that is used in a computation is known as a/an _____.
A value that is used in a computation is known as an operand. An operand is a value on
which an operation is performed. It is the object of a mathematical operation and can be
a number, a variable, or any other object that can be manipulated mathematically. In
programming, operands are often referred to as arguments or parameters. For example,
in the expression "2 + 3," the values "2" and "3" are operands, and the "+" symbol
represents the operation of addition.
Refer to the Teacher and Class tables. The action SET NULL is specified for the
TeacherID foreign key. What is the result when Bryan McNeal's TeacherID is
changed to 45672?
The TeacherID for Web Development is set to NULL.
Refer to the Product table. Which columns are present in the query's result table?
SELECT * FROM Product;
All columns are present
Refer to the Product table. How many rows appear in the query's result table?
SELECT DISTINCT Size FROM Product;
Four rows
Refer to the Product table. Complete the SQL statement so the result table shows
63, which is the total quantity of all products.
UPDATE
A _____ constraint is used to define a column value that is not NULL when no
value is provided.
A default constraint is used to define a column value that is not NULL when no value is
provided. A default constraint specifies a default value for a column when an INSERT or
UPDATE statement does not provide a value for the column.
What does a user that interacts with a database use to read and write data?
Users typically use SQL (Structured Query Language) to read and write data from a
database. SQL is a standard programming language used to create, modify, and query
databases. It is widely used and supported by most DBMSs and database access
interfaces.
If a database system is processing three queries as part of a transaction and the
third query fails, what happens to the transaction?
If a database system is processing a transaction and one of the queries within the
transaction fails, the entire transaction will be rolled back. This means that any changes
made by the queries that have been processed before the failure will be undone, and
the database will be restored to its state before the transaction began. This is known as
atomic behavior, and it is a fundamental property of transactions in database systems.
By ensuring that transactions are either completed in their entirety or not completed at
all, databases can maintain the integrity and consistency of the data they store.The
successful query results are reversed, and the transaction is canceled.
An entity named Stadium contains a primary key SeatNumber and a plural
attribute SeatReservation which records spectator seat assignments. During
implementation, the plural attributes move to a new table named _____.
If the plural attribute "SeatReservation" in the "Stadium" entity is moved to a new table,
the new table could be named "SeatReservations" or "SeatAssignments" to reflect the
fact that it contains records of seat assignments for spectators. The name of the new
table could also include a reference to the "Stadium" entity, such as
"StadiumSeatReservations" or "StadiumSeatAssignments". It is important to choose a
descriptive and meaningful name for the new table to help ensure that its purpose and
contents are clear to anyone who may need to work with it.
In the following ER diagram, what does 'AlbumTitle' represent?
Two tables connected by a line. The first table has header Artist with entries ID,
Fname, Lname. The second table has a header Album with entries ID, AlbumYear,
AlbumTitle. The word Records appears above the line.
In the given ER diagram, the "AlbumTitle" attribute represents the title of an album
recorded by an artist. The diagram shows two tables: an "Artist" table with the attributes
"ID", "Fname", and "Lname", and an "Album" table with the attributes "ID", "AlbumYear",
and "AlbumTitle". The word "Records" appears above the line connecting the two
tables, indicating that there is a relationship between the two entities. This relationship
can be interpreted as follows: an artist records one or more albums, and each album is
, recorded by a specific artist. The "AlbumTitle" attribute is part of the "Album" table and
represents the title of the album recorded by the artist.
In a relational database model, which concept refers to a finite sequence of
values that are derived from defined domains?
In a relational database model, a column refers to a finite sequence of values that are
derived from defined domains.
A column, also known as an attribute, is a field in a database table that stores a specific
piece of data for each record in the table. Each column has a unique name and is
associated with a specific data type, which defines the kind of values that can be stored
in the column. For example, a column with the data type "integer" can only store whole
numbers, while a column with the data type "text" can store alphanumeric characters.
When only one value exists in each cell, a table is known to be _____.
When only one value exists in each cell of a table, the table is known to be in first
normal form (1NF).
First normal form is a property of a table in a relational database that indicates that the
table is organized in a way that satisfies certain rules. One of the main rules of 1NF is
that each cell in the table must contain only a single value, and not a combination of
values or a list of values. This ensures that the data in the table is atomic, meaning that
it cannot be divided into smaller units without losing its meaning.
Other rules of 1NF include the requirement that each column in the table must have a
unique name, and that the table must not have any repeating groups of columns. These
rules help to ensure that the data in the table is well-structured and easy to work with.
By following the rules of 1NF, it is easier to design and implement efficient and effective
database systems.
normalized
A value that is used in a computation is known as a/an _____.
A value that is used in a computation is known as an operand. An operand is a value on
which an operation is performed. It is the object of a mathematical operation and can be
a number, a variable, or any other object that can be manipulated mathematically. In
programming, operands are often referred to as arguments or parameters. For example,
in the expression "2 + 3," the values "2" and "3" are operands, and the "+" symbol
represents the operation of addition.
Refer to the Teacher and Class tables. The action SET NULL is specified for the
TeacherID foreign key. What is the result when Bryan McNeal's TeacherID is
changed to 45672?
The TeacherID for Web Development is set to NULL.
Refer to the Product table. Which columns are present in the query's result table?
SELECT * FROM Product;
All columns are present
Refer to the Product table. How many rows appear in the query's result table?
SELECT DISTINCT Size FROM Product;
Four rows
Refer to the Product table. Complete the SQL statement so the result table shows
63, which is the total quantity of all products.
