Brainscape's Knowledge GenomeTM

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


See full index

IT F+ > WEEK 7 > Flashcards

WEEK 7 Flashcards

1
Q

What is a structured collection of organized data that is managed in a way that allows efficient retrieval , modification and analysis information

A

Database

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

A data base is like a what

A

Paper filler cabinet
(Can choose what and where info is stored)

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

How do you get data records on database

A

Input them yourself
Import them from somewhere else

(It’s like Placing documents in filling cabinet)

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

What is a question on request for info from a database and is the way to retrieve data in the database

A

Query
(Can ask it any question)

(Example.
Who has the most money according to the files in the cabinet?)

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

What is a summary of queried data that is designed to provide a clear, concise, and structured view of data

A

Report
(Presentation of your data)

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

Flat File vs Database
What’s the difference

A

Flat File is when a small group of people manage data in text files and spread sheets

Database is when you are dealing with complex data and lots of it which require advance data relationships and query capabilities

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

Database benefits

A

Multiple Concurrent Users

Scalability
(Increase data and traffic(

Increased speed
(Indexing, caching, query optimization etc..)

Can handle a variety of data

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

What is a collection of related data fields that represent a single unit of info
It’s often used to store and retrieve specific info

A

Database Records

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

Long term retention of data within a database even when system is not being used or is off

A

Data Persistence

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

Name the 3 Database Structure Types

A

Structured (well organized)

Unstructured (includes text, vids, audio)

Semi-Structured (use meta tags to organize)

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

Structured data pros and cons

A

Fast data retrieval

Low data flexibility

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

Unstructured data pros and cons

A

Low data retrieval

High data flexibility

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

Semi-structured data pros and cons

A

Medium data retrieval

Medium data flexibility

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

What is a structured data system that stored structured data in tables
(Links multiple tables together)
(Organizes tables that relate to eachother)

A

Relational Database

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

How does Relational Database connect other tables together and create table relationships

A

Keys
(Primary key and Foreign key link together)

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

What is an outline or a blueprint for a database that describes its component and how they work

A

Schema

(Table name
Fields in table
Data type required for table
Primary key, Foreign key, and other attributes)

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

What is a constraint in a database

A

Rules and conditions we set for the data in the database

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

What are Non-Relational Databases

A

Uses storage model to optimize for the specific requirements for data being stored
(NON sql database)
(does NOT use Tables)

19
Q

Explain Key/Value database

A

Its a Non-Relational Databases that uses keys and assigns values to that key
(used for caching
session management
user profile)

20
Q

What is a Document Database

A

Its a Non-Relational Database
Works just like the file system on your computer

(stores stuff that cant be fit into a table or row sheet)

(stores files
music
photos
video)

21
Q

What is SQL

A

is a specialized computer language used to communicate and manipulate databases

(sends request for actions it wants to be preformed)

22
Q

In SQL what are DDL Commands

A

Commands that manage the STRUCTURE of your database

23
Q

In SQL what are DML Commands

A

Commands that manage the DATA of your database

24
Q

What does the CREATE command do in SQL

A

can create the tables and the names of the tables ect…

25
Q

What does the ALTER command do in SQL

Example
CREATE TABLE employees (
emp_id INT,
emp_name VARCHAR(50)
emp_salary DECIMAL(10,2)
);

A

It allows you to add delete and modify a column
You can also change a columns data type

Example
ALTER TABLE employees
REMANE COLUMN emp_id to emp_number;

26
Q

In SQL what does the DROP command do

A

It is used to delete database data like tables

Example
DROP TABLE employees;

27
Q

What are some commands that DDL uses

A

CREATE
ALTER
DROP

28
Q

What are some commands that DML uses

A

INSERT
UPDATE
DELETE

29
Q

In SQL what does the INSERT command do

A

Used to add new records in a table

Example
INSERT INTO employees
VALUES
(4233, ‘John Smith’, 65000.00);

30
Q

In SQL what does the UPDATE command do

A

Allows to modify existing records in a table

Example
UPDATE employees
SET emp_salary = 67000.00
WHERE emp_id = 4233;

31
Q

In SQL what does the DELETE command do

A

Used to delete records in a table

Example
DELETE FROM employees
WHERE emp_id = 4693;

32
Q

In SQL What does the SELECT command do

A

It is used to query/retreat specific data from a database table

Example
SELECT column1, column2
FROM table_name
WHERE condition;

Example 2
SELECT * FROM Student Table
WHERE Age >=20;

33
Q

What are Database Permissions

A

Can grant certain users the ability to preform specific actions like reading and editing data

34
Q

What commands are used for Database Permissions

A

GRANT COMMAND gives permissions
(GRANT SELECT ON Customers TO UserA; )

DENY COMMAND denies permissions
(DENY DELETE ON Customers TO UserA; )

35
Q

When wanting to get data into a database its what

A

Import

36
Q

When wanting to get data out of a database its

A

Export

37
Q

What are some ways to import data into a database

A

Using CSV files
(uses commas to separate files)
(included headers)

38
Q

What is Database Access Methods

A

Are the processes by which a user might run SQL commands in order to update or extract info from a database

39
Q

Name some Database Access Methods

A

Direct/Manual Access
Query/Report Builders
Programmatic Access
User Interface/Utility Access

40
Q

What is Direct/Manual Access

A

Logging into the database directly and running the SQL code within the database management system

41
Q

What is Query/Report Builders

A

The user uses a Graphical User Interface where actions are selected and then converted into SQL commands

42
Q

What is Programmatic Access

A

Use programing language to connect with the database and execute Querys

43
Q

What is User Interface/Utility Access

A

User Friendly Interface
(without the user being aware of its presence )
Data Driven Dashboard

IT F+ (8 decks)

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