Save
Upgrade to remove ads
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account. Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how

T+ Lesson 9

QuestionAnswer
Backend The part of the database system that manages the physical store and organization of data on disk or in memory.
Backup A copy of a database made directly from the original location and saved to a backup medium. Also called a physical backup.
Cold backup A backup made while the DBMS is shut down.
Composite key Two fields that together define a unique condition for each record, similar to how a primary key does.
Data definition Creating, modifying, or deleting the structure of a database.
Database A collection of data that can be analyzed to gather information.
Database dump A text file containing a set of SQL commands that must be run on an SQL server to recreate the database’s tables and schema and then repopulate them with the data they contained.
DBMS (Database Management System) Software that facilitates the creation and management of a database.
Direct/manual access Working with a database using SQL commands.
Field A single column in a database table, representing a single characteristic.
Flat file database A database consisting of a single table.
Foreign key The non-primary-key field in a relationship between two tables.
Form A database object designed to make data entry and lookup user friendly by simulating a paper form.
Frontend The application that provides the user’s interface to a database.
Manipulating data Changing the data in a database.
Non-relational database A database that doesn’t require data to be in a structured format; also called a document database.
Normalization The process of applying rules to database structures to maximize efficiency and minimize entry errors.
Object-oriented database A digital storage area where you can organize information in the way you see and understand things in the real world.
Primary key The field that uniquely identifies each record in a relational database.
Programmatic access Working with a database using a programming language.
Query A view of data from one or more tables; also called a view.
Query/report builder An application or command set that assists users in building queries or reports.
Record A row in a database table, representing a single instance; also called a tuple.
Referential integrity Constraints that keep a database free from errors when changes and deletions are made.
Relational database A database that contains multiple tables that are related to one another via common fields.
Report A database object that provides a view of the data from one or more tables in a format suitable for printing.
Schema The structure of a database, including the structure of each table and how the tables are related to one another.
SQL (Structured Query Language) The common language for issuing commands to relational database systems.
Structured data Data that can be neatly expressed within a framework such as a row-and-column layout of a table.
Table A grid of rows and columns for holding database data; also called a relation. The rows are records and the columns are fields.
Unstructured data Data that cannot easily fit into a consistent structure such as a table.
User interface/utility access Working with a database using an application’s user interface.
Created by: brvhurt
 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards