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 ...
Solution:
ReplyDelete1 a. String (because it is in double quotes. If there were no double quotes it would be boolean)
b. It's a reference type. Not a data type. It refers to the type of data it is referring to.
2. 1 (Right = true = 1)
3. When a thread completes execution or a higher priority process comes in to existence and kills the thread.
1. a
ReplyDelete2. Right
3. whenever a thread completes its execution
3rd one is right. :)
Delete