CIT 381 Final Actual EXAM
CIT 381 FINAL ACTUAL EXAM NEWEST 2025/2026 WITH
COMPLETE QUESTIONS AND CORRECT ANSWERS |ALREADY
GRADED A+||BRAND NEW VERSION!
When creating a new table, identify the column property checkboxes selected to
create an autoincrementing primary key column. - ANSWER-PK, NN, AI
The PAINTER_ID column of the PAINTER table is a natural key. - 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.
Identify a problem with the PAINTER table - ANSWER-At least one property should
be non-null
Identify the correct description of PAINTER_PAINTER_ID of the PAINTING table. -
ANSWER-A PAINTING must have a PAINTER.
Identify the type of relationship between PAINTER and PAINTING. - ANSWER-1:M
The model includes two primary keys and one foreign key. - ANSWER--Primary
keys must contain UNIQUE values, and cannot contain NULL values. A table can
have only ONE primary key; and in the table, this primary key can consist of single
or multiple columns (fields).
1|Page
, CIT 381 Final Actual EXAM
-A FOREIGN KEY is a field (or collection of fields) in one table that refers to the
PRIMARY KEY in another table.
The table containing the foreign key is called the child table, and the table
containing the candidate key is called the referenced or parent table.
The SQL statement contains a SELECT alias. - ANSWER-true
-Purpose: Display table contents
-General syntax SELECT column(s) FROM table(s)
The SQL statement contains a TABLE alias. - ANSWER-true
-SQL provides the ability to alias a table name, as well as a column name
-Table name aliases will be more useful when we start doing table JOINs
-Table name alias => SELECT ACT.actor_id FROM actor AS ACT
The SQL statement MUST have the terminating semi-colon to successfully execute
- ANSWER-false
The SQL results will be sorted based on the customerName column from A-Z. -
ANSWER-true
-ASC: ascending (smallest to largest)
-DESC:descending (largest to smallest)
The SQL results will ONLY contain cities that end in the letter 'P '. - ANSWER-false
-WHERE CustomerName LIKE 'p%' Finds any values that start with "p"
2|Page
CIT 381 FINAL ACTUAL EXAM NEWEST 2025/2026 WITH
COMPLETE QUESTIONS AND CORRECT ANSWERS |ALREADY
GRADED A+||BRAND NEW VERSION!
When creating a new table, identify the column property checkboxes selected to
create an autoincrementing primary key column. - ANSWER-PK, NN, AI
The PAINTER_ID column of the PAINTER table is a natural key. - 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.
Identify a problem with the PAINTER table - ANSWER-At least one property should
be non-null
Identify the correct description of PAINTER_PAINTER_ID of the PAINTING table. -
ANSWER-A PAINTING must have a PAINTER.
Identify the type of relationship between PAINTER and PAINTING. - ANSWER-1:M
The model includes two primary keys and one foreign key. - ANSWER--Primary
keys must contain UNIQUE values, and cannot contain NULL values. A table can
have only ONE primary key; and in the table, this primary key can consist of single
or multiple columns (fields).
1|Page
, CIT 381 Final Actual EXAM
-A FOREIGN KEY is a field (or collection of fields) in one table that refers to the
PRIMARY KEY in another table.
The table containing the foreign key is called the child table, and the table
containing the candidate key is called the referenced or parent table.
The SQL statement contains a SELECT alias. - ANSWER-true
-Purpose: Display table contents
-General syntax SELECT column(s) FROM table(s)
The SQL statement contains a TABLE alias. - ANSWER-true
-SQL provides the ability to alias a table name, as well as a column name
-Table name aliases will be more useful when we start doing table JOINs
-Table name alias => SELECT ACT.actor_id FROM actor AS ACT
The SQL statement MUST have the terminating semi-colon to successfully execute
- ANSWER-false
The SQL results will be sorted based on the customerName column from A-Z. -
ANSWER-true
-ASC: ascending (smallest to largest)
-DESC:descending (largest to smallest)
The SQL results will ONLY contain cities that end in the letter 'P '. - ANSWER-false
-WHERE CustomerName LIKE 'p%' Finds any values that start with "p"
2|Page
