WorksheetsMTA Databse 1.0
Total questions: 13
Worksheet time: 10mins
Primary Datafiles have this extension
(a)
These speed up searches in a table
(a)
Secondary data files have this extension
(a)
Transaction Log Files have this file extension
(a)
A shopping list would be this type of database
Flat Type
Hierarchial
Relational
This type of database has a parent that can have multiple child tables
Flat
Hierarchial
Relational
This type of table can have child tables with multiple parent tables
Flat
Hierarchial
Relational
This acronym defines the 4 basic functions of a databse
(a)
A blank database entry in called a
(a)
All of the following are constraints except
Unique
Check
Default
Not Null
Self Reference
Select, Insert, Update, Delete and Merge all pertain to what?
DML
DDL
Use, Create, Alter, Drop, Truncate, Delete all pertain to what?
DDL
DML
Which of the following initiates an action when an event occurs like Insert, Delete or Update?
Constraint
Trigger
View
Procedure
