introduction to base Flashcards

1
Q

a ___ database stores data in several tables and links those tables together to get a common piece of information

A

relational

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

All the columns in a table are called _____

A

fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

a _____ key is a source of check, which uniquely identify each record in a table.

A

primary

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

______ helps you to retrieve the filter databased up on some conditions.

A

query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

a____ contains the values for all the fields that belong to a single person or an entity.

A

record

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

True or false - OpenOffice base is a database management system.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

True or false - a set of character present a valid value is known as data.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

True or false - in the flat file database system, can make links.

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

True or false - tables reports and forms can be created in base.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

True or false - it is compulsory create a primary key in a table.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

In how many ways can a table be created in base?

A

3

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

The default length of a field of a text data type is ____

A

10

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

______ are the user-friendly interfaces that facilitate the process of entering data in tables and queries.

A

forms

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

How many data types are there in OpenOffice base?

A

5

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

_______ key is used to establish relation between two or more tables.

A

foreign

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Supriya is given an assignment to create a new table in the existing database. how can She do it?

A

design view,wizard

17
Q

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?

A

set auto number property-yes