Font size
WorksheetsITF Databases
Total questions: 20
Worksheet time: 10mins
You have a contact list for an online marketing company. It contains names and email addresses for approximately three million people. A team of twenty marketers works with information on the list. Which solution should you use to store the data?
SPREADSHEET
RELATIONAL DATABASE
WORD PROCESSING SOFTWARE
NON-RELATIONAL DATABASE
Which of the following outlines the structure of the database, such as what tables and fields are included?
Physical schema
Logical schema
Forms
Primary key
Which of the following commands best describes the function of the DELETE command in a relational database?
Deletes a record from a table
Deletes a field from a table
Deletes a schema from a table
Deletes a database or a table
You are creating a table in a relational database. Which of the following is required?
Foreign Key
Constraints
Logical schema
Primary key
Which of the following is considered non-structured data?
Text
Numbers
Pictures
Pictures with metadata
Mary, a user, has created a SQL query to access data in her database. Which of the following terms best describes the type of access she is using?
user interface/utility access
Programmatic access
Database dump
Direct/ manual access
A database developer is working on generating queries. If the developer needs to ensure that the output of the query has data persistence, to where should the data be written? (Choose two.)
HDD
RAM
SSD
CPU
Which command is used to create queries in a relational database?
FIND
SEEK
SEARCH
SELECT
You need to delete a database. Which command is used to do this?
DROP
ALTER
DELETE
REMOVE
Michael, an administrator, needs to add a column to an existing table. Which command should he use?
insert
create
update
alter
A primary key specifically is what?
A field in a table
A record in a table
A schema in a database
A table in a schema
A database contains medical images such as X-rays. Medical professionals have appended notes to the images with the patient’s name and date. What is this an example of?
Structured data
Schema definition
Semi-structured data
Non-structured data
A school has a database with four tables, but it needs a fifth table. Which is used to accomplish this task?
Insert
update
create
alter
An employee at your office just got married and changed their last name. Which command do you use to change their last name in the employee database?
edit
modify
alter
update
Henry wants to understand which of his customers has purchased part number BB8. Which command should he use?
query
find
search
select
Peter is accessing a database using a JDBC connection. Which of the following terms best describes the type of access he is using?
Direct/Manual access
programmatic access
user interface/ utility access
Query/ report builder
Which of the following descriptions best describes the type of structure that stores values as blobs?
relational database
non-relational database
document database
key/value database
Joe creates a database. What does he need to do next to make it usable
Enable permissions
Import data
run queries
create forms
Laura, your manager, instructs you to remove a tabale from a database permanently. Which command should you use
delete
remove
drop
alter
You have created a new table with 12 fields. How many foreign keys can the table have?
0
1
12
unlimited
