stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
IPT Megaquiz Flashcards | StudBud
Explore
/
IPT Megaquiz
Which component of a database is used for sorting?
What is a normalised database?
IPT Megaquiz
80 terms
·
StudBud Administration
·
71 plays
IPT
Flashcards
80 cards
F
Practice quiz
P
Host live
L
Questions
80
Answers
1
What is a normalised database?
Relational database
A normalised database
Relation database
Flat file database
2
Which component of a database is used for sorting?
Field
Table
Form
Record
3
DBMS stands for which of the following?
Data Building Master Sync
Database Management System
Data Broadband Minimal System
Direct Base Management System
4
What is MYCIN?
the first fingerprint-matching expert system
a famous medical neural network
a system for predicting weather using AI
a system that can replace doctors
5
What is an Inference Engine?
A piece of hardware found in most personal computers
Explains how a result was reached
Part of an expert system that carries out reasoning
The real name of the computer heat extracting fan
6
This is used to view, enter and modify data in a database
Tuple
Form
Table
Metadata
7
A private network with an interface similar to the Web
Firenet
Extranet
Internet
Intranet
8
What is a mixed cell reference?
An evaluation on the final database
A reference to a cell that is relative to postion of formula
Excel reference containing absolute and relative references
Used by team leaders to provide feedback
9
Which of the following is used to handle uncertainty in a DSS
Intelligent Agent
Artificial Intelligence
Conflict resolution
Fuzzy Logic
10
..receives data from the environment, reacts to the data, and produces an intelligent response?
Intelligent Systems
Artificial Intelligence
Geographical Information System
Intelligent Agents
11
A primary key
Is the same as a foreign key
Is the same as a secondary key with no null values
Must have a unique value
Must have a null value
12
Which data type would be used to identify whether a song has explicit lyrics or not?
Real
Boolean
Currency
Date
13
Pieces of software that search through relational databases for relevant data
Neural Network
Intelligent Agent
Artificial Intelligence
Expert system
14
What is the result of a multimedia system called?
Multimedia Statement
Multimedia information
Multimedia Product
Multimedia Data
15
There is a student and a class table in a relational database. What is this relationship?
Many-to-one
One-to-one
One-to-many
Many-to-many
16
What is a linear regression model?
Unpacking data within a DSS from the most to least recent
best-fit relationship between two types of data
Used in planning of DSS
designing a DSS in chronological order
17
What is a flat file database?
a databse that organises data into a single table
a collection of facts
category of data in a database
a small unit of data that a person can use
18
What is not a component of an information system?
Purpose
Environment
Type
Data/information
19
This is the process of organising data into tables to work as efficiently as possible
Encryption
Entity Reduction
Compression
Normalisation
20
SELECT, FROM, WHERE and ORDER BY can all be found in..?
SQL
SDR
Intel
MSQ
21
What is data validation?
Used to check entry of data
describes reliablity of data
a process looking for relationships in data
The extend to which data is free from errors
22
Why is the record locking feature used in a shared database?
To prevent any user changing any field at any time
To prevent users changing the same record at the same time
To prevent any user changing any record at any time
To prevent users changing the same field at the same time
23
What are the 3 main components of a DSS?
data management, model management, dialogue management
model management, dialogue management, database
inference engine, model management, explanation mechanism
data management, database, user interface
24
Data stored in a database can be protected against unauthorised access by
Compression
Normalisation
Data warehousing
Encryption
25
Data that is unfairly skewed or gives too much weight to a particular result shows this
Bias
Aliasing
Bussing
Constraint
26
This is a computer that provides service to other computers on a network
Smurfer
Server
Swerver
Lurker
27
Sampling rate is..
The size of each sample taken
None of the above
The number of samples taken per second
The number of bits per sample
28
A bar chart that helps plan efficient time usage
Time Distribution Chart
Ergonomic Chart
Gantt Chart
Pie Chart
29
What is a data validation method
check digits
type checks
list checks
range checks
30
A set of rules that governs the transfer of data between two devices
German Suplex
Duplex
Triplex
Protocol
31
This error check counts the number of bits in a data packet
Baud Rating
Checksum
Parity Checking
CRC
32
This is a search of a database for records that meet a certain condition
Sorting
Python
Query
Operation
33
Which conversion method moves from the old system to the new system in one step?
Direct
Pilot
Parallel
Phased
34
Data integrity refers to
Data privacy
Data range checks
Data validation
The reliability and accuracy of data
35
What does DBMS stand for?
Defense Business Management System
Database Management System
Database Management Software
Database and Media Systems
36
What is not a text type used in a database?
Datetime
Long integer
Text
Short integer
37
What is structured data?
Data refered to within a schema
predefined characters, usually numbers
All data within a database
does not have predefined chracters, such as audio files
38
What does LCD stand for?
Liquid Crystal Disk
Liquid Crystal Drive
Liquid Crystal Display
Low Cache Drive
39
True or false. Flat file databases are not contained in a single file.
False
True
40
What is a sound source with only one channel?
Stereo
Micro
Mono
Radio
41
This describes that data is accurate, current and relevant.
Data Analysis
Data Integrity
Data Checked
Data Currency
42
What is a knowledge base?
database collected from different sources
set of if-then rules supplied by the expert
set of raw data used to enter into a database
provide user with information and solve problems
43
True or false. An SQL allows for more complicated operations than a simple query.
True
False
44
Distributed databases are
Multiple databases in the same geographical location
A single database in the same geographical location
A single database in different geographical locations
Multiple databases in different geographical locations
45
Which of these is NOT a storyboard layout?
Linear
Combination
Hierarchical
Vertical
46
What is an expert system shell?
The layout within an expert system
Expert System design software
Ready made expert system with no knowledge
set of if-then rules supplied by the expert
47
Whats meta data?
REALLY big data
information about data
48
This process finds relationships and patterns in data
Data agency
Data mining
Data confirmation
Data verification
49
This network topology has a central server that all other devices connect to
Hub Network
Ring Network
Star Network
Bus Network
50
Users of an information system…
build the system
actively engage in the system
are involved in the system but do not change it
Provide database with if-then rules
51
What are two characteristics of information systems?
analysis of information to give knowledge
analysing data
Organisation of data into information
carrying out information processes
52
This explains what each field of a database represents
Data Dictionary
Data Legend
Data Analysis
Data Key
53
What are keys?
Fields that are used to sort and retrieve information
The way keys are related to each other
data defintions for databaes
specific thing about which information is collected
54
What are heuristics?
are the same as algorithms
are used in a relational database
are supplied by experts in an expert system
are a basis for queries in a relationship database
55
An Expert System is mainly used for…
All of the above
Structured settings
Semi-structured settings
Highly Unstructured settings
56
Which is a type of media
Novels
Stories
Text
All of the above
57
An expert system is most likely to part of
A decision support system
A management information system
A transaction processing system
An office automation system
58
A Data Mart…
Used to download expert system shells
Refers to the largest sets of data possible
An online maketplace where large sets of data is acquired
Contains infromation about a particular group or topic
59
Which of the following is a common wildcard operator?
>
#
*
&
60
This transmission system sends data simultaneously using multiple channels..
Serial
MIME
Simplex
Parallel
61
Access to a flat file database is
Fast
Sequential
Direct
Slow
62
What are the purposes of information systems?
There purposes are changing with developments in technology
To provide information
To turn data into information
To provide data to organisations
63
A database management system
Manages but doesn't create databases
Is responsible for finding data on the web
Creates, retrieves, updates and manages data
Uses barcode readers as an input device
64
what are wildcard characters?
they represent unknown characters
specialised languaged to search databases
65
What does CRT stand for?
Cathode Ray Telescope
Cathode Ray Telephone
Cathode Ray Tube
Cathode Ray Transmission
66
A relational database consists of
A single relation
A single table
A single file
Mulitple relations
67
This is a collection of facts about one specific entry in a database
record
field
character
file
68
What is searching?
Another copy of data to rebuild systems
The process of examing databases to retrieve data
69
Which of the following are not future trends in Information Technology?
Ease of access
Increased storage
Increased speeds
Miniturization
70
What is normalisation?
process of finding out what data is normal.
the process of organiging data into tables.
71
What occurs when rules in data mining are incorrect?
No response
ERROR 404 message display
All appropriate data is found
An Erroneous Inference
72
Before data can be transferred on a network, the devices must..
Fist Bump
High Five
Handshake
Kiss
73
What does a VCR do?
Organises data within a database
Takes digital photos, storing it in digital form
Records and plays back video tapes
Allows for more efficient searches of a database
74
Whats is sorting?
process of arranging data in a certain order
a search of a database
75
What is not the purpose of an information system?
Analysing
Organising
Transmitting/receiving
Transmitting/retrieving
76
This development system breaks a large task into smaller sections
Waterfall
Agile
77
This is an old type of network device that sends ALL data to ALL computers on a network
Modem
Hub
Router
Splitter
78
What is hypermedia?
Combination of media who locations are linked electronically
Combination of media
79
Which of the following are examples of relational operators?
*
contains
>
Empty choice
80
A differential backup is
A backup of files that changed since the last full backup
A full backup of all stored data
A backup of specific files
A backup of files that changed since the last backup
