IT450 FINAL EXAM
Ch. 6, 7, 13, Appendix G
Multiple choice questions, true/false questions
SQL Expression Null
Subquery (nested query)
Big Data Lecture
1. What are Vs of Big Data?
Volume: It refers to a large amount of data, where data analytics benefit from high
volumes of data where the statistical reliability is better with increased population.
Velocity: It r
Oracle SQL Assignment 3 (Due June 24, 2016)
1. List employees from Department D11 or Department E01 who involve in projects
with estimated mean project staffing greater than 5.
Select lastname, workdept, projname, prstaff
From emp, proj
Oracle SQL Assignment 1 (Due June 24 2016)
1. Change Christine I. Haas's Employee Number to 00 followed by last four digits of
your SS number and list the new Employee Number.
Set empno = 00xxxx
Where lastname = HAAS;
1 record updated
Oracle SQL Assignment 2 (Due June 24, 2016)
1. List employee names, their department names as well as department numbers.
Select lastname, workdept, deptname
From emp, dept
Where emp.workdept = dept.deptno;
2. How many different departments are there in w
Concept Review Unit A
1. Links to other kinds of searches
2. Search Query
3. Higher ranked search results
4. Highlighted keywords in results
5. More pages of search results
6. Link for an advanced search
7. Next link or arrow to move to the n
APPLY IT CHAPTER 1
Define Information Literacy.
Webster defines information literacy as the adoption of appropriate information
behavior to identify, through whatever channel or medium, information well fitted to
information needs, leading to
What princess does Perseus rescue? Andromeda
What creatures are born from the dying Medusa? Chrysaor & Pegasus
Who is the husband of Cassiepea? Cepheus
Because of his associations with the Peloponnese, what god l
Unit A Skills Review
1. Understand Internet search tools.
a. A search query tells whatever tool you are using what information you want.
b. Search engines let you find web pages that have the keywords that you entered
in the search box. After
CHAPTER 4 EXERCISE C:
#8 DETERMINE THE OUTPUT OF THE FOLLOWING PEP/8 MACHINE LANGUAGE PROGRAM IF THE INPUT
IS tab. THE LEFT COLUMN IS THE MEMORY ADDRESS OF THE FIRST BYTE ON THE LINE:
Review Test Submission: ITN 101 - Ch 07
User Joseph Arthur Avery Course Introduction to Network Concepts - Summer 2016 Test 101 - h 07
started 6/24/16 5:31 PM Le submitted 624/16 542 PM se Due Date 6/20/16 1:48 PM
Status Needs Grading
Attempt 8 out of 10
What is X Windows ?
X Windows is considered a network based Graphical User Interface.
The Architecture of the X Windows system is based on what is
referred to as the Clint / Server Model.
The X Windows Architecture is divided into 2 parts: 1) The X Server
Unix System Administration
System Administrator: The person or persons responsible for the upkeep of the Unix System.
Responsibilities of the UNIX System Administrator:
Perform Requirements Analysis
Perform Hardware a
Shell Environment - Each shell process can be considered its own environment.
Shell Variable - a name and an associated value.
Local Variable - a variable declared / created within the environment of the local process.
Global Variable - a va
The Unix Process Structure
When the Unix Shell (Command Interpreter) finds an executable file with the same name as the
command entered on the command line it starts a new UNIX PROCESS.
UNIX PROCESS - the execution of a program by the Unix system
READ - File Access Permissions
Read permissions means the 3 types of users (owner, group, other) can read from a file.
cat > file1
this is file1
chmod 444 file1
* note: give owner read access permissions
ls l file1
* note: owner has read pe
Shell - The Command Interpreter. Interface
between the user and the O/S.
The Shell and Other Utilities
Kernel - Heart of the O/S. A C Program responsible
for controlling computer
What is an Operating System?
A control program that allocates computer resources and schedules
Computer Resources: Hardware: CPU, Memory, disk and tape storage,
printers, terminals, etc.
Scheduled Tasks: Operator Input, file and disk management, me