CATEGORY 1
WHATE ARE THE CHARECTIRISTICS OF DATA?
1. Growing
2.Changing
3.Shared
4.Reliable
5.Fast
6.Searchable
What are the 4 Different Entity's ?
Customer
Product
Envoice
Payment
WHAT DOES SCHEMER DO ?
DEFINES EVERY TERM/STRUCTURE/AND PLAN
WHAT DOES CONSISTENT MEAN ?
TAKE INVALID STATE TO ANOTHERVALID STATE
IS SQL STRUCTURED OR UNSTRUCTURED INFORMATION?
UNSTRUCTURED
WHAT IS DML?
DATA MANIPULATION LANGUAGE
WHAT IS A TABLE?
WELL DEFINED STRUCTURED DATA
HOW MANY PRIMARY KEYS ARE ALLOWD ON A TABLE?
1
WHAT DOES ISOLATED MEAN?
NO ONE WILL SEE CHANGES IN THE DATABASE
WHAT ARE THE STAGES OF DATA BASE?
DATA MODELING/ DATABASE DESIGHN
DATABASE CREATION/ IMPLEMENTATION
OPERATION/ INTERGRATING
MAITNENCE /EVALUATION
WHAT IS RDBMS?
RELATIONAL DATA BASE SYSTEM
WHY DO YOU GENERATE THE INTERNAL INDEX?
TO FIND WHERE YOUR AT
WHATE IS CRUDE ?
CREATE,READE,UPDATE,DELETE
WHAT IS DURABLE ?
EVERYTHING IS CONSISTED AND SAVED
WHAT ARE SOME OF THE SKILLS OF A DBA ADMIN?
PLANNING INSTALL, CONFIG, DB CREATION, SECURITY, MONITERING, PATCHING
IN A COLUNM A PRIMARY KEY MUST CONTAIN WHAT?
UNIQUE VALUES
CAN YOU USE A PRIMARY KEY FROM OTHER TABLES AS A REFRENCE?
YES
WHAT IS SQL?
STRUCTURED QUERY LANGUAGE
SQL IS A LANGUAGE USED TO WORK WITH WHAT?
DATABASES
WHAT DOES DDL MEAN ?
DATA DEFINITION LANGUAGE
DBMS CONTAIN WHAT?
INTERNAL MAP OF DATA
WHAT IS REFRIENTAL INTEGRITY?
DATA THAT IS CONSISTENT WITH ITSELF
WHAT IS ACID ?
ATOMIC, CONSISTENT, ISOLATED, DURABLE
WHAT IS POLYGLOT PERSISTANCE ?
INSTEAD OF 1 PRODUCT USE MULTIPLE PRODUCTS APPLYING EACH TO WHERE IT WILL WORK BEST
WHAT IS A SLA ?
SERVICE LEVEL AGREMENT