itf+ Test Prep errors FULL LENGTH TEST SET 13

You are examining a database to determine if any records have been deleted. How are deleted records marked?

#Deleted-yes ? ?Deleted ######

A PID identifies a process that is running. Which of the following is not a possible PID?

1040 99 419 54-40-yes

Which of the following crontab entries would run a command at 2:15 a.m. every Sunday?

2 15 * * 7 15 2 0 * * 2 15 * 0 * 15 2 * * 0-yes

Which of the following characters is used to end an SQL statement?

;-yes . ! '

You are creating an SQL database for a car rental firm and want to make sure the minimum age for the renter is at least 25 and that the age cannot be null (no value). Which of the following SQL statements is correct?

AGE INT TEST AGE>=25 AGE MUST BE (>=25) AGE INT NOT NULL ASK FOR (ID >=25) AGE INT NOT NULL CHECK (AGE>=25)-yes

You need to make a new data database. What command would you use to make a new data structure?

COPY OLDDATABASE nameofolddatabase TO nameofnewdatabase; BUILD DATABASE nameofdatabase CREATE DATABASE nameofdatabase-yes MAKE DATABASE nameofdatabase

You are preparing to perform a backup while the database is running. Which of the following backups are you preparing to perform?

Cold backup Hot backup-yes Image backup Logical backup

You are preparing to reuse a table structure but need to remove the data from it. Which of the following commands would you use in SQL?

DELETE REMOVE TRUNCATE-yes KILL

Which of the following refers to how the structure of a database is created?

Data composition Data definition-yes Data truncation Data deduplication

You have connected a hard disk to your macOS laptop. Which utility will display drive information such as file system?

Device Manager Disk properties Disk Utility-yes Cron

Your organization is using a script created in Java to access a database. This is an example of which of the following?

Direct access JavaScript access User interface access Programmatic access-yes

In the process of turning data into information, which of the following comes first?

Make decisions influenced by the data. Gather data.-yes Analyze data. Ignore data that conflicts with your feelings.

Which of the following is used to extract data from a database in a readable format according to a user's request?

Query-yes Data manipulation Data definition language (DDL) Data exfiltration

What does a document database store?

Semi-structured data such as XML or JSON-yes Only nonstructured data Integers and strings Conditionally structured data

To add a character that is not on the keyboard using Windows, which of the following methods can you use?

Use KCharSelect. Hold down the Ctrl key and enter the code from the number pad. Use Character Viewer. Use Character Map.-yes

A task is running and needs to be shut down. Which of the following pairings of operating system and method are correct?

Windows - Properties sheet Linux - crontab macOS - Activity Monitor-yes Windows - tasklist

Your client is downsizing to a smaller office but has many years of paper records that need to be accessed quickly when needed. Which type of software should you discuss with your client?

Word processing Resource management Database Document management-yes

You have downloaded the 32-bit version of a driver file for your 64-bit Windows system. Which of the following will take place?

Your computer will use the driver file without any problems. Windows will upgrade the driver. Windows will run the driver in 32-bit compatibility mode. Windows cannot use the driver.-yes

Which term refers to the structure of a database as described either in text or graphically?

big data data analytics data mining schema-yes

Cron is an example of a Linux ________.

daemon-yes process schduleer app

Your client has sent over a Gantt chart. Which type of app produced it?

emr project management-yes accounting employee scheduling

Your manager asks you to create a single compressed file from a half-dozen photos on a flash drive. Which of the following utilities would you use on a Linux system?

format disk utility zip compression gzip-yes

You need to make a directory (folder) one level down from the current folder from the console/command line. Which of the following commands is correct in Linux or macOS?

md directoryname rmdir directoryname mkdir /directoryname mkdir directoryname-yes

A key-value structure is used by which type of database?

no sql-yes proprietary sql oracle

When a file is changed, saving the file is an example of which activity?

output-yes processing input storage

You are preparing an organization chart for a proposed business reorganization. Which of the following types of apps are designed to do this?

paint collaboration visual diagramming-yes office suite

A field is represented by a _______ in a table.

row cell column-yes array

As you use a barcode reader to check in new products, you are performing ______________.

storage input-yes output processing

You need to update a driver in Windows. Which utility would you use?

task manager activity monitor device manager-yes spotlight