Exam (elaborations)
DBMS EXAM 1 (CHAPTERS 1 - 4) | 167 QUESTIONS | WITH ACTUAL ANSWERS!!
- Course
- Institution
DBMS EXAM 1 (CHAPTERS 1 - 4) | 167 QUESTIONS | WITH ACTUAL ANSWERS!!
[Show more]
Content preview
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller EvaTee. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $22.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
82871 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now