Back to marketplace

Databases

No description yet. This curated deck is ready for daily study.

Total cards: 19•Content version: v3•Public deck•Updated: 8/1/2026

Card preview (19)

#1
Front (Question)

What is a database?

Back (Answer)

Structured, persistent collection of related data

#2
Front (Question)

What data format is String?

Back (Answer)

Any combination of characters

#3
Front (Question)

What data format is Character?

Back (Answer)

A single character

#4
Front (Question)

What data format is integer?

Back (Answer)

Any whole number

#5
Front (Question)

What data format are real numbers?

Back (Answer)

Any numeric data with a decimal point

#6
Front (Question)

What data format is Boolean?

Back (Answer)

True or False, 1 or 0

#7
Front (Question)

What data format is Date/Time?

Back (Answer)

A data type that stores dates and/or time

#8
Front (Question)

What is entity in database?

Back (Answer)

Something that we store data about

#9
Front (Question)

What is fields in database?

Back (Answer)

The Attributes of a record, tables on the top

#10
Front (Question)

What is record in database?

Back (Answer)

A row of information about an entity

#11
Front (Question)

What is primary key in database?

Back (Answer)

Unique for each record in the table so there are no duplicate records

#12
Front (Question)

What does SQL stand for and what does it do?

Back (Answer)

Structured Query Language, manipulates a databse.

#13
Front (Question)

What will this query do? SELECT * FROM ExampleTable

Back (Answer)

It will return all complete records from that table

#14
Front (Question)

What will this query do? SELECT * FROM ExampleTable WHERE Name = ‘John’;

Back (Answer)

Return all records from ExampleTable where the field Name is equal to John

#15
Front (Question)

What will this query do? SELECT * FROM ExampleTable WHERE Name = ‘John’ ORDER BY favoriteMovie;

Back (Answer)

Return all records from ExampleTable where the field Name is equal to John and the data will be ordered by the field favoriteMovie in alphabetical order.

#16
Front (Question)

What will this query do? SELECT * FROM ExampleTable WHERE Name = ‘John” ORDER BY favoriteMovie DESC;

Back (Answer)

Return all records from ExampleTable where the field Name is equal to John and the data will be ordered by the field favoriteMovie in descending alphabetical order.

#17
Front (Question)

What query can we use to count how many records exist in a table?

Back (Answer)

SELECT COUNT(movieID) FROM IMDBTop20;

#18
Front (Question)

What query can we use to find the sum of a number of records?

Back (Answer)

SELECT SUM(Budget) FROM IMDBTop20;

#19
Front (Question)

What query can we use to find the average of a number of records?

Back (Answer)

SELECT AVG(Budget) FROM IMDBTop20