DBMS Types Data Independence Three schema architecture DBMS users Dr.E.F.Codd’s rules for RDBMS (0-12) ER Model SQL DDL – CREATE, ALTER, DROP, TRUNCATE, RENAME DML – INSERT, UPDATE, DELETE DCL – GRANT, REVOKE, CREATE USER, DROP USER TCL – COMMIT, ROLLBACK, SAVEPOINT DATATYPES, OPERATORS(ARITHMETIC,RELATIONAL) CONSTRAINTS (PRIMARY KEY, FOREIGN KEY, NOT NULL, UNIQUE, CHECK) WHERE CLAUSE ORDER BY ASC | DESC DISTINCT GROUP BY - HAVING FUNCTIONS 1. SINGLE ROW FUNCTIONS(UPPER,LOWER,SUBSTR,INITCAP,LENGTH,TRIM,LTRIM,RTRIM) 2. AGGREGATE FUNCTIONS(MIN,MAX,SUM,AVG,COUNT) 3. NUMBER FUNCTIONS(ROUND,CEIL,FLOOR,ABS,MOD,SQRT,POWER) 4. DATE FUNCTIONS(TO_DATE,ADD_MONTHS,TO_CHAR,NEXTDAY,MONTHS_BETWEEN, SYSDATE) 5. NULL FUNCTIONS(NVL,NVL2,COALESCE) OPERATORS IN NOT IN BETWEEN AND IS NULL LIKE, NOT LIKE PATTERN MATCHING IS ...
The number system that we use is Decimal (Deca means 10 - there are 10 digits from 0-9).
ReplyDeleteThe language used by computers is binary ( only two - 0 and 1).
So, 10 (that is 1 followed by 0, is binary equivalent of decimal number 2).
So the above statement is right. Reason: 10 in binary = 2 in decimal