Conversions
Convert 142 (Dec) into a Binary Octet
10001110
Can a standard user account install a store App on a computer?
yes
Procedures and Functions are used for reusable blocks of code, which does not return a value?
Procedures do not return a value
Paul was denied permission to the NHS database by Ms. Haim, but Ms. Battle then Granted him permission to that database. Does Paul now have access?
NO
Are modern PC's processing speeds measured in Megahertz or Gigahertz?
Gigahertz
An odd number will have what characteristic when written in binary format?
A 1 in the last column (1 column)
Why can't a store App damage your OS?
it runs in a sandbox
Name a pro and a con of Compiled Languages.
Pro: Fast Speed
Con: Platform Specific
Describe the difference between Data Definition Language and Data Manipulation Language.
DDL: includes commands that add to or modify the structure of the database (CREATE, ALTER TABLE, DROP, CREATE INDEX)
DML: includes commands that allow you to insert or update records and extract information from records for viewing (a query) (UPDATE, DELETE FROM, SELECT, INSERT INTO)
How many data types are there?
Bonus: Name one and an example of it
5
Integers, Floating Point, Boolean, Characters, Strings
What format would you convert a number to so that it is expressed in the least amount of figures?
Hexadecimal
How does a Client Access License work?
it is installed on a network server for authorized use.
Variables and Constants are both identifiers, give examples for each.
Variable: Username
Constant: Screen Dimensions
Give an example of a Primary Key and Foreign Key scenario.
Using a Student ID Number (Primary Key) to look up that student's GPA (Foreign Key)
What does the following operator mean: !=
is not equal to
Convert 180 (Dec) to Hexadecimal notation
B4
You get to try Spotify free for the next 3 months, is this an example of freeware, shareware, or open source?
Shareware
An Array and Vector are examples of Containers, give an example for each.
Array: Zip code
Vector: Name
I want to delete a table from my database, what DDL command will I use?
DROP
When using a keyboard in a different language, what encoding system would you use?
Unicode
Decimal Notation is known as: Base #
Binary Notation is known as: Base #
Hexadecimal Notation is known as: Base #
Decimal: Base 10
Binary: Base 2
Hexadecimal: Base 16
Is a Personal Information Manager an example of Productivity software, Collaboration software, or Business Software?
Collaboration Software
Describe Query Language, Assembly Language, and Markup Language.
Query Language: Retrieves data from a database
Assembly: Shows machine code in human readable text
Markup Languages: Tag documents to define structure and meaning
In a two-tier application architecture model, what device holds the database?
The server
Give an example of when you would need a Copyright, Trademark, Patent, and Digital Rights Management.
Copyright: Book, Movie script, etc.
Trademark: Company name or logo
Patent: Invention
DRM: EBook, etc.