Databases

Question 1

What is a database?

Answer 1

Structured, persistent collection of related data

Question 2

What data format is String?

Answer 2

Any combination of characters

Question 3

What data format is Character?

Answer 3

A single character

Question 4

What data format is integer?

Answer 4

Any whole number

Question 5

What data format are real numbers?

Answer 5

Any numeric data with a decimal point

Question 6

What data format is Boolean?

Answer 6

True or False, 1 or 0

Question 7

What data format is Date/Time?

Answer 7

A data type that stores dates and/or time

Question 8

What is entity in database?

Answer 8

Something that we store data about

Question 9

What is fields in database?

Answer 9

The Attributes of a record, tables on the top

Question 10

What is record in database?

Answer 10

A row of information about an entity

Question 11

What is primary key in database?

Answer 11

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

Question 12

What does SQL stand for and what does it do?

Answer 12

Structured Query Language, manipulates a databse.

Question 13

What will this query do? SELECT * FROM ExampleTable

Answer 13

It will return all complete records from that table

Question 14

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

Answer 14

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

Question 15

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

Answer 15

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.

Question 16

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

Answer 16

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.

Question 17

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

Answer 17

SELECT COUNT(movieID) FROM IMDBTop20;

Question 18

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

Answer 18

SELECT SUM(Budget) FROM IMDBTop20;

Question 19

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

Answer 19

SELECT AVG(Budget) FROM IMDBTop20