B.4 Practice Exam #1 April

When Jacob first starts his computer, he hears several warning beeps and nothing else happens. Which of the following is sending out the beeps?

• Operating System (OS)

• Heat Sink

• Power Source

• Power-On-Self-Test

  You need a storage device that has very large storage capacity, is fast, and is relatively inexpensive. Which storage device will best suit your needs?

• 
• 
• 
• 

What is the name of the narrow strip along the bottom of the Windows environment?

• Navigation bar

• Shortcuts menu

• Toolbar

• Taskbar

   When protecting your online identity, which of the following is an internet security threat you need to be aware of?

• Using a different password for each social media platform

• Phishing attempts

• USB key loggers

• Using personal information

Christian has logged onto his bank's website. He wants to pay some bills electronically and transfer funds to his savings account. He checks to see if the padlock icon is visible in the address bar. The padlock is there, and it is green. What does that indicate?

• You should not trust a green padlock

• A highly trusted certificate

• The green color has no meaning

• The certificate is pending, but you should trust it anyway.

Brandon is a member of an online gaming community that makes files available to each other from their local hard drives. Which of the following BEST describes this file system feature?

• Permissions

• NTFS (New Technology File System)

• Hierarchal file system

• P2P (peer-to-peer) sharing

Which network type uses light pulses to transmit data?

• Fiber Optic

• Wireless

• Cable

• Satellite

Software that requires a monthly subscription fee is often called _______________.

• Temporary Software

• Online-only software

• Web applications

• Software as a Service (SaaS)

Which of the following is an advantage of using an 802.11n/ac standard over an 802.11b/g standard for a wireless network?hich of the following is an advantage of using an 802.11n/ac standard over an 802.11b/g standard for a wireless network?

• An 802.11n/ac standard is encrypted.

• An 802.11n/ac standard provides Bluetooth wireless networking.

• An 802.11n/ac standard has many more non-overlapping channels.

• An 802.11n/ac standard covers more distance.

  As a database administrator, you want to speed up query retrieval time in your relational database. Which of the following SQL commands could you use to accelerate retrieving data with a query?

• CREATE TABLE

• CREATE INDEX

• CREATE VIEW

• ALTER TABLE

Answer explanation

·       The CREATE INDEX command creates an index within a table, which can be used to accelerate the speed of query retrieval time.

·       The CREATE VIEW command creates a virtual table populated from a SQL statement result-set. It does not speed up query retrieval time.

·       The ALTER TABLE command can be used to add, change, or remove fields on an existing table. It also lets you define primary and foreign keys. However, it does not speed up query retrieval time.

·       The CREATE TABLE command simply adds a new table to an existing database. It does not speed up query retrieval time.