quiz 1

Question 1

It refers to the collection of related fields.

Answer 1

record

Question 2

It is an organized collection of data

Answer 2

database

Question 3

collection of records.

Answer 3

table

Question 4

single piece of data

Answer 4

field

Question 5

database which uses pen and paper in storing data

Answer 5

manual database

Question 6

a database that is composed of one category of data

Answer 6

simple database

Question 7

database that is composed of two or more categories of data connected by a common field.

Answer 7

relational database

Question 8

database that stores data in a digital media

Answer 8

computerized database

Question 9

used to set distinction between records to ensure all records are unique.

Answer 9

primary key

Question 10

message given by MySQL if no result has been found in a query

Answer 10

empty set

Question 11

display all records

Answer 11

select * from

Question 12

Display all databases

Answer 12

show databases

Question 13

open a database

Answer 13

use

Question 14

display the table structure

Answer 14

describe

Question 15

display all tables in database

Answer 15

show tables

Question 16

make a new table

Answer 16

create table

Question 17

delete a record

Answer 17

delete

Question 18

add a new record

Answer 18

insert into

Question 19

modify a record

Answer 19

update

Question 20

modify the table structure

Answer 20

alter table

Question 21

change the name of a fieldname or column

Answer 21

alter table…change

Question 22

change the data type or width of a fieldname or column

Answer 22

alter table….modify

Question 23

add a new fieldname or column

Answer 23

alter table…add

Question 24

delete a fieldname or column

Answer 24

alter table…drop

Question 25

change the table name

Answer 25

alter table….rename to