Package deal
A Package Deal For Database Systems Exams & practice tests
Chapter 1- Database Systems practice questions with correct answers Database systems Final Exam 2023 with 100% correct answers
[Show more]Chapter 1- Database Systems practice questions with correct answers Database systems Final Exam 2023 with 100% correct answers
[Show more]database 
collection of related data 
 
 
 
DBMS 
software that manages and controls access to a database 
 
 
 
database application 
a program that interacts with the database at some point in its execution 
 
 
 
database system 
a collection of application programs that interact with the databas...
Preview 1 out of 3 pages
Add to cartdatabase 
collection of related data 
 
 
 
DBMS 
software that manages and controls access to a database 
 
 
 
database application 
a program that interacts with the database at some point in its execution 
 
 
 
database system 
a collection of application programs that interact with the databas...
Ch. 1 - Data 
Recorded facts and numbers 
 
 
 
Ch. 1 - Row 
Contains data about a particular instance 
 
 
 
Ch. 1 - Column 
Stores a characteristic common to all rows 
 
 
 
Ch. 1 - Primary Key 
Used to create the relationships between the tables 
 
 
 
Ch. 1 - What is the most commonly used type ...
Preview 1 out of 3 pages
Add to cartCh. 1 - Data 
Recorded facts and numbers 
 
 
 
Ch. 1 - Row 
Contains data about a particular instance 
 
 
 
Ch. 1 - Column 
Stores a characteristic common to all rows 
 
 
 
Ch. 1 - Primary Key 
Used to create the relationships between the tables 
 
 
 
Ch. 1 - What is the most commonly used type ...
SQL 
is a domain-specific programming language designed for managing and communicating with data held in a relational database management system 
 
 
 
SQL is used for: 
-creating databases 
-adding, modifying and deleting database structures 
-inserting, deleting and modifying records in databases ...
Preview 2 out of 12 pages
Add to cartSQL 
is a domain-specific programming language designed for managing and communicating with data held in a relational database management system 
 
 
 
SQL is used for: 
-creating databases 
-adding, modifying and deleting database structures 
-inserting, deleting and modifying records in databases ...
Which of the following is NOT a version of traditional SQL? 
Google Big Table 
 
 
 
Database management systems, such as MySQL, are based on spreadsheet software, such as Microsoft Excel. 
False 
 
 
 
The ___________ relationship should be rare in any relational database design. 
1:1 
 
 
 
Mathem...
Preview 1 out of 3 pages
Add to cartWhich of the following is NOT a version of traditional SQL? 
Google Big Table 
 
 
 
Database management systems, such as MySQL, are based on spreadsheet software, such as Microsoft Excel. 
False 
 
 
 
The ___________ relationship should be rare in any relational database design. 
1:1 
 
 
 
Mathem...
Ad hoc query 
a "spur-of-the-moment" question. 
 
 
 
centralized database 
A database located at a single site. 
 
 
 
data 
Raw facts, that is, facts that have not yet been processed to reveal their meaning to the end user. 
 
 
 
data anomaly 
A data abnormality that exists when inconsistent ch...
Preview 2 out of 5 pages
Add to cartAd hoc query 
a "spur-of-the-moment" question. 
 
 
 
centralized database 
A database located at a single site. 
 
 
 
data 
Raw facts, that is, facts that have not yet been processed to reveal their meaning to the end user. 
 
 
 
data anomaly 
A data abnormality that exists when inconsistent ch...
Ad hoc query 
a "spur-of-the-moment" question. 
 
 
 
centralized database 
A database located at a single site. 
 
 
 
data 
Raw facts, that is, facts that have not yet been processed to reveal their meaning to the end user. 
 
 
 
data anomaly 
A data abnormality that exists when inconsistent ch...
Preview 2 out of 5 pages
Add to cartAd hoc query 
a "spur-of-the-moment" question. 
 
 
 
centralized database 
A database located at a single site. 
 
 
 
data 
Raw facts, that is, facts that have not yet been processed to reveal their meaning to the end user. 
 
 
 
data anomaly 
A data abnormality that exists when inconsistent ch...
Relational Database 
A collection of tables (relations) 
 
 
 
Doman Attribute 
The set of allowed values for each attribute. 
 
 
 
Atomic Attribute 
Values that are indivisible 
 
 
 
Database Schema 
The logical design of the database. 
 
 
 
Database Instance 
A snapshot of the data in the datab...
Preview 1 out of 2 pages
Add to cartRelational Database 
A collection of tables (relations) 
 
 
 
Doman Attribute 
The set of allowed values for each attribute. 
 
 
 
Atomic Attribute 
Values that are indivisible 
 
 
 
Database Schema 
The logical design of the database. 
 
 
 
Database Instance 
A snapshot of the data in the datab...
Relational DB's SQL properties 
-fixed schema, row oriented and optimized 
-rigid 2phase transactions, with locking and bottleneck 
-set theoretic 
-centralized distribution 
-computational, not navigational /interconnected and set-oriented 
-poor support for heterogeneity and compression 
 
 
 
No...
Preview 2 out of 12 pages
Add to cartRelational DB's SQL properties 
-fixed schema, row oriented and optimized 
-rigid 2phase transactions, with locking and bottleneck 
-set theoretic 
-centralized distribution 
-computational, not navigational /interconnected and set-oriented 
-poor support for heterogeneity and compression 
 
 
 
No...
Relational Database 
A collection of tables (relations) 
 
 
 
Doman Attribute 
The set of allowed values for each attribute. 
 
 
 
Atomic Attribute 
Values that are indivisible 
 
 
 
Database Schema 
The logical design of the database. 
 
 
 
Database Instance 
A snapshot of the data in the datab...
Preview 1 out of 2 pages
Add to cartRelational Database 
A collection of tables (relations) 
 
 
 
Doman Attribute 
The set of allowed values for each attribute. 
 
 
 
Atomic Attribute 
Values that are indivisible 
 
 
 
Database Schema 
The logical design of the database. 
 
 
 
Database Instance 
A snapshot of the data in the datab...
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
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!
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
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.
Stuvia is a marketplace, so you are not buying this document from us, but from seller Fordenken. Stuvia facilitates payment to the seller.
No, you only buy these notes for $26.99. You're not tied to anything after your purchase.
4.6 stars on Google & Trustpilot (+1000 reviews)
75057 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now