Module 2 Flashcards
Arithmetic operator?
A symbol used to carry out a computation.
What are the arithmetic operators?
+, = /, *, %
What are the comparative operators?
> =, ==, !=
What are the evaluation operators?
and, or, not.
Expression?
A combination of values that are computed by the computer.
Operand?
The number that is being dealt with in a methematical operation.
Ex: 5 + 6. 5 and 6 are the operand and = is the operator.
Data type?
The data type of a data says two things about it:
- The kind of information.
- The thing you can do with it.
Subscripts?
Text written below a line.
What subscripts can be used for?
To indicate the base number system.
What are the benefits of the hexadecimal number system?
- You can display large numbers with fewer characters.
- Easily translatable into binary.
For what hexadecimals are commonly used in computers?
To specify the name of a computer memory address.
Number system formula?
DIGIT * BASE ^ position.
State?
The condition of a person or thing.
Stateless program?
A program that don’t remenber prior events.
Ex: a longin page that don’t remember your username.
Stateful program?
It will have a mechanism for keeping track of events as the program is used.
Bit pattern?
A particular layout of bits used to represent numbers, character, etc.
Ex: 100 0001 represent the letter “A”.
ASCII?
American Standard Code for Information Interchange.
A standard chart that represent characters using binay codes.
How many digits ASCII uses to represent each character?
7.
UNICODE?
A standard for representing letter and symbols in computers for all languages across the world.
Objects have…
State and behaviour.
Class?
Describe the states and behaviours of a potential object.
Database?
An collection of related data usually organized into tables.
Tables?
Data structure made up of rows and collumns.
Relational Database?
A database that define a some relation between its tables. This relation affects how the data in the tables is used.
Ex: a table of students names could be related to a table of addresses.
RDBMS?
Relational Database Management System.
A type of computer program used to manage relational database.
Query?
A specific instruction to a computer to search through a database and collect all data that matches a certain criteria.
SQL?
Structured Query Language.
A language to monitor and handle databases.
What SQL can do?
Edit, change, modify, delete, etc.
T-SQL?
Transact-structured query language.
A language Microsoft made to add additional functionality to SQL.
SQL server?
Short for Microsoft Structured Query Language Server.
Is a RDBMS developed by Microsoft.
SQL vs SQL server?
SQL is a language and SQL server is a program.
GUI?
Graphical User Interface.
