Flashcard: ITF Mastery Exam

Front

You have just built a brand new computer, and you need to purchase a monitor that will support widescreen 4K movies. Which of the following resolutions supports this need? 1920 x 1080, 3840 x 2160, 1920 x 1200, 1600 x 900

Back

3840 x 2160

Answer explanation

The resolution 3840 x 2160 is known as 4K UHD, which is ideal for widescreen 4K movies. The other options do not meet the 4K standard, making 3840 x 2160 the correct choice.

Front

A business has come up with a new logo for the company and they want to protect the logo as part of their brand. Which protection should they use?

Back

Trademark

Answer explanation

A trademark protects logos, symbols, and brand names, making it the appropriate choice for safeguarding a company's new logo. Copyright protects artistic works, while patents cover inventions, and intellectual property is a broader term.

Front

Which kind of connector is pictured here?

Back

USB

Answer explanation

The connector shown is a USB, commonly used for data transfer and charging devices. RJ-45 is for network cables, NEMA 5-15R is a power outlet, and LC/SC are fiber optic connectors, making USB the correct choice.

Front

Which SQL CREATE command only requires one parameter? Options: CREATE INDEX, CREATE VIEW, CREATE DATABASE, CREATE TABLE

Back

CREATE DATABASE

Answer explanation

The CREATE DATABASE command only requires one parameter, which is the name of the database. In contrast, CREATE INDEX, CREATE VIEW, and CREATE TABLE require additional parameters such as columns and definitions.

Front

Device needed to convert coax cable signal to data for a computer.

Back

Modem

Answer explanation

A modem is required to convert the coaxial cable signal into data that a computer can understand. It acts as a bridge between the Internet service and the user's device, making it the correct choice.

Front

Process involving information stored in a database, where the database is hosted, and how clients can access the data.

Back

Storage

Answer explanation

The correct choice is 'Storage' as it encompasses the information stored in a database, its hosting location, and client access methods, which are all critical aspects of database management.

Front

Which SQL command can be used to import the most recent database backup to fix a corrupted relational database?

Back

RESTORE

Answer explanation

The correct command to restore a corrupted database from a backup is 'RESTORE'. The 'INSERT INTO' command is used to add new records, not to recover a database.

Front

Which kind of system software tells the computer how to communicate with peripherals, such as a printer or scanner?

Back

Device drivers

Answer explanation

Device drivers are specific types of system software that enable communication between the operating system and peripherals like printers and scanners, allowing them to function correctly.

Front

What is the general purpose and use of software?

Back

Create information from data

Answer explanation

Software processes data to generate information, making it easier to understand and use. Thus, the correct choice is 'Create information from data', as this reflects the primary function of software.

Front

Phillip, a programmer, needs a program to work on multiple platforms. Why choose an interpreted language?

Back

An interpreted language does not require code to be compiled into bytecode.

Answer explanation

An interpreted language does not require compilation into bytecode, allowing for easier cross-platform execution. This flexibility is crucial for programs needing to run on multiple platforms without extensive modifications.