Font size
WorksheetsOpenOffice/LibreOffice Base
Total questions: 40
Worksheet time: 20mins
What type of program is OpenOffice Base?
Spreadsheet
Word processor
Presentation
Database
What is the file extension of Base file?
.odb
.odp
.abc
.dbc
A component of database that is used to store data or information.
tuples
tables
records
fields
___________allows you to store large amount of related data in the form of tables.
Spreadsheet
Data
Database
Table
While creating a table, the _______________is selected to specify the type of data that can be entered for a field.
field
record
data type
form
Unique value in the field, as an identity of the record in the table, called ...
row
column
field
Primary Key
Program to create a database
Microsoft Word
Microsoft Access
OpenOffice Base
LibreOffice Writer
OpenOffice Impress
What is a database?
Information around the world that is available for everyone to analyze market interest
System to restore information in Windows 10 OS
A database is an organized collection of data stored and accessed electronically from a computer system
Program to create documents that interact with webpages through JavaScript, SQL, and HTML
To use OpenOffice on your computer, you need to install 2 programs
OpenOffice installer and Flash player
OpenOffice Installer and FireFox
OpenOffice Installer and Java Runtime Environment
Java Runtime Environment and Audacity
What is the best data type to store the human population as precisely as possible?
String
Boolean
Float
Integer
What does SQL stand for?
Structured Query Language
Structured Question Language
Strong Question Language
None of the above
Which of the following can add a row to a table?
Add
Insert
Update
Alter
The SQL statement that queries or reads data from a table is __________ .
USE
SELECT
READ
QUERY
SQL can be used to:
Create database structures only.
Query database data only.
Modify database data only.
All of the above can be done by SQL.
A relational database can have how many types of keys in a table ?
Candidate key
Primary key
Foreign key
All of these
SQL Views are also known as
Complex tables
Simple tables
Virtual tables
Actual Tables
Which SQL keyword is used to sort the result-set?
Sort by
order by
sort
none of these
SELECT * FROM sales WHERE amount > 200.
The query will display all the sales records with amounts starting from 200 and above
The query will display all the sales records with amounts less than 200
The query will display all the sales records with amounts greater than 200
The query will output sales records with the amount equal to 200.
Correct command to create database school
use school ;
make database school ;
create school;
Create database school;
What could be the correct datatype for 'H.NO. 234, SEC-14' data
Date
int
varchar
decimal
Insert, select, delete and update command are part of _______ language
PHP
SQL
HTML
C++
A _______is a request for data or information from a database table or combination of tables.
query
request
command
instruction
Select the appropriate command to insert rows in a table
INSERT INTO Customers(ID, FirstName, LastName) VALUES ('1', 'User', 'Test');
INSERTINTO Customers(ID, FirstName, LastName) VALUES ('1', 'User', 'Test');
INSERT Between Customers(ID, FirstName, LastName) VALUES ('1', 'User', 'Test');
None of them
Select * from student ;
Above command gives output :
All rows and columns of table student
Selected Rows and columns
All table of Database
Nothing
Insert the missing statement to get all the columns from the Customers table.
___________________ * from Customer.
Insert
select
Update
None of them
How can we get the number of records or rows in a table?
Using COUNT
Using NUM
Using NUMBER
Both a and c above
A relational database ___________ is a data structure used to store and organize information.
View
Table
Report
Stored Procedure
What is the maximum size of the VARCHAR Column type?
255 char
255 Byte
512 Char
512 Byte
Identify the table name in the following SQL statement. INSERT INTO student VALUES(‘Kyle’,’M’,NULL);
Student
b) Values
c) Kyle
d) M
The NULL value also means ___________
value equal to zero
unknown value
c) negative values
d) a large value
What is the purpose of a primary key in a relational database?
To uniquely identify a record in a table
To establish relationships between tables
To sort the records in a table
To store large amounts of data
What is the difference between a primary key and a foreign key?
A primary key is used to uniquely identify a record in a table, while a foreign key is used to establish relationships between tables
A primary key is used to establish relationships between tables, while a foreign key is used to uniquely identify a record in a table
A primary key is used to sort the records in a table, while a foreign key is used to store large amounts of data
A primary key is used to store large amounts of data, while a foreign key is used to sort the records in a table
What is OpenOffice Base?
A database management system
A spreadsheet application
A presentation software
A word processor
What is the difference between a database and a table?
A database is a collection of tables
A table is a collection of databases
A database is a collection of forms
A table is a collection of forms
What is a query?
A way to insert data into a table
A way to retrieve data from a table
A way to delete data from a table
A way to update data in a table
What is a form in OpenOffice Base? Select all that apply
A way to delete data from a table
A way to insert data into a table
A way to display data from a table
A way to update data in a table
What is the use of a report in OpenOffice Base?
A way to display data from a table
A way to insert data into a table
A way to delete data from a table
A way to update data in a table
What is a relationship in OpenOffice Base?
A way to link forms
A way to link databases
A way to link reports
A way to link tables
What is a foreign key?
A field in a table that links to the foreign key of the same table
A field in a table that links to the primary key of the same table
A field in a table that links to the primary key of another table
A field in a table that links to the foreign key of another table
What is a primary key?
A unique identifier for a report
A unique identifier for a form
A unique identifier for a database
A unique identifier for a table
