記憶度
15問
35問
0問
0問
0問
アカウント登録して、解答結果を保存しよう
問題一覧
1
what is processing time?
OS divides time into number of time slices and depending on priority of tasks to be processed allocates each task a number of time slices
2
What is a utility application?
A program that carries out a specific task to assist the operating system
3
factors that affect sound quality?
sample rate bit depth bit rate
4
what is a field
a row in a table
5
what is buffering?
A buffer downloads the next part of the video and stores it before watching it. helps prevent possible disruptions if there are any delays in streaming.
6
What is a vector graphic?
Vector graphics store information about the components that makeup an image, eg lines, curves and shapes no loss of quality when resized, small file size.
7
What is a real number?
A number that is negative or positive and has decimal or fractional parts.
8
key field connects to
foreign key in different table
9
what does a relationship in a database do
links two or more table using a relationship type
10
what is lossy compression?
reduces file size by removing some data, eg the number of occurs used in an image. small reduction in quality. permanently removed data, can't be used on text.
11
eg of vector images?
cartoons clip art
12
what does Pict stand for
picture
13
ppcm
points per cm
14
what would be a query to find all black or brown pets?
pet colour = black OR pet colour = brown
15
What device convert analogue sound to digital?
ADC Analogue to digital converter
16
what does pdf stand for
portable document format
17
what is a macro
a macro is a small program which automatically performs a repetitive task. the instructions in a macro will be executed with the click of a button. they add functionality to form and reports.
18
Is 6.3 an integer or real number?
Real
19
what does MPEG stand for
moving picture experts group
20
applications using batch processing
billing system payroll system banking system
21
eg of vector files?
SVG ai shapes in word logos
22
What is the relation between pixels and resolution?
Resolution is the quality of an image. The more pixels, the higher resolution, the larger the file size.
23
What are characters and numbers coded in?
ASCII AND BINARY
24
relationships can be...
one to many one to one many to many
25
what is batch processing
collecting similar for ups of data over a period of time. data is input at an off peak time without human involvement.
26
eg of lossy files?
jpeg mp3 AAC
27
how can layout of reports be sorted
grouping together similar groups of data sorting- in ascending or descending order
28
what does rtf stand for
rich text format
29
where are databases used?
databases are used to for many different things, a social network collects data about you. libraries use databases to know what books you have out on loan
30
functions of an operating system / system software
allocating memory storage processing time
31
what is data analytics
involves analysing large volumes of data to produce useful information. helps organisations make decisions and plan for future growth. data mining processes lots of data. when data is in different formats it makes processing data hard
32
how many colours in one byte?
256
33
what does tiff stand for?
Tagged image file format
34
ppi?
points per inch
35
Howany KB in one MB?
1024
36
what does wav stand for
windows audio waveform
37
what does png stand for
portable network graphic
38
what is allocating memory?
organises use of main memory between data files as rehy are transferred to and from hard disk
39
23 is an integer or real number?
integer
40
eg of bitmap files?
JPEG BMP gif png
41
What is a pixel?
A pixel is the smallest unit of a digital image that can be displayed and edited.
42
A typical JPEG image uses.... bits to store a pixel?
24
43
What is disk defragmentation
rearranged all the data so that files are stored in adjacent blocks. stores all free blocks together in one place. speeds up time to access files because everything is together in same place.
44
what is application software?
enables computer to do a particular task such as word processing
45
what is a query
searches and filters data that satisfies query criteria
46
What is a bitmap graphic?
Bitmap graphics store every detail about every individual pixel of an image. Large file size, Loses quality when resized. Can be compressed which reduces file size.
47
applications using multi user processing system
multi user database management systems
48
eg of lossless file formats
win zip slac tiff png
49
what does midi stand for
musical instrument digital interface
50
what is lossless compression?
lossless compression maintains quality of the file, no data loss. temporarily removes unnecessary data to send over internet but is restore once file is reopened. can be used on text
51
operators?
AND OR BETWEEN < > <= >= <> =
52
what is a key field
it uniquely identifies a record
53
what is data portability?
the ability to transfer data from one computer or one software to another without having to re enter it.
54
data types in databases
text number date/time currency yes/no (boolean) hyperlink auto number ole object attachment calculated look up wizard
55
what does txt stand for
text
56
what is system software?
enables computer to operate it's hardware and application software
57
modes of processing
real time batch multi user
58
What is streaming?
Streaming allows a video to be viewed on a website as it downloads in real time
59
what are reports
reports are used to present results from queries in an effective manner
60
What is information?
Information is data with meaning.
61
bit depth?
the number of bits used for each sound sample. higher bit depth, higher quality.
62
What are four utility applications
Disk defragmentation Task scheduling Data backup and restore Antivirus software
63
What does it mean when operating system manages storage?
manages storage of data in external devices such as a hard drive
64
What is an integer?
A whole number that can be negative or positive but does not have any decimal or fractional parts.
65
How many bits in a byte?
8
66
-5. 4 an integer or real number?
real
67
bit rate?
The data measures in bits that us processed in a given amount of time
68
What is an analogue signal?
a continuous varying signal that represents physical quantity
69
how many colours in one bit?
two
70
data validation check
type check range check length check format check presence check
71
what is data backup and restore
a backup is a copy of the original data in case it is damaged or lost. you can backup file by uploading last rule onto system, you can backup complete data file (full) or only the data that has changed (incremental)
72
what is a form
used to collect data to create a new record, modify existing record or view already creates records
73
three v's?
VOLUME - amount of data stored by organisations VARIETY- different types of data VELOCITY- speed at which data can be processed
74
what is data compression and why is it helpful?
data compression reduces file saize and maintains quality of the file. this means faster upload and download of these files
75
wht is a record
a row in a table
76
dpi
dots per inch
77
what is real time processing?
data is processed as soon as it is input data files updates before next transaction output generated is processed quickly enough to influence next input
78
what is multi user system
involves many users at different computer sharing same processor is gives each computer a time slice (processor time)
79
Each pixel is stored as..?
A series of binary digits
80
why is it important to import data from spreadsheets to database packages?
give organisations more flexibility in handling data
81
what does an antivirus software do
it detects, located and removes a virus. it scans all data files on a computer and compares these files to a known database of viruses. antivirus can also scan all devices connected to a computer eg usb
82
Names five data types
Date/Time Character String Integer Real
83
what is a database
a software application used to store data
84
what does gif stand for
graphics interchange format
85
what is data validation
involves a range of automatic checks to ensure data at input stage is sensible and within acceptable limits. computer either accepts this data or rejects it and displays error message
86
what is big data
refers to large amounts of data stored on a computer system which has the potential to be mines for information
87
sample rate measured in?
herts Hz
88
applications using real time processing?
airline booking concert booking online stock control air traffic control
89
eg of bitmap images?
photographs scanned images camera
90
what does wma stand for
windows media audio
91
What is data?
Data is raw facts and figures which have not been processed and has no meaning.
92
what does avi stand for?
audio video interleaved
93
What can be scheduled
backup shutdown start up software updates
94
what does CSV stand for
comma separated values
95
what would be a query to find all white dogs?
pet type = dog AND pet colour = white
96
sample rate?
the number of sounds samples captured per second to represent sounds digitally.
97
what is task scheduling
automatically performs routine task at set time on computer, processor time is divided amongst number of tasks
98
what does a table consist of
a number of records
99
what is a virus
a virus is a program designed to cause damage to computer or enable hacker to enter computers
100
what does JPEG stand for
joint photographic experts group