Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
23 Cards in this Set
- Front
- Back
DBMS and the 3 parts |
Database Management Systems Concept Software application course |
|
RDBMS |
Relational Database Manangement System |
|
Whats largest DMBS? |
Oracle |
|
Largest ERP DBMS? |
Enterprise Rescourse Planning SAP Systems, applications and products |
|
ANSI |
American National Standard Institute |
|
Three lookup Brothers? |
Lookup, Vlookup, Hlookup |
|
Binary? |
Divide by two until remainder count up to get binary code |
|
Requires manunal commit to save but does auto save |
oracle has savepoint and autocommitt for mircosoft sql and access |
|
FTP |
file transfer protocol |
|
HTTP |
Hyper text transmission protocol |
|
5 computer languages |
Machine Assembly Programming Human Natural MAPHN |
|
5 generations of computers |
Vacuum transistors integrated circuits microprocessors artificial intelligences VTIMA |
|
!= |
doesn't equal in sql |
|
= |
cell synchronization |
|
* |
wild card for excel and sql |
|
Space holders |
excel: ? Sql: % |
|
Excel City <> "nyc" |
Sql City <> 'nyc' city!='nyc' or doesn't equal |
|
phishing |
attempt to scquire senstives information such as usernames, passwords and credit card details by masquerading as a trust worthy entity |
|
3 Types of Realtionships amoung tables |
1 to 1 1 to many many to many |
|
TSQL |
Transact SQL and ANSI both microsoft server |
|
primary key |
uniquely identifies the most significant field in a table |
|
Role of OS
|
Managing computer resources provide user inference security computer processes |
|
goal seek |
backwards looks up solution through trial and error |