Comptia Review 1

A developer needs to add a table to a database. Which of the following database activities should the user perform?

• UPDATE

• ALTER

• CREATE

• REPORT

Which of the following does a NoSQL database use to organize data?

• Primary keys
• Schemas
• Keys/values
• Tables

A systems administrator is setting up a new server using RAID technology. If one hard drive in the array fails, the data is stored on another drive, preventing data loss. Which of the following business continuity concepts does this explain?

• File backup
• Data restoration
• Fault tolerance
• Restoring access

A user needs to enter text and numbers to produce charts that demonstrate sales figures. Which of the following types of software would BEST complete this task?

• Text editing software
• Visual diagramming software
• Spreadsheet software
• Web browsing software

Which of the following BEST describes the physical location of the data in the database?

• Table
• Column
• RAM
• HDD

A user logs into a laptop using a username and complex password This is an example of:

• biometrics
• multifactor authentication
• least privilege
• single-factor authentication

Given the following pseudocode:

set@count = 1

for @count <10

begin

set @count=@count+1

end

Select @count

Which of the following is the output of the code?

• 1

• 9

• 10

• 11

To establish a theory of probable cause, one technician investigates network issues in the server room while another technician troubleshoots the user’s workstation. Which of the following troubleshooting methodologies is being performed?

• Question the obvious.
• Divide and conquer.
• Duplicate the problem
• Research the knowledge base.

A remote user, who is working from home, requires significant bandwidth to connect to the corporate systems. Which of the following types of Internet service connections would BEST meet the user’s needs?

• T1 line
• Satellite
• Fiber optic
• DSL

Which of the following types of encryption would BEST protect a laptop computer in the event of theft?

• Disk
• Email
• VPN
• HTTPS