CIT 111 Final Exam || All Answers Are Correct 100%.
Subquery correct answers A query inside another query. The nested query will execute first.
Index correct answers A data structure that provides a way to retrieve data more quickly from a
table based on values in a specific column.
View correct answers A virtual table based on results from a query from one or more base tables.
The bits and pieces, like numbers, characters or symbols with no relevance. correct answers Data
A set of data with relevance. At a certain place in time, or for a certain person the data makes
sense correct answers Information
Information that has been acquired and gives understanding about the importance of the
information. Used to make decisions. correct answers Knowledge
Acting on the knowledge obtained to achieve some benefit. correct answers Decision-making
A person, place, thing or concept about which data can be collected. correct answers Entity
Describes the facts, details or characteristics of an entity correct answers Attribute
Using data as the basis for making decisions in an organization to avoid bias and false
assumptions that lead to poor decisions. correct answers Data-driven Decision Making
A request for data or information. Asking a question from the data correct answers Query
Arrange data or information in a specific way to make it more useful. Such as alphabetizing from
a to z. correct answers Sort
Hiding or filtering out unwanted data or information so only the information you want to see is
displayed. correct answers Filter
A document used to plan a successful execution of a project or system. Used in planning for data
systems such as databases. correct answers Statement of Work (SOW)
Ensuring the accuracy and reliability of data, making sure it remains intact. It can be maintained
by standards implemented during the design phase. correct answers Data Integrity
The usability of data, or having only valid data written to the database. All values in a single
attribute of an entity, should be of the same data type. correct answers Data Consistency
The repetition of data where the same data value is stored in more than one place in the database.
This wastes space and necessitates multiple changes in different places when editing the value.
correct answers Data Redundancy
, A single thing, person, place, or object; usually represented as a single row in data storage. Also
referred to as a record. correct answers Entity Data Storage
A value that describes a characteristics of the entity. A set of these related values for many
entities are represented as a column in data storage. Also referred to as a field. correct answers
Attribute Data Storage
Datatype correct answers a particular kind of data item, as defined by the values it can take
Data Model correct answers determines the logical structure of a database and determines in
which manner data can be stored, organized and manipulated
Hierarchical Model correct answers Organizes data in a tree-like structure with parents and child
nodes. Each child node will only have one parent node, parents can have many child nodes
Network Model correct answers an extension of the hierarchical database model. With the
network model, child nodes can have more than one parent, allowing more flexibility.
Relational Model correct answers The most common model that organizes data in rows and
tables, which in turn can be accessed and linked to other rows and tables by sharing a common
field.
Object-oriented Model correct answers represents data as an object with properties and methods
and combines database capabilities with object-oriented programming language capabilities.
NoSQL correct answers an unstructured database model that can store virtually any structure
where new columns can be created easily
Edgar F. Codd correct answers A computer scientist who invented the relational model for
database management, the theoretical basis for relational databases and relational database
management systems
SQL correct answers Structured Query Language, the language to communicate with a database
MySQL correct answers the most popular open-source relational database management system
MySQL Workbench correct answers a visual tool for database providing data modeling, SQL
development, administration tools, user administration, and backups
Table correct answers a part of a database that represents one real world entity or one group of
related instances of that entity. Each row of a table is one instance of the entity. Each column an
attribute of that entity.
Primary Key correct answers An attribute (or group of attributes) that uniquely identifies a given
entity in a table
Subquery correct answers A query inside another query. The nested query will execute first.
Index correct answers A data structure that provides a way to retrieve data more quickly from a
table based on values in a specific column.
View correct answers A virtual table based on results from a query from one or more base tables.
The bits and pieces, like numbers, characters or symbols with no relevance. correct answers Data
A set of data with relevance. At a certain place in time, or for a certain person the data makes
sense correct answers Information
Information that has been acquired and gives understanding about the importance of the
information. Used to make decisions. correct answers Knowledge
Acting on the knowledge obtained to achieve some benefit. correct answers Decision-making
A person, place, thing or concept about which data can be collected. correct answers Entity
Describes the facts, details or characteristics of an entity correct answers Attribute
Using data as the basis for making decisions in an organization to avoid bias and false
assumptions that lead to poor decisions. correct answers Data-driven Decision Making
A request for data or information. Asking a question from the data correct answers Query
Arrange data or information in a specific way to make it more useful. Such as alphabetizing from
a to z. correct answers Sort
Hiding or filtering out unwanted data or information so only the information you want to see is
displayed. correct answers Filter
A document used to plan a successful execution of a project or system. Used in planning for data
systems such as databases. correct answers Statement of Work (SOW)
Ensuring the accuracy and reliability of data, making sure it remains intact. It can be maintained
by standards implemented during the design phase. correct answers Data Integrity
The usability of data, or having only valid data written to the database. All values in a single
attribute of an entity, should be of the same data type. correct answers Data Consistency
The repetition of data where the same data value is stored in more than one place in the database.
This wastes space and necessitates multiple changes in different places when editing the value.
correct answers Data Redundancy
, A single thing, person, place, or object; usually represented as a single row in data storage. Also
referred to as a record. correct answers Entity Data Storage
A value that describes a characteristics of the entity. A set of these related values for many
entities are represented as a column in data storage. Also referred to as a field. correct answers
Attribute Data Storage
Datatype correct answers a particular kind of data item, as defined by the values it can take
Data Model correct answers determines the logical structure of a database and determines in
which manner data can be stored, organized and manipulated
Hierarchical Model correct answers Organizes data in a tree-like structure with parents and child
nodes. Each child node will only have one parent node, parents can have many child nodes
Network Model correct answers an extension of the hierarchical database model. With the
network model, child nodes can have more than one parent, allowing more flexibility.
Relational Model correct answers The most common model that organizes data in rows and
tables, which in turn can be accessed and linked to other rows and tables by sharing a common
field.
Object-oriented Model correct answers represents data as an object with properties and methods
and combines database capabilities with object-oriented programming language capabilities.
NoSQL correct answers an unstructured database model that can store virtually any structure
where new columns can be created easily
Edgar F. Codd correct answers A computer scientist who invented the relational model for
database management, the theoretical basis for relational databases and relational database
management systems
SQL correct answers Structured Query Language, the language to communicate with a database
MySQL correct answers the most popular open-source relational database management system
MySQL Workbench correct answers a visual tool for database providing data modeling, SQL
development, administration tools, user administration, and backups
Table correct answers a part of a database that represents one real world entity or one group of
related instances of that entity. Each row of a table is one instance of the entity. Each column an
attribute of that entity.
Primary Key correct answers An attribute (or group of attributes) that uniquely identifies a given
entity in a table
