CS Study

Video Lecture || DBMS Keys     https://youtu.be/AiedgE6CMEg

SEBI Recruitment for IT Officer Click here for more http://www.sebi.gov.in/sebiweb/other/careerdetail.jsp?careerId=98

Video Lecture : Computer Networks || Part 2 Click Below --

 Video Lecture : Computer Network || PART 1 Click Below Link:

Video Lecture : Boolean Algebra Part 2 Click Below Link - https://www.youtube.com/watch?v=KTXBFqGMl00&list=PLs3a7KVCedy06OUDhUbt6fh3n3u4R3hzj&index=1

Video Lecture- Digital Logic Subject || Part 2 Click below link https://www.youtube.com/watch?v=Uy0Oy2-JGuQ&t=70s

Digital Logic Subject || Part 1 https://www.youtube.com/watch?v=1KaqjVMFWak&t=152s

Boolean Algebra Part-1 https://www.youtube.com/watch?v=5njk7kZe3fg

AGRICULTURE INSURANCE COMPANY OF INDIA invites applications for Scale-1 IT officer

Electronic and Digital systems may use a variety of different number systems, (e.g. Decimal, Hexadecimal, Octal, Binary). A number N in base or radix b can be written as: (N) b = d n-1 d n-2 — — — — d 1 d 0 . d -1 d -2 — — — — d -m

1. To convert the floating point into decimal, we have 3 elements in a 32-bit floating point representation:     i) Sign     ii) Exponent     iii) Mantissa

SQL supports few Set operations to be performed on table data. These are used to get meaningful results from data, under different special conditions. Union UNION is used to combine the results of two or more Select statements. However it will eliminate duplicate rows from its result set. In case of union, number of columns and datatype must be same in both the tables. Example of UNION The First table, ID Name 1 abhi 2 adam The Second table, ID Name 2 adam 3 Chester Union SQL query will be, select * from First UNION select * from second The result table will look like, ID NAME 1 abhi 2 adam 3 Chester Union All This operation is similar to Union. But it also shows the duplicate rows. Example of Union All The First table, ID NAME 1 abhi 2 adam The Second table, ID NAME 2 adam 3 Chester Union All query will be like, select * from First UNION ALL select * from second The result table will look like, ID ...

Software Engineering is  an engineering approach for software development.The basic principle of software engineering is to use structured, formal and disciplined methods for building and using systems.The outcome of software engineering is an efficient and reliable software product.

Constraints are the rules that we can apply on the type of data in a table. That is, we can specify the limit on the type of data that can be stored in a particular column in a table using constraints. The available constraints in SQL are:

Variable is a placeholder (reserved memory block) to store a value of any type. A variable is defined by its name (identifier), type and initialization is optional. Syntax for variable declaration:

Question 1. The postfix form of the expression (A+ B)*(C*D- E)*F / G is? a) AB+ CD*E - FG /** b) AB + CD* E - F **G / c) AB + CD* E - *F *G / d) AB + CDE * - * F *G / ANSWER: a) AB+ CD*E - FG /**

Infix: the operator is in between the two operands. Prefix: operators precede the two operands that they work on. Postfix: operators come after the corresponding operands.

What is PL/SQL? Procedural Language extension to SQL It integrates procedural constructs with SQL

The prime reason behind creation of Java was to bring portability and security feature into a computer language. Beside these two major features, there were many other features that played an important role in molding out the final form of this outstanding language. Those features are :