introduction to base Flashcards
a ___ database stores data in several tables and links those tables together to get a common piece of information
relational
All the columns in a table are called _____
fields
a _____ key is a source of check, which uniquely identify each record in a table.
primary
______ helps you to retrieve the filter databased up on some conditions.
query
a____ contains the values for all the fields that belong to a single person or an entity.
record
True or false - OpenOffice base is a database management system.
true
True or false - a set of character present a valid value is known as data.
true
True or false - in the flat file database system, can make links.
false
True or false - tables reports and forms can be created in base.
true
True or false - it is compulsory create a primary key in a table.
true
In how many ways can a table be created in base?
3
The default length of a field of a text data type is ____
10
______ are the user-friendly interfaces that facilitate the process of entering data in tables and queries.
forms
How many data types are there in OpenOffice base?
5
_______ key is used to establish relation between two or more tables.
foreign
Supriya is given an assignment to create a new table in the existing database. how can She do it?
design view,wizard
Mansi wants to created table of students information where the field student_id should be automatically generated numbers. Which option should she use to achieve this?
set auto number property-yes