1
CIT 381 FINAL EXAM QUESTIONS WITH
ANSWERS TESTED AND APPROVED BEST
QUALITY EXAM
Relational database tables inherently include row ordering. --
CORRECT ANSWER--false
-Order is not an inherent property of a set of data
the term associated with the absence of data in a column. --
CORRECT ANSWER--NULL
-Absence of any data value that could represent
Identify the keyword to effectively filter query results --CORRECT
ANSWER--WHERE
-used to filter by individual columns and expressions for rows
Identify the number of rows returned from the following query.
SELECT COUNT(*) FROM actors --CORRECT ANSWER--
However many rows are in the actors table
-COUNT(*) Count rows per group
,2
Column data type definitions are part of the DML of a table. --
CORRECT ANSWER--true
-DML is a Data Manipulation Language, it's used to build SQL
queries to manipulate (select, insert, update, delete etc.) data in the
database.
-use MySQL data types appropriate for each column based on type of
data to be stored
When creating a new table, identify the column property checkboxes
selected to create an autoincrementing primary key column. --
CORRECT ANSWER--PK, NN, AI
The PAINTER_ID column of the PAINTER table is a natural key. --
CORRECT ANSWER--FALSE
-Natural key: a key composed of attributes that exist in the real world
(e.g. US Social Security Number
-surrogate key in SQL Server is created a by assigning an identity
property to a column that has a number data type.
, 3
Identify a problem with the PAINTER table --CORRECT ANSWER-
-At least one property should be non-null
Identify the correct description of PAINTER_PAINTER_ID of the
PAINTING table. --CORRECT ANSWER--A PAINTING must have
a PAINTER.
Identify the type of relationship between PAINTER and PAINTING.
--CORRECT ANSWER--1:M
A relational database stores both data and information --CORRECT
ANSWER--true
-Data are the values kept in the database
-Information is processed data
A relational database table stores entities in each column. --
CORRECT ANSWER--false
-The columns in each table stores individual data elements (e.g. name,
ID), each data element represents an entity property
CIT 381 FINAL EXAM QUESTIONS WITH
ANSWERS TESTED AND APPROVED BEST
QUALITY EXAM
Relational database tables inherently include row ordering. --
CORRECT ANSWER--false
-Order is not an inherent property of a set of data
the term associated with the absence of data in a column. --
CORRECT ANSWER--NULL
-Absence of any data value that could represent
Identify the keyword to effectively filter query results --CORRECT
ANSWER--WHERE
-used to filter by individual columns and expressions for rows
Identify the number of rows returned from the following query.
SELECT COUNT(*) FROM actors --CORRECT ANSWER--
However many rows are in the actors table
-COUNT(*) Count rows per group
,2
Column data type definitions are part of the DML of a table. --
CORRECT ANSWER--true
-DML is a Data Manipulation Language, it's used to build SQL
queries to manipulate (select, insert, update, delete etc.) data in the
database.
-use MySQL data types appropriate for each column based on type of
data to be stored
When creating a new table, identify the column property checkboxes
selected to create an autoincrementing primary key column. --
CORRECT ANSWER--PK, NN, AI
The PAINTER_ID column of the PAINTER table is a natural key. --
CORRECT ANSWER--FALSE
-Natural key: a key composed of attributes that exist in the real world
(e.g. US Social Security Number
-surrogate key in SQL Server is created a by assigning an identity
property to a column that has a number data type.
, 3
Identify a problem with the PAINTER table --CORRECT ANSWER-
-At least one property should be non-null
Identify the correct description of PAINTER_PAINTER_ID of the
PAINTING table. --CORRECT ANSWER--A PAINTING must have
a PAINTER.
Identify the type of relationship between PAINTER and PAINTING.
--CORRECT ANSWER--1:M
A relational database stores both data and information --CORRECT
ANSWER--true
-Data are the values kept in the database
-Information is processed data
A relational database table stores entities in each column. --
CORRECT ANSWER--false
-The columns in each table stores individual data elements (e.g. name,
ID), each data element represents an entity property
