wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

LIbreOffice Base Quiz111

Total questions: 24

Worksheet time: 14mins

Name
Class
Date
1.

Label the given interface of Form

2.

Which of the following toolbars contain the Label tool in Libre?

a)

Standard toolbar

b)

Forms Control Toolbar

c)

Records Toolbar

d)

Formmatting toolbar

3.

What is the file extension of Base file?

a)

.odb

b)

.odp

c)

.abc

d)

.dbc

4.

A component of database that is used to store data or information.

a)

tuples

b)

tables

c)

records

d)

fields

5.

While creating a table, the _______________is selected to specify the type of data that can be entered for a field.

a)

field

b)

record

c)

data type

d)

form

6.

What is a database?

a)

Information around the world that is available for everyone to analyze market interest

b)

System to restore information in Windows 10 OS

c)

A database is an organized collection of data stored and accessed electronically from a computer system

d)

Program to create documents that interact with webpages through JavaScript, SQL, and HTML

7.

What is the best data type to store the human population as precisely as possible?

a)

String

b)

Boolean

c)

Float

d)

Integer

8.

What does SQL stand for?

a)

Structured Query Language

b)

Structured Question Language

c)

Strong Question Language

d)

None of the above

9.

A relational database can have how many types of keys in a table ?

a)

Candidate key

b)

Primary key

c)

Foreign key

d)

All of these

10.

What could be the correct datatype for 'H.NO. 234, SEC-14' data

a)

Date

b)

int

c)

varchar

d)

decimal

11.

A _______is a request for data or information from a database table or combination of tables.

a)

query

b)

request

c)

command

d)

instruction

12.
What is the maximum size of the VARCHAR Column type?
a)
255 char
b)
255 Byte
c)
512 Char
d)
512 Byte
13.

What is the purpose of a primary key in a relational database?

a)

To uniquely identify a record in a table

b)

To establish relationships between tables

c)

To sort the records in a table

d)

To store large amounts of data

14.

What is the difference between a primary key and a foreign key?

a)

A primary key is used to uniquely identify a record in a table, while a foreign key is used to establish relationships between tables

b)

A primary key is used to establish relationships between tables, while a foreign key is used to uniquely identify a record in a table

c)

A primary key is used to sort the records in a table, while a foreign key is used to store large amounts of data

d)

A primary key is used to store large amounts of data, while a foreign key is used to sort the records in a table

15.
  1. What is a query?

a)

A way to insert data into a table

b)

A way to retrieve data from a table

c)

A way to delete data from a table

d)

A way to update data in a table

16.
  1. What is a form in OpenOffice Base? Select all that apply

a)

A way to delete data from a table

b)

A way to insert data into a table

c)

A way to display data from a table

d)

A way to update data in a table

17.
  1. What is the use of a report in OpenOffice Base?

a)

A way to display data from a table

b)

A way to insert data into a table

c)

A way to delete data from a table

d)

A way to update data in a table

18.
  1. What is a relationship in OpenOffice Base?

a)

A way to link forms

b)

A way to link databases

c)

A way to link reports

d)

A way to link tables

19.
  1. What is a foreign key?

a)

A field in a table that links to the foreign key of the same table

b)

A field in a table that links to the primary key of the same table

c)

A field in a table that links to the primary key of another table

d)

A field in a table that links to the foreign key of another table

20.

(a)   means all kinds of facts,figures and details related to people places things or events.

21.

Information is the required result obtained from (a)   of data

22.

Attributes are also referred to as (a)  

23.

_________ refers to changing data and modifying it for some use

a)

Record

b)

Manipulation

c)

Table

d)

None of these

24.

LibreOffice Base store related entries in it's row, which is called________

a)

Record

b)

Field

c)

Form

d)

Table