Intro to IT Final Exam

1101

Binary form of the decimal number 13

Unicode goes beyond ASCII and covers characters from many languages and symbols

How Unicode compares with ASCII

Information

Data that has been processed and given context so that it is useful for a decision

Input, processing, storage, and output

The four basic functions of a computing system

About 400 songs

Number of 5 MB songs that fit on a 2 GB flash drive (1 GB is about 1,000 MB)

To keep frequently used data close to the CPU so it waits less on slower RAM

Purpose of the small amount of very fast cache memory in modern CPUs

Rendering 3D graphics, training neural networks, and running many similar calculations at the same time

Tasks well suited to a GPU

More cores do not always make a single-threaded program faster, because one thread cannot use the extra cores

Effect of more CPU cores on a single-threaded program

Adding more RAM

Most direct upgrade for a 4 GB laptop that slows down when many apps are open

Registers, cache, RAM, SSD, HDD

Storage ordered from fastest to slowest

It runs before the operating system is loaded

When firmware (BIOS or UEFI) runs during startup

Do not click the link; check the sender address, then report it or confirm through the official IT channel

Best response to an urgent email demanding your password to avoid account lockout

Using a unique password for each account, turning on multi-factor authentication, and using a password manager

Good authentication practices

Other people on the network cannot easily read the contents of your traffic

Visiting a site over HTTPS on public Wi-Fi

Filter network traffic by rules, allowing or blocking connections

Main job of a firewall

Giving a student worker read-only access to only the records their job needs

Best example of the principle of least privilege

Recent backups kept offline or off-site, disconnected from the laptop

Preparation that lets you recover from ransomware without paying

.card p

CSS selector that targets only paragraphs inside an element with the class card

A <link rel="stylesheet" href="style.css"> element
B) A <style> element
C) A style attribute on an element

Valid ways to apply CSS to a web page

Prints 53 then 2

Output of let x = "5"; let y = 3; console.log(x + y); console.log(x - y);

false, because === compares both value and type

Result of 5 === "5" in JavaScript

404 (Not Found)

HTTP status code returned when a requested URL does not exist on the server

Adding the viewport meta tag, using CSS media queries, and using flexible units such as percentages or rem

Techniques that help make a page responsive on different screen sizes

Isolation

ACID property where concurrent transactions appear to happen one fully before the other

Cara, Ana

Using the students table (1 Ana 3.9, 2 Ben 3.1, 3 Cara 3.5, 4 Dev 3.1), what does this query return, in order?

SELECT name FROM students WHERE gpa >= 3.5 ORDER BY name DESC;

One row: 3.1 and 2

Using the same table, what does this query return?

SELECT gpa, COUNT() FROM students GROUP BY gpa HAVING COUNT() > 1;

UPDATE is DML
SELECT is DQL
COMMIT is TCL

Which statements correctly pair an SQL command with its category?

It must match an existing primary key value in the referenced table, or be NULL if the column allows NULL

Rule that a foreign key value must follow