DBMS CHECKLIST

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 NOT NULL

AND, OR, NOT

EQUALS, NOT EQUALS

SET OPERATORS – UNION, UNION ALL, INTERSECT, MINUS

 

JOINS – SELF JOIN (INNER JOIN), INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, CROSS JOIN)

VIEWS

SEQUENCE

INDEX

ANY,ALL

TRANSACTION – ACIDA - SAVEPOINT