Brainscape's Knowledge GenomeTM

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


See full index

computer science > databases > Flashcards

databases Flashcards

You may prefer our related Brainscape-certified flashcards:
Biology 101 flashcards
1
Q

What is a database?

A

A collection of tables of data

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

What is the software that databases use?

A

Database management system

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

What are the 2 types of databases?

A

Relational
Non relational

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

What is a relational database?

A

A database where data is stored in a tabular format
(Tables)

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

What is a non relational database?💿

A

It is a database where data is stored in key value pairs

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

What is SQL used for?

A

Structured Query Language used For manipulating and storing data in databases

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

What are the 5 functions of SQL?

A

Create
Select
Insert into
Delete
Update

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

What is input sanitisation?

A

It clears the inputted data of unwanted characters to avoid malicious code such as speech marks, brackets, commas

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

What is input validation?

A

It checks the inputted data fits the criteria so that it is in an accepted format.

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

What is a record?

A

A record is collection of data within a table related to a topic

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

What is a field?

A

A field is a set of values arranged in a table that has the same data type

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

What is maintainability?

A

Ensures that your code is eas to understand, read, modify and reuse to prevent bugs and errors so your code runs smoothly

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

What are methods of maintaining code?

A

Indentation
Formatting
Commenting
Subprograms
Naming conventions

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

What are naming conventions?

A

It is when you give variables appropriate names so the code is easier to understand and you use no gaps and only lowercase letters and use underscores
(The set of rules that are followed in order to make an appropriate/good variable name)

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

What is formatting?

A

Formatting is the structure of the code or the way its presented

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

What is indentation?

A

Shows which line of code is part of a sequence or iteration for example if a print statement is inside a for loop

17
Q

What is defense design?

A

Its important because it ensures the code still works no matter what the user does and prevents bugs and also makes sure its easier to read

18
Q

What is authentication?

A

Its a process which checks that the user is who they say they are for example: using username and password

18
Q

What is a syntax error?

A

An error which happens when the code doesnt follow the rules of the programming language

19
Q

What is a logical error?

A

A logical error is when the code will execute but will produce unexpected results

20
Q

What are the 2 types of testing?

A

Iterative
Terminal

21
Q

What is iterative testing?

A

It is when you run the code while the program is still being developed

22
Q

What is terminal testing?

A

It is when you run the code after the program has fully been developed

23
Q

Why is testing important?

A

Helps identify bugs and errors early which reduces flaws in the code

24
Q

What is a runtime error?

A

An error that occurs while the program is running after being successfully compiled

25
Q

What is the “where” clause used for?

A

To filter records and only show records that meet specific conditions using words such as “AND” “LIKE” and an = sign

26
Q

What is a format check?

A

Ensures the data follows a set pattern

27
Q

What is a length check?

A

Ensures that the number of characters meets expectations

28
Q

What is a type check?

A

Ensures the data entered is of an expected type

29
Q

What is a range check?

A

Ensures the data is between an upper and lower acceptable value within a certain rangeq

30
Q

What is a presence check?

A

Ensures that the user has at least entered something into the field

31
Q

What is blackbox testing?

A

examines the functionality of an application without peering into its internal structures or workings.

32
Q

What is whitebox testing?

A

White box testing is a method of testing software that tests internal structures or workings of an application

33
Q

What is erroneous error?

A

data that the program cannot process and should not accept

34
Q

What is a boundary error?

A

valid data that falls at the boundary of any possible ranges, sometimes known as extreme data

35
Q

What is normal data?

A

Normal valid data that the program should accept

computer science (7 decks)

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