Tables and flat files have rows and columns of information., , Scalability means a system can grow when demand does., , Data persistence means data might be stored forever., , A relational database links the information in different tables., , A null value means there is no data., , A logical schema outlines the structure of a database., , Physical schema refers to the actual tables, columns and relationships created in the RDBMS., , A row in a table is called a record., , A column in a table is called a field., , A primary key identifies a record uniquely., , Constraints set limitations to prevent problems with a database., , Queries are questions a database can answer., , Non-structured data like pictures and documents don't fit into a database., , Metadata is an example of semi-structured data., , Two types of databases are document and key/value., , Different types of access are manual, direct, programmatic, user interface and utility., , Global or server permissions are usually only for an administrator account., , Permissions can be granted, denied or revoked., , The drop command deletes database objects., , A database dump is a one-time backup of a database that exports the schema, tables, views with the data., .
0%
Understanding Databases (7.1)
Share
Share
Share
by
Jacaceres
I-edit ang Content
I-Print kini
Embed
Uban pa
Assignments
Leaderboard
Show more
Show less
Kini nga leaderboard naka-pribado. Pag-klik sa
Share
aron himuon kini nga publiko.
Kini nga leaderboard gi-disable sa tag-iya sa resource.
Kini nga leaderboard gi-disable tungod ang imong mga kapilian lahi ra sa tag-iya sa resource.
I-revert ang mga Kapilian
Ang
Unjumble
usa ka open-ended nga template. Dili kini makamugna ug mga marka sa leaderboard.
Kinahanglan mag log in
Visual style
Fonts
Subscription required
Mga Option
I-switch ang template
Ipakita tanan
Daghang mga format ang mugawas samtang gidula nimo ang activity.
)
Open results
Copy link
QR code
Mag-delete
I-restore ang gi-autosave:
?
