Still need to review

Statement identifies the records that are being requested in the Asterix means everything from that table

A where?

B. Select.

C join

D from

B

Data is stored in

A records or rows

B columns or fields

C. Data table or data sheets

A

This operation takes rows from one table and create a new table

A update

B selection

C delete

D insert

B

Is planning for an executing adequate backup and recovery procedures

a high availability

B reporting

C back up and recovery

D business continuity

C

This interface between clients and databases responding to client request

A application servers

B websites

C network routers

D middle wear

B

Is the translation of raw data into something useful?

A business intelligence

B data mining

C data transformation

D data warehousing

A

These servers search a database or the results in a webpage and send that page to a client

A database

B file

C web

D proxy

C

Contains a single piece of data about the subject of a record

A records

B columns

C data tables

B

The parameter after FROM identifies the

A condition

B table name

C records

D everything

B

This operation creates a results table that include all of the attributes from the two tables

A join

B union

C product

C

When it meets the requirements of the data collection process or is with an expected range of possible values

A valid

B reliable

C complete

D precise

E timely

A

Specifies how data is transformed into information per the user specification it runs the computer by controlling its hardware components and peripherals

A hardware

B software

C middle

B

Which of the following is an example of a computer network?

A Internet browser

B client to server peer to peer

C motherboard

D operating system

B

These special purpose computing devices include devices that make it possible to communicate with each other

A switches

B network routers

C access points

D all the above

E none

D

Two common types of networks are

A PAN

B LAN

C WAN

D both a and B

E both B and C

E

Describes how accurate the data is in the context of its intended use

A reliable

B timely

C precise

D complete

E valid

C

Data should be what when it is collected the same way at the same time using the same methods

A precise

B complete

C valid

D timely

E reliable

E

This consist of the programs that perform task specific to the machines general purpose

A application software

B kernel

C system software

D operating software

A

These are referred to as middleware that facilitate the communication of hardware and software

A hardware

B operating system

C software

D device drivers

D

This is required to be purchased. Does not permit anyone to modify their operating system code.

A bespoke

B open source

C closed source

D off the shelf

C

The US gives a copyright to an author of a software package the ability to prevent unauthorised duplication for at least 35 years

A public domain

B shareware

C freeware

D a and b

E b and c

E

This network topology is used and wireless networks were communication is carried out via a radio broadcast to a central machine called the access point

A hybrid

B star

C mesh

D bus

E ring

B

Connects every device in a network to every other device and enables redundancy well also introducing significantly more network traffic

A bus

B star

C ring

D mesh

E hybrid

D

Computers are arranged in a circle with each one connecting to the computers on other sides

A ring

B star

C bus

D mesh

A

These are used to connect different types of networks and provides management of the messages

A router

B bridges

C repeaters

D switches

B

A software that acts as an intermediary between a client and a server to shield the client from adverse actions of the servers

A firewall

B proxy server

C antivirus

D network auditing tool

B

What is the primary function of a router in a communication network?

A determining the fastest network path for data packets

B filtering and forwarding data between different networks

C translating IP addresses to domain names

D ensuring secure connection through encryption

B

Have a single machine serving as a central point to which all others are connected

A ring

B star

C mesh

D bus

B

Which phase includes developing a roadmap that ensures everyone follows?

A project planning

B project closure

C project execution

D project initiation

A

Project planning defines the what and drafts a project management plan

A communication plan

B Work breakdown structure

C risk management plan

D project scope

D

The outcome of a project will likely affect other systems and processes in an organisation are

A execution

B planning

C unknown

D integration

D

The risk can be mitigated by assessing potential disruptions, ensuring adequate support from stakeholders and having a shared understanding of the project complexity

A execution

B integration

C unknown

D planning

B

In what phase of the project management life-cycle are risk identified and analysed?

A execution

B closing

C initiation

D planning

D

Includes developing a roadmap that everyone follows

A closure

B initiation

C planning

D execution

C

This can be mitigated by planning in advanced for

A risk of the unknown

B risk in integration

C risk in execution

C

Risk can be mitigated by assessing potential disruptions ensuring adequate support from stakeholders and having a shared understanding of the project complexity

A risk of the unknown

B risk in execution

C risk in integration

C

Two key strategies for identifying risk or frequent monitoring of project parameters and milestones and communicating between project participants

A risk of the unknown

B risk in integration

C risk in execution

A

File permissions ,user access controls version control and redundant systems or copies are methods of maintaining

A confidentiality

B integrity

C availability

C

Best insured by regularly maintaining all hardware testing compatibility with operating system systems and installed applications and keeping systems patched and up-to-date

A availability

B integrity

C confidentiality

A

Transforms data from one into another, performs calculations manipulates files and complete other tasks that may be repetitive time-consuming or dangerous

A security

B software development

C business analysis

B

Responsible for installing administering and troubleshooting network security issues

A security administrator

B network administrator

C system admin

D database administrator

A

Enable data to move between computer systems components

A hardware

B middleware

C software

B

Which phase includes developing a roadmap that ensures everyone follows?

A project planning

B project closure

C project execution

D project initiation

A

First laser printer launched by xerox, a new era and printing

A first generation

B second generation

C third

D fourth

D

Special purpose computer that forward your messages to and from the machines on their network they use their boarding table to match up the private IP address with the Internet IP address and send the message to the correct machine

A modem

B router

C firewall

D switch

B

This tier of ISP are typically dependent Internet and intranets operated by a single organisation that supplies Internet access to homes and businesses

A first

B second

C third

C

The client is responsible for licensing the operating system and managing back end networking

A Iaas

B PaaS

C Saas

A

The software is licensed to customers with subscriptions and central hosting

A Iaas

B Paas

C Saas

C

Giving rights to new users so they can access various databases is a very common task database administrators perform what is one probable advantage of outsourcing

A reliance can be placed on the expertise of outsourcing vendors

B employee satisfaction may increase

C more control can be exercised over IT processing

D the organisation can transfer its accountability in terms of privacy laws

A

Being concerned that some team members may become unavailable during the project describes what concern

A contract risk

B resource risk

C scope creep

D project dependencies

B

Which statement describes the role of a network administrator?

A network administrators are accountable for the installation and maintenance of resources on a network

B responsible for the installation and maintenance of hardware and software that make up a computer

C long list of essential responsibilities but mostly focus on design development and support of database management systems

D responsible for maintaining websites

B

Being unsure that the project task list will remain unchanged describes what?

A scope creep

B resistance to change

C budget risk

D project dependencies

A

Facts gathered from observations or a clock that measures time are examples of data what is not an example of data

A on off

B 9:30 am

C it’s cold outside

D 1830

C

Which database can increase resources to accommodate for demands on the system while maintaining high availability even in the case of local or regional outages?

A cloud database base

B data lake

C distributed database

D NoSQL database

A

Which task describes the role of a database administrator?

A working with organisations to keep their information system secure and ensuring integrity and confidentiality and availability of data

B integrating data from legacy systems to newer systems and playing a role in application design and development

C organising people time and other resources to make sure project requirements are completed on time and within budget

D creating documenting executing and manually creating test plans and procedures relating to system anomalies

A

Analysing the needs of users of new software application describes which phase of the software development life-cycle

A testing

B requirement analysis

C implementation

D design

B

What is the collection of names addresses and account balances of all patients in an office more technically known as?

A database

B file

C record

D key field

A

This plan specifies how a business will resume after a catastrophic event to continue its operations

A business continuity

B disaster recovery

C disaster reconciliation

D business reconciliation

B

Writing the code for a new application is which phase of the software development life-cycle

A implementation

B design

C testing

D requirement analysis

A

Where are the basic functions of an operating system located?

A kernel

B file manager

C utility software

D applications

A

What is another term that defines a script?

A compiler

B machine code

C interpreted program

D Pascal

C

What is the role of the CPU in a computing system?

A distributing signals between all parts of the computer

B permanently storing all data and programs on the computer

C performing instructions of computer programs

D temporarily storing activities before transferring them to the hard disk

C

Which of the following statement describes why network protocols are necessary?

A prevent computer hacking

B necessary for computers to communicate with each other

C necessary for a home computer that is not connected to the Internet or any other device

D required by international laws

B

Prohibit intentionally accessing a computer without authorisation or an excess of authorisation the anti-hacking law

A anti-cybersquatting consumer protection act

B computer matching and privacy protection act

C electronic communication privacy act

D computer fraud and abuse act

D

What is a program that allows the user to monitor and improved system performance and extends the capabilities of an operating system?

A utility software

B system services

C device drivers

D kernel

A

All of the following are parts of a URL except for

A LAN

B host name

C TLD

D protocol

A

Stores instructions for crucial system activities

A ROM

B hard drive

C RAM

D motherboard

A

These are typically fairly short and the instructions are relatively simple. Have traditionally been used more for automation more than for software development.

A script

B program

D algorithm

C bus network

A

In this phase of the SDLC system development life-cycle architects think about the components that they would need to solve the problem or implement the plan

A design

B maintenance

C planning

D analysis

E testing

A

The user specifies the blank from which the row are taken using a select statement to identify the records that are being requested

A table

B column

C record

D row

A

Unsure that you can control the allocation of cost during the project budget control issues such as underestimated or improper allocation of cost

A scope creep

B budget risk

C resource risk

D contract risk

B

Which statement describes the role of a network administrator?

A accountable for the installation and maintenance of resources on a network

B have a long list of essential responsibilities but mostly focus on the design development and support of the database management systems

C responsible for the installation of maintenance of hardware and software that make up a computer

D responsible for maintaining websites

C

What is the component of the DIKW hierarchy that includes basic observations?

A data

B information

C wisdom

D knowledge

A

Which term best describes the statement? The oven is at three 50°F nearing the needed temperature. Based on the DIKW hierarchy.

A data

B knowledge

C information

D wisdom

B

What is the DIKW pyramid component exemplified by the statement? I have extra time so I should review my answers.

A data

B knowledge

C wisdom

D information

C

Which term describes the statement? It is 1:50 pm so I should head to room 126 based on the DIKW hierarchy.

A information

B wisdom

C data

D knowledge

B

Which component of an operating system uses scheduling to control access to shared resources?

A kernel

B user interface

C file manager

D driver

A

Which component of an operating system allows an individual to communicate with the operating system?

A user interface

B driver

C file manager

D kernel

A

Which software provides private or shareable file management via the cloud?

A instant messaging

B document storage

C video conferencing

D online workspace

B

What is the name of the networking technology that reduces network traffic on a local area by management of network messages?

A repeater

B server

C firewall

D switch

D

What is a professional organisation that publishes a set of ethical IT guidelines?

A NSA

B NIST

C AITP

D ITS

C

Which entity helps other organisations design and apply appropriate approaches to personal data collection use disclosure

A AIPP

B NIST

C ABET

D NSA

A

What is the name of the CPU in a computing system?

A temporarily during activities before transferring them to the hard disk

B performing instructions of computer programs

C permanently storing all data and programs on the computer

D distributing signals between all parts of the computer

B

Which statement describes the role of a network administrator?

A network administrators are accountable for the installation and maintenance of resources on a network

B network administrators are responsible for the installation and maintenance of hardware and software that make up a computer network

C network administrators have a long list of essential responsibilities but mostly focus on design and development

D responsible for maintaining websites

B

Which statement describes the role of a system administrator

A responsible for design designing and developing software that makes hardware and software systems work

B responsible for supporting monitoring and maintaining workplace technology and end users

C creating documenting and executing manually created test plans

D monitoring and organisations network for security breach

B

Being concerned whether a selective durable completely planned deliverables as agreed

A resource risk

B project dependencies

C contract risk

D scope creep

C

Unsure that the project task will remain unchanged best describes

A budget risk

B resistance to change

C project dependencies

D scope creep

D

Which task describes the role of a database administrator?

A organizing people time and other resources

B creating documenting executing and manually creating test plans

C working with organisations to keep information system secure

D integrating data from legacy systems to newer systems

D

What is the primary duty of a computer support specialist?

A primarily operates the trainer in troubleshooter

B primarily identifies and helped clients adopt IT services

C support specialist is mainly responsible for allowing an organisation to take full control of that data

D provide mostly technical expertise by developing and implementing IT systems for external appliances

A