click below
click below
Normal Size Small Size show me how
Software Dev Fund 2B
MTA - Software Development Fundamentals 2B
Question | Answer |
---|---|
connection configuration | a correct setup for a program to connect to a database includes: •the name of the database •the drive location of the database •the type of database •the port to connect through These all must be the same in order to pool the connections |
fields | the column names in a database correspond to each cell of data in a row; each cell is associated with a particular named column of data such as for a phone number or customer name |
cardinality | means the uniqueness of the data in a column or database; social security numbers are supposed to have high cardinality, so are email addresses and id's for account logins |
one-to-one relationship | unique pieces of data are supposed to refer to only one unique record, such as a customer account being associated with only one email address or a credit card number only supposed to be used by one account holder; it is NOT one-to-many or many-to-many |
primitive data types | byte, short, int, long, float, double, char, boolean (or bool in C#) are all primitives and are also called value types (C# capitalizes these) |
String | is an object, as a program runs any String is ALWAYS considered a reference type NOT a value type; in C# String can be string without the capital 'S' |
declaration | is the announcing of a new variable, it is done like: Thing thing1 = new Thing( ) The data type is always announced before the name of the variable for it |
instantiation | is the actual creating of a new copy of an object, it is done with the "new" keyword and ALWAYS includes the call to the constructor method immediately following the keyword "new"; the ONLY exception is for creating a new String |
semi-colon | is used at the very end of statements of code |
stack | an area of RAM memory where primitive variables are stored when they are initially declared in a local scope such as in a method or a loop; an example: public updatePosition(){ int newX = x + 10; } newX is saved in the stack area of memory |
heap | area of RAM memory where global variables are stored whether primitives or objects and where all object variables are stored whether local or global. Example: public makeLion( ){ Lion biglion1 = new Lion(); } biglion1 is stored in the heap area |
loop conditions | for a "while" loop or a "for" loop the condition must be met for the loop to actually process through an iteration; if it is not met the loop will cease iterating |
iteration | a single cycle through a repetitive process that could go through many cycles before finishing |
Message Queuing | Some programs need to talk to each other; Microsoft uses this to allow those messages to have: •guaranteed delivery •efficient routing, •security •prioritization it is particularly useful when needing to communicate with systems that are off-line |
client-side | any time you are developing for the display or for visual elements in a web application you are dealing with this area of programming |