DBMS EXAM 1
(CHAPTERS 1 - 4) | 167
QUESTIONS | WITH
ACTUAL ANSWERS!!
DBMS
Evatee 10/23/24 DBMS
,DBMS EXAM 1 (CHAPTERS 1 - 4) | 167
QUESTIONS | WITH ACTUAL ANSWERS!!
SQL (What does it stand for? What is it?) Answer - Structured Query Language
(SQL), a database processing language, to query database data
The Internet (origin info) Answer - the global computer network of networks—
was created as the ARPANET in 1969 and then grew and was used to connect
all the LANs (and other types of networks).
data Answer - recorded facts and numbers.
POS system Answer - Businesses use point of sale (POS) systems to record
every purchase in a database, to monitor inventory, and, if you have a sales
promotion card from the store (the one you use to get those special prices for
"card holders only"), to keep track of everything you buy for marketing
purposes. All the data POS systems gather is stored in, of course, a database.
client-server architecture Answer - A network design in which client computers
use a centrally administered server to share data, data storage space, and
devices.
USERS use DIVICES on which they have CLIENT applications to access SERVICES.
These services are processed by SERVERS, which hold the DATABASES with the
data needed (for the client apps).
, relational database Answer - A database that represents data as a collection of
tables in which all data relationships are represented by common values in
related tables
a table Answer - An arrangement of data made up of horizontal rows and
vertical columns.
row (def and alternative name) Answer - Each row of a table has data about a
particular occurrence, or instance of the thing of interest
also called records
columns (def and alternative name) Answer - Each column of a table stores a
characteristic common to all rows
Columns are also known as fields
Each row in a table is uniquely identified by a ______ Answer - primary key
what is used to create the relationships between the tables in databases?
Answer - the value of primary keys
surrogate key Answer - A system-assigned primary key, generally numeric and
auto-incremented.
If the numbers used in primary key columns such as StudentNumber and
ClassNumber are automatically generated and assigned in the database itself
(CHAPTERS 1 - 4) | 167
QUESTIONS | WITH
ACTUAL ANSWERS!!
DBMS
Evatee 10/23/24 DBMS
,DBMS EXAM 1 (CHAPTERS 1 - 4) | 167
QUESTIONS | WITH ACTUAL ANSWERS!!
SQL (What does it stand for? What is it?) Answer - Structured Query Language
(SQL), a database processing language, to query database data
The Internet (origin info) Answer - the global computer network of networks—
was created as the ARPANET in 1969 and then grew and was used to connect
all the LANs (and other types of networks).
data Answer - recorded facts and numbers.
POS system Answer - Businesses use point of sale (POS) systems to record
every purchase in a database, to monitor inventory, and, if you have a sales
promotion card from the store (the one you use to get those special prices for
"card holders only"), to keep track of everything you buy for marketing
purposes. All the data POS systems gather is stored in, of course, a database.
client-server architecture Answer - A network design in which client computers
use a centrally administered server to share data, data storage space, and
devices.
USERS use DIVICES on which they have CLIENT applications to access SERVICES.
These services are processed by SERVERS, which hold the DATABASES with the
data needed (for the client apps).
, relational database Answer - A database that represents data as a collection of
tables in which all data relationships are represented by common values in
related tables
a table Answer - An arrangement of data made up of horizontal rows and
vertical columns.
row (def and alternative name) Answer - Each row of a table has data about a
particular occurrence, or instance of the thing of interest
also called records
columns (def and alternative name) Answer - Each column of a table stores a
characteristic common to all rows
Columns are also known as fields
Each row in a table is uniquely identified by a ______ Answer - primary key
what is used to create the relationships between the tables in databases?
Answer - the value of primary keys
surrogate key Answer - A system-assigned primary key, generally numeric and
auto-incremented.
If the numbers used in primary key columns such as StudentNumber and
ClassNumber are automatically generated and assigned in the database itself
