Database and SQL
Resume
Data Structures
Bugs and Errors
Terminology
100

A collection of data arranged for ease of speed of search and retrieval.

Database

100

A letter created before you write your resume. Typically sent to HR of the company in question.

Cover letter

100

data structure best used to represent a 2D matrix?

Array

100

(C) int num = 5

No Semicolon

100

block of code which only runs when it is called

Function

200

Code that is developed to manipulate data in a database.

Structured Query Language (SQL)
200

When your GPA is less than 3.0

Do not include it

200

LIFO data structure

Stack

200

(C++) 

void setup()

{

  pinMode(GREEN, OUTPUT);

  pinMode(YELLOW, OUTPUT);

  pinMode(RED, OUTPUT);

}


void loop()

{

  green_light();

}

GREEN, YELLOW, and RED here not initialized.

200

a process or set of rules to be followed in calculations or other problem-solving operations, especially by a computer

Algorithm

300

is a column in the database who is the unique, not null identifier for a record.

Primary Key

300

A section of your resume where you show off your personal software or hardware projects and abilities realted to these projects. 

Skills and Abilities

300

In this data structure an element with high priority is served before an element with low priority

Queue

300

The error produced when print(1/0) is executed in Python

ZeroDivisionError

300

a classification that dictates what variable or object can hold in computer programming.

Data type

400

a step-by-step process of organizing data to establish relationships between tables to eliminate redundancy and inconsistent dependency.

Normalization

400

A free, common website that allows you to learn new programming langauges and concepts.

Codecadamy

400

Which data structure is more efficient: an Array or linked list?

Neither, both have their advantages and disadvantages

400

int GREEN = 13;

int YELLOW = 12;

int RED = 11;

void setup()

{

  pinMode(GREEN, OUTPUT);

  pinMode(YELLOW, OUTPUT);

  pinMode(RED, OUTPUT);

}

void loop()

{

  digitalWrite(GREEN, LOW);

  digitalWrite(YELLOW, MEDIUM);

  digitalWrite(RED, LOW);

}

No Medium

400

defines a new data type with more than one member.

Structure or Class

500

Will this give errors, if so where? FULL POINTS FOR LOCATION, -500 OTHERWISE

INSERT INTO FACULTY ('123',  'Dr.Pyzdrowski, pyzdrowski@calu.edu, 357, 'EBERLY')

(Perhaps this is a trick question... unlikely, but possible)

The '123' is a string, it should be a number.

500

A system that companies use to scan through resumes to check for key words.

ATS resume scanner

500

A type of binary tree where the value of each node is greater than or equal to the value of its parent node

MinHeap

500

(C) 

struct user()

{

    int age;

    int gpa;       

}

Missing semi colon after }

500

smallest sequence of programmed instructors that can be manages independently by a schedule, which is typically a part of the operating system.

Threading

M
e
n
u