COSC 122 Midterm Exam with all Correct & 100% Verified
Answers |Latest Version |Already Graded A+
spreadsheet ✔Correct Answer-organizes information into a two-dimensional array of cels (a
table)
cell ✔Correct Answer-has two components (an address (specified given a row and column
number) & a location (that can store a number, text, or formula)), a cell is identified by a row
number and a column number
filling ✔Correct Answer-combines copy and paste
spreadsheet formula ✔Correct Answer-any expression that begins with an equal sign ("="),
example: =SUM(A1:A5)
aggregate formula ✔Correct Answer-computes a summary function over a range of cells. the
values can either be literals or cell locations (ex. MIN, MAX, SUM, etc.)
chart ✔Correct Answer-graphical representation of spreadsheet data
conditional formatting ✔Correct Answer-an Excel feature that enables you to specify how
cells that meet one or more given conditions should be displayed (allows you to change the cell
format based on data values, available under Styles)
filter ✔Correct Answer-shows a subset of the rows in the spreadsheet by only showing rows
that pass a given condition (test)
database ✔Correct Answer-a collection of logically related data for a particular domain
database management system (DBMS) ✔Correct Answer-software designed for the creating
and management of databases (efficient, convenient, safe, massive, persistent, multi-user)
data abstraction ✔Correct Answer-allows the implementation of an object to change without
affecting programs that use the object through an external definition
relational model ✔Correct Answer-organizes the database information into tables called
relations
relation ✔Correct Answer-A table with columns and rows
attribute ✔Correct Answer-named column of a relation
, tuple ✔Correct Answer-a row of a relation
domain ✔Correct Answer-set of allowable values for one or more attributes
degree ✔Correct Answer-a relation is the number of attributes it contains
cardinality ✔Correct Answer-the number of tuples it contains
key ✔Correct Answer-a minimal set of attributes that uniquely identifies a tuple in a relation,
uniquely identifies a tuple in a relation
superkey ✔Correct Answer-set of attributes that uniquely identifies a tuple in a relation
keyword search ✔Correct Answer-allows a user to type keywords or phrases and returns a
best answer estimate
structured query language ✔Correct Answer-a standard database query language to retrieve
exact answers, SQL is a declarative language: specifies what to retrieve but not how to retrieve
it
SQL queries ✔Correct Answer-a query in SQL has the form SELECT (list of attributes), FROM
(list of tables), WHERE (filter conditions)
projection operation ✔Correct Answer-creates a new table that has some of the columns of
the input table. in SQL, provide the able in the FROM clause and the fields in the output in the
select
selection operation ✔Correct Answer-creates a new table with some of the rows of the input
table, a condition specifies which rows are in the new table (the condition is similar to an if
statement)
comparison operators ✔Correct Answer-Symbols used in search criteria. (>, <, =, >=, <=, <>)
logical operators ✔Correct Answer-AND, OR, NOT
join ✔Correct Answer-combines two tables into a single table
cartesian product ✔Correct Answer-if a join has no condition that specifies which rows are in
the result, all possible combinations of rows are in the result
equijoin ✔Correct Answer-most common type of join, combines two tables by matching
columns that have the same value
Answers |Latest Version |Already Graded A+
spreadsheet ✔Correct Answer-organizes information into a two-dimensional array of cels (a
table)
cell ✔Correct Answer-has two components (an address (specified given a row and column
number) & a location (that can store a number, text, or formula)), a cell is identified by a row
number and a column number
filling ✔Correct Answer-combines copy and paste
spreadsheet formula ✔Correct Answer-any expression that begins with an equal sign ("="),
example: =SUM(A1:A5)
aggregate formula ✔Correct Answer-computes a summary function over a range of cells. the
values can either be literals or cell locations (ex. MIN, MAX, SUM, etc.)
chart ✔Correct Answer-graphical representation of spreadsheet data
conditional formatting ✔Correct Answer-an Excel feature that enables you to specify how
cells that meet one or more given conditions should be displayed (allows you to change the cell
format based on data values, available under Styles)
filter ✔Correct Answer-shows a subset of the rows in the spreadsheet by only showing rows
that pass a given condition (test)
database ✔Correct Answer-a collection of logically related data for a particular domain
database management system (DBMS) ✔Correct Answer-software designed for the creating
and management of databases (efficient, convenient, safe, massive, persistent, multi-user)
data abstraction ✔Correct Answer-allows the implementation of an object to change without
affecting programs that use the object through an external definition
relational model ✔Correct Answer-organizes the database information into tables called
relations
relation ✔Correct Answer-A table with columns and rows
attribute ✔Correct Answer-named column of a relation
, tuple ✔Correct Answer-a row of a relation
domain ✔Correct Answer-set of allowable values for one or more attributes
degree ✔Correct Answer-a relation is the number of attributes it contains
cardinality ✔Correct Answer-the number of tuples it contains
key ✔Correct Answer-a minimal set of attributes that uniquely identifies a tuple in a relation,
uniquely identifies a tuple in a relation
superkey ✔Correct Answer-set of attributes that uniquely identifies a tuple in a relation
keyword search ✔Correct Answer-allows a user to type keywords or phrases and returns a
best answer estimate
structured query language ✔Correct Answer-a standard database query language to retrieve
exact answers, SQL is a declarative language: specifies what to retrieve but not how to retrieve
it
SQL queries ✔Correct Answer-a query in SQL has the form SELECT (list of attributes), FROM
(list of tables), WHERE (filter conditions)
projection operation ✔Correct Answer-creates a new table that has some of the columns of
the input table. in SQL, provide the able in the FROM clause and the fields in the output in the
select
selection operation ✔Correct Answer-creates a new table with some of the rows of the input
table, a condition specifies which rows are in the new table (the condition is similar to an if
statement)
comparison operators ✔Correct Answer-Symbols used in search criteria. (>, <, =, >=, <=, <>)
logical operators ✔Correct Answer-AND, OR, NOT
join ✔Correct Answer-combines two tables into a single table
cartesian product ✔Correct Answer-if a join has no condition that specifies which rows are in
the result, all possible combinations of rows are in the result
equijoin ✔Correct Answer-most common type of join, combines two tables by matching
columns that have the same value
