Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

DBMS > Introduction to Databases > Flashcards

Introduction to Databases Flashcards

1
Q

What do DBMS comprise of

A
  1. Collection of interrelated data
  2. A set of programs to access the data
  3. An environment convenient and efficient
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are the drawbacks of filesystems over Databases?

A
  1. Data redundancy and inconsistency
  2. Difficult to access
  3. Data Isolation
  4. Integrity problems
  5. Atomicity of Updates
  6. Concurrent Access
  7. Security
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What does data integrity mean?

A

Data integrity refers to the accuracy, consistency, and reliability of data throughout its entire lifecycle. It ensures that data remains unchanged during storage, transmission, or processing and that it is reliable for use. Maintaining data integrity is crucial in various fields, including databases, information systems, and data storage.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is data inconsistency?

A

Data inconsistency refers to a situation in which the same piece of data is stored in multiple locations or instances within a system, and these copies of the data become out of sync or contradictory. Inconsistencies can arise from various factors, such as software bugs, human errors, system failures, or issues with data synchronization

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What are the benefits of Electronic Record Keeping as against Physical Record Keeping?

A
  • Durability
  • Scalability
  • Security
  • Retrieval
  • Ease of Use
  • Consistency
  • Efficiency
  • Cost
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Where does a File System perform better than a DBMS?

A
  1. File Handling
  2. Initial Setup
  3. Arithmetic and logical operations support
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is data robustness?

A

Data robustness refers to the ability of a system or dataset to maintain its stability, integrity, and functionality in the face of adverse conditions, errors, or unexpected events. A system with high data robustness can handle disruptions, errors, or changes without experiencing a significant loss of performance or reliability.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What are the levels of abstraction in DBMS?

A
  1. Physical Level
  2. Logical Level
  3. View Level
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is a logical schema?

A

the overall logical structure of the database analogous to “type” information of a variable in a program

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is an instance of a database?

A

The actual content of the database at a particular point in time, is analogous to the value of a variable.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is Physical Data Independence?

A

Physical Data Independence is the ability to modify the physical schema without
changing the logical schema

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What are the types of Data Models?

A
  1. Relational Model (RDBMS)
  2. Object-Oriented Model
  3. Network Model
  4. Hierarchical Model
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

How are data stored in the Relational Model?

A

Data is stored as tables in Relational Model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is a Data Dictionary?

A

The data dictionary contains metadata (that is, data about data)
◦ Database schema
◦ Integrity constraints - Primary key (ID uniquely identifies instructors)
◦ Authorization

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is Data Definition Language (DDL)?

A

Specification notation for defining the database schema. DDL compiler generates a set of table templates stored in a data dictionary

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is Data Manipulation Language (DML)?

A

Language for accessing and manipulating the data organized by the appropriate data
model. DML is also known as Query Language.

17
Q

What are the two classes of languages of DML?

A

◦ Pure – used for proving properties about computational power and for optimization
. Relational Algebra (we focus in this course)
. Tuple relational calculus
. Domain relational calculus
◦ Commercial – used in commercial systems
. SQL is the most widely used commercial language

18
Q

What are the parts of a Database Engine?

A
  • Storage manager
  • Query processing
  • Transaction manager
19
Q

What is the function of the “storage manager” of a database engine?

A
  • Storage manager is a program module that provides the interface between the
    low-level data stored in the database and the application programs and queries
    submitted to the system
  • The storage manager is responsible for the following tasks:
    ◦ Interaction with the OS file manager
    ◦ Efficient storing, retrieving, and updating of data
  • Issues:
    ◦ Storage Access
    ◦ File organization
    ◦ Indexing and hashing
20
Q

What is the function of the “Query Processor” of a database engine?

A

a) Parsing and translation
b) Optimization
c) Evaluation

  • Alternative ways of evaluating a given query
    ◦ Equivalent expressions
    ◦ Different algorithms for each operation
  • The cost difference between a good and a bad way of evaluating a query can be enormous
  • Need to estimate the cost of operations
    ◦ Depends critically on statistical information about relations which the database
    must maintain
    ◦ Need to estimate statistics for intermediate results to compute the cost of complex
    expressions
21
Q

What is the function of the “Transaction Management” of a database engine?

A

A transaction is a collection of operations that performs a single logical function in a
database application

Transaction-management component ensures that the database remains in a
consistent (correct) state despite system failures (e.g., power failures and operating
system crashes) and transaction failures.
* Concurrency-control manager controls the interaction among the concurrent
transactions, to ensure the consistency of the database.

22
Q

What are the different types of Database Architecture?

A
  • Centralized
  • Client-server
  • Parallel (multi-processor)
  • Distributed
  • Cloud
23
Q

Types of Database Users

A
  1. Naive Users
  2. Application Users
  3. Sophisticated Users (analysts)
  4. Database Administrators
24
Q

What are the main components of a database?

A
  1. Hardware
  2. Software
  3. Users
  4. Data Models
  5. Stored Procedures and Triggers
  6. Security and Access Control

DBMS (12 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions