stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
ICT Database Essentials Flashcards | StudBud
Explore
/
ICT Database Essentials
ICT Database Essentials
35 terms
·
StudBud Administration
·
75 plays
Imported from external platform
Flashcards
35 cards
F
Practice quiz
P
Host live
L
Questions
35
Answers
1
Question 5 :
Which data type is used to provide links to other resources?
Attachment
Hyperlink
Text
OLE Object
2
Which Microsoft Office application should you use for database creation and manipulation?
Excel
Google
Bing
Access
3
Question 10 :
Which app should you use to store a large quantity of data in an organized format to easily query?
Presentation
Spreadsheet
Word processor
Database
4
Question 19 :
You will find these options on the backstage view of Access except __________________.
Print
Open
Create
Save
5
Question 17 :
_____________________ is a search engine.
Bing
Excel
Access
One Note
6
Search engines consist of ___________________ that contain information about webpages.
Big-data documents
Pre-defined queries
spreadsheets
Databases
7
Question 16 :
Which data type is best for calculations?
AutoNumber
Text
Number
Currency
8
Question 14 :
In which of the following must the data be unique?
The foreign key
The common field
The junction table
The primary key
9
What does a database use to provide a simplified interface for the user to enter, modify, and view database records?
Query
Table
Form
Report
10
Question 12 :
How many characters are allowed in the Text field?
More than 255
1-255
1-9
Unlimited
11
Question 10 :
What data type is used for monetary values?
General
Currency
Autonumber
Accounting
12
Question 3 :
Which database application would most likely be used in large organizations?
HTML
Excel
Access
Oracle
13
Question 15 :
Which statement about spreadsheets is true?
Spreadsheet applications are generally complex, difficult, and difficult.
Spreadsheet files can contain only a limited number of records.
Spreadsheet files can contain an infinite number of records.
Spreadsheet tables can be related through common fields.
14
Question 20 :
Advertisers use Big Data to:
focus target markets.
sell information to others.
gather information on everyone.
spy on consumer shopping habits.
15
Question 2 : Databases store information in ___________________, which are made up of columns and rows.
Tabs
Image files
Tables
Ribbons
16
Which type of application should you use if you need to "crunch" small volumes of numbers to analyze numeric data?
Word Processor
Spreadsheet
Database
Presentation
17
A collection of data so large and complex that it is difficult to store and process using traditional database software?
Relational data
Unrelated data
Big data
Spreadsheet data
18
Question 12 :
The Title Bar in Access usually consists of ___________________.
the names of the application and the Database
the names of the application and the user
the names of the file and the user
the names of the application and the file
19
Question 13 :
When is a database used?
To display information in a picture form instead of using words
To perform searches for information on the Internet
To store and organize large amounts of information for quick searching
To create and format text documents for sharing information
20
What can you use to retrieve specific data from a table within a database?
Record
Field
Column
Query
21
Retailers use big-data to:
offer special promotions.
create spreadsheets.
create databases.
sell information to others.
22
In a database, Yes/No, Text and Date/Time are all examples of:
tabs you can select.
records in the data table.
data queries.
data types.
23
Question 7 :
What is another name for a table row in a database?
Heading
Field
Column
Record
24
Question 8 :
There are _____ data types in Access.
10
8
12
7
25
Question 4 :
Which of the following is an advantage of using a spreadsheet?
Software and hardware costs are higher.
The ability to sort and query easily.
May contain redundant data.
Data is protected from corruption.
26
Question 11 :
Which language is used to develop and manage databases?
Java
SQL
HTML
DBMS
27
Which of the following is an advantage of using a database?
Can easily present information in a graphical form
More than one person can use it at a time
Useful for storing and crunching small amounts of data
Easy to learn
28
Question 2 :
What can you use to summarize and print data for presentation or sharing?
Column
Query
Heading
Report
29
The tables of information in a relational database are joined or linked to one another by a ___________ field.
key
common
foreign
primary
30
Question 8 :
The options on the Ribbon will _______________.
change depending on the view
stay the same depending on the view
stay the same depending on the tab
change depending on the tab
31
Which statement about databases is true?
Database files can contain only a limited number of records.
Multiple people can use the same database data simultaneously.
Database applications are used to "crunch" numbers for numeric analysis.
Database files are prone to inadvertent data corruption.
32
Relational databases consist of multiple tables of information that are related through:
Common Fields
ID Columns
Header Rows
Bid Data
33
The following is true about Search engines, except:
They are powerful software programs.
They are suitable for crunching numbers.
They are large databases that contain information about webpages.
They make it easy to find information on the Internet.
34
Question 9 :
What does SQL stand for?
Standard Query Language
Simple Query Language
Single Query Language
Structured Query Language
35
What options are available by default on the Quick Access Toolbar?
Redo, Undo, and Help
Print, Save, and Delete
Save, Redo, and Undo
Print, Save, and Redo
