Skip to main content

Test Your Knowledge - 4

Prove that 25 DEC = 31 OCT
Labels:

Comments

  1. Tech BuddyJuly 11, 2018 at 9:04 AM

    OCTAL and DECIMAL are two different numbering systems. 25 in DECIMAL (the number system used by humans) is equivalent to 31 in OCTAL.

    Check: https://www.wikihow.com/Convert-from-Decimal-to-Octal

    ReplyDelete

Post a Comment

Popular posts from this blog

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 ...
Post a Comment
Read more

Anomalies in Database Manipulation

  Normalization in database design is a process used to organize data to reduce redundancy and improve data integrity. It involves dividing a database into multiple tables and define relationship between them. There are several types of anomalies that can arise when a database is not normalized. The three main types of normalization anomalies. 1.       Insertion anomaly An insertion anomaly normally occurs when you can’t insert data into the database without the presence of other data.   Students StudId StuName Course Instructor 1 Jack Math Prof. Raghu 2 Jim Science Prof. Radha 3 Harry Computer Science Prof. Venkat 4 Henry Digital Marketing Prof. Jasmine 5 Rose Finance Ms. Smith   The colleg...
Post a Comment
Read more

Everything about computers

Hi, I am quite excited to start the technical part of my blog! I hope so are you! Let's start with the Abc of computers that we all find a bit hard to put in to words. These are my own definitions made really simple and easy to understand! Computer:   An electronic device that computes, stores, processes , manipulates and displays the data. Coined from the term "compute", means to calculate. Facts:  First ever computer was used for mathematical calculations. Founder: Charles Babbage - The Father of computers - invented the first ever mechanical computer called "Babbage's Analytical Engine"! Features of a Computer / Advantages of computer over a calculator: Speed, Accuracy, Storage, Multi tasking, Diligence (and many more). A computer comprises of Software and Hardware (all the physical - internal or external components/peripherals that are connected to or a part of computer ex. Keyboard, Mouse, Cabinet, Joystick, USB - pen drive etc. that we c...
2 comments
Read more