Brainscape's Knowledge GenomeTM

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


See full index

Quarterly exam (Grade 10) > COMPUTER > Flashcards

COMPUTER Flashcards

PASSSSSSSSSSSSSSSSSSSSS

1
Q

Is a type of database that stores data in separate tables rather than putting all the data in one big storeroom

A

Relational Database

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

Is a popular open source relational database management system that is developed, distributed, and supported by MySQLAB

A

MySQL

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

MySQL DATA TYPES (3)

A

String, Numeric, Date and time

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

fixed length string

A

char

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

MySQL SRING DATA TYPES (3)

A

Char, Varchar, Enum

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

not fixed length string

A

varchar

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

is used when we want to restrict the values to a set of allowed values

A

ENUM

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

MySQL NUMERIC DATA TYPE (4)

A

Integer, Float, Decimal, Boolean

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

used to store whole numbersor numbers without decimals

A

Integer

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

used to store numbers that have a decimal part such as salary and price

A

FLOAT and DECIMAL

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

used if the field can have only two possible values: true or false

A

BOOLEAN

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

MySQL DATE AND TIME DATATYPES

A

Date, datetime, timestamp, time, year

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

YYYY-MM-DD

A

DATE

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

HH:MM:SS

A

Timestamp

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

YYYY-MM-DD HH:MM:SS

A

Datetime

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

RDBMS

A

Relational Database Management System

15
Q

an organized collection of logically related data

A

Database

16
Q

A data base is composed of ___

A

tables

16
Q

each table is composed of ___

A

records

17
Q

each record is composed of ___

A

fields

18
Q

corresponds to a row in a table

A

record

18
Q

each field is composed of ___

A

characters or bytes

18
Q

corresponds to a column name in a table

A

field

19
Q

contains related records, it has rows and columns

A

table

20
Q

corresponds to a cell in a table

A

field value

21
Q

DBMS

A

Database Management System

22
Q

is a software program that can manage program that is in electronic format

A

Database Management System

Quarterly exam (Grade 10) (7 decks)

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