Brainscape's Knowledge GenomeTM

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


See full index

CCINFOM Comprehensive > Fundamentals > Flashcards

Fundamentals Flashcards

1
Q

What is a Database

A

A structured collection of data stored in a logical and organized format

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

What is a Database Management System

A

Software acting as the intermediary or middle-man between the users or application and the database

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

It is the key functions of a DBMS

A
  1. Data Definition (using a DDL)
  2. Data Manipulation (using a DML)
  3. Data Querying (using a DQL)
  4. Data Control (using a DCL)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Give the 4 subsets of SQL

A
  1. Database Definition Language (DDL)
  2. Database Manipulation Language (DML)
  3. Database Querying Language (DQL)
  4. Database Control Language (DCL)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is a Database Definition Language (DDL)?

A

Defines, modifies, and manages database schema and structure

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

What is a Database Manipulation Language (DML)?

A

Manipulates data within existing database objects

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

What is a Database Querying Language (DQL)?

A

Performs queries on the data

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

What is a Database Control Language (DCL)?

A

Controls access to data by granting and revoking permissions and rights in the DB

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

The CREATE, ALTER, and DROP commands fall under which subset of SQL

A

DDL

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

The INSERT, UPDATE, and DELETE operations fall under which subset of SQL

A

DML

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

The SELECT command falls under which subset of SQL

A

DQL

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

The GRANT and REVOKE commands fall under which subset of SQL

A

DCL

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

Enumerate the Data Management Cycle

Hint: ICRUDOPS / CRUD PISO

A
  1. Input
  2. Create
  3. Read
  4. Update
  5. Delete
  6. Organize
  7. Processing
  8. Share
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Enumerate the 4 Types of Data Processing

A
  1. Type 1: Form Records
  2. Type 2: Mathematical Processing and Update or Deletion of Records
  3. Type 3: Relating Records
  4. Type 4: Generating Lists, Reports, and Filtering Results
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

This type of data Processing
where it is the process of adding new records

A

Type 1 (Form Records)

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

This type of data processing involves computations like averages and derived values

A

Type 2 (Mathematical processing & update/delete of records)

17
Q

This type of data processing that involves making and using relationships between records in different tables

A

Type 3 (Relating Records)

18
Q

This type of data processing involves extracting and presenting data in meaningful ways

A

Type 4 (Generating Lists, Reports, and filtering results)

CCINFOM Comprehensive (12 decks)

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