SQL Server 2000 - Database Fundamentals Flash Cards

Play Memory | Create Card File | Append to Card File
Title: SQL Server 2000 - Database Fundamentals
Description: Database Fundamentals - what is a database, table, index, query?
Number of Cards: 15
Save Count: 0
Author: budenmeyer11
Created: 2006-10-08
Tags: sql
Private No

Save Count represents the number of people who have saved this card set to their flashcard list. Consider this an endorsement!

    • Question
    • Answer
    • Side 3
    • what is a database?
    • self-describing collection of integrated
      records.
    • What is a record?
    • a representation of a physical or conceptual object
    • What is metadata?
    • Data which describes the structure of the database.
    • Why is a database self-describing?
    • It contains a description of its own structure
    • Why is a database integrated?
    • A database is integrated because it contains data as well as the relationships amond data items.
    • What is a personal database?
    • a database designed for use by a single person or computer
    • What is a departmental or workgroup database>?
    • A database that can handle multiple users trying to access the same data at the same time.
    • What is an enterprise database?
    • These are extremely large databases.
    • What does DBMS stand for?
    • Database Management System
    • What is a DBMS?
    • A set of programs used to define, administer, and process databases.
    • The DBMS _ the physical
      details of the database storage so that the application only has to concern
      itself with the _ _ of the data, not how the data is stored.
    • The DBMS masks the physical
      details of the database storage so that the application only has to concern
      itself with the logical characteristics of the data, not how the data is stored.
    • What is a flat file
    • a collection of data in a specified format which contains minimal metadata
    • The advantage of a flat file system is that it is very _
    • fast
    • What is the disadvantage of a flat file system?
    • The application is responsible for knowing how and where the data is stored. it is impractical for large systems.
    • A DBMS BLANK the need to include data manipulation code.
    • eliminate