Preview UP POLICE COMPUTER OPERATOR

1 - INTRODUCTION TO COMPUTER

1 - Introduction to Computer

2 - ENIAC, EDVAC, UNIVAC

3 - Parts of Computer

4 - Storage Devices

5 - What is PS2 Port, Hot and Cold Booting

6- Disable blue arrows icon on folders and files in Windows 10

2 - PC SOFTWARE AND OFFICE AUTOMATION

1 - Introduction To MS - Office And MS - Word

2 - General Computer - MS Word Formatting Options

3 - General Computer - MS-Word Office Button, Bullet and Numbering

4 - Style, Find and Replace in MS Word

5 - Table, Picture, Clip Art and Shape in MS-Word

6 - Smart Art, Chart and Header and Footer in MS - Word

7 - Insert and Page Layout Tab in MS - Word

8 - Reference, Mailing and View Tab in MS - Word

3 - WORKPLACE PRODUCTIVITY TOOLS

1 - Introduction to Excel

2 - Relative and absolute addresses in ms excel

3 - How to Generate Random Data in Excel

4 - Countif in Excel

5 - Logical Formulae in Excel

6 - Excel Overview

7 - Text Formula in Excel

8 - MS Access Query and Macro

4 - THE INTERNET

1- Encryption And Its Types

2 - Practice Problem on Encryption

3 - RSA Algorithm And Transmission Impairment

4 - Cyber Security (Malware And Virus)

5 - Cyber Security, Worms, Trojan Horse, Spam etc.

6 - List Of Virus, Antivirus, Cyber Attack, Identity Theft, Hackers, Crackers Etc

7 - Cyber Scams, Biometrics, Crowdsourcing

8 - Net Neutrality, Botnet, Web Beacons And Mobile Communication

5 - EMERGING TECHNOLOGIES AND WEB PUBLISHING

1 - Intro to HTML

2 - Attributes of Elements

3 - Table, List Frame From

4 - Intro to CSS

5 - Intro to Java Script

6 - Intro to XML

7 - Loops in VBScript, function and sub procedure, array

6 - BOOLEAN ALGEBRA

1 - Number System Class - 1 (Weighted And Unweighted Code, Binary Tricks)

2 - Number System Class 2 (Conversion and BCD Code)

3 - Number System Class 3 (Missing Base and Terms, Gray Code)

4 - Excess -3 Code and Complements of code

5 - Find Missing Base

6 - Find Missing Terms

7 - Negative Number Representation

8 DE Booth Algorithm

9 DE Boolean Algebra Part 1

10 DE Digital Electronics Simplification of Boolean Expression

11 DE Canonical Form of Boolean Expression

12 DE Dual, Self Dual and Complement of a Boolean Expression

7 - DBMS

1 - DBMS - Introduction to DBMS and Functional Dependency (राजस्थान कंप्यूटर अनुदेशक - Class 1)

2 - DBMS (Closure Set of Attributes, Super Key, Candidates Keys and Primary Key)

3 - DBMS ( How to Find the Candidate Keys of a Relation)

4 - Normal Form (1 NF, 2 NF, 3 NF, BCNF)

5 - Normalization Qus and 4 NF

6 - Lossless and Lossy Decomposition in DBMS

7 - Transaction State and Transaction Properties

8 - Schedules in DBMS

9 - Conflict and View Serializability Practice Questions

10 - Concurrency Problems and Non-Serializable Schedule

11 - Recoverable Schedule and Concurrency Control Protocols

12 - Timestamp and Validation Based Protocols, Primary Indexing

13 - Indexing Numerical, Secondary, Clustering and Multiple Indexing

14 - Database Terminology - Instance and Schema

15 - Database Model - Hierarchical, Network, Relational, E-R Model

16 - DBMS (E-R Diagram Components And Relationship)

17 - Converting E-R Diagram into Tables

18 - Introduction To Relational Algebra Operators

19 - Union, Intersection, Minus, Rename, Division Operators of Relational Algebra

20 - Relational Calculus And It's Type

21 - Introduction to SQL - DML, DDL, DQL, TCL, DCL, Data Types etc

22 - SQL Queries - select, insert where, delete, drop, truncate, update etc.

23 - SQL Queries - in , between, or , and, not etc

24 - SQL limit, like, aggregate function

25 - SQL Group by, Having, Subquery and String Function

26 - Numeric function in SQL

27 - SQL Constraints - NOT NULL, Unique, primary key, default, check

28 - SQL Join (Natural Join, Inner Join, Equi Join, Outer Join, Semi Join, Anti Join)

29 - SQL Constraints - Foreign Key, on update cascade, on delete cascade, super key

30 - Backup and Restore MySql Database, Create table from another table

31 - Null function, show user details, auto increment and view

32 - case, date and time function in sql, database transaction

33 - ACID Properties and State of transaction, create new user, change password, grant, revoke

34-Transaction in MySql - TCL

35 - Practice (MCQ, T_F and Fill in the blanks) of MySql, Level of Abstraction and Schema

36 - Data Warehouse, OLAP, OLTP, Data Mining and Data Mart

37 - OLTP Vs OLAP, Data WareHouse

8 - Data Structure

1 - New DS - Introduction to DS and Algorithm

2 - New DS - Types of Algorithms

2.1 - Types of Algo PDF

3 - New DS - Types of Algo Part 2

3.1 - Types of Algo PDF

4 - New DS - Asymptotic Notation

5 - New DS - Asymptotic notation part 2

6.1 - DS New - Master Theorem Assignment

6 - New DS - Recurrence Function - Master Theorem

7 - DS New - Linear and Binary Search

8 - New DS - Introduction to Sorting Algo, Bubble Sort

09 April DS Class @ 08:15 PM

10 - New DS - Radix, Bucket and Counting Sort

11 - New DS - Selection and Insertion Sort

12 - New DS - Merge Sort

13 - New DS - Address Calculation in Array

13.1 - Array Address Calculation Questions PDF

14 - New DS - Linked List

15 - New DS - Types of Linked List

16.1 - Reverse a singly linked list

16.2 - Linked List Practice Problems (1)

16.3 - Linked List MCQ

17 - New DS - Introduction to Stack

18 - New DS - Polish Notation in Stack

18.1 - Polish Notation in Stack

19 - New DS - Introduction to Queue

20 - New DS - Types of Queue

DS 1 Introduction to DS

DS 2 Address Calculation in Array

DS 3 Heap & Tree

DS 4 Binary Tree and Its Types - Data Structure

DS 5 Graph & Spanning Tree

DS 6 Selection Sort

DS 7 MST Shortest Path

DS 8 String Matching Eulerian Graph

DS 9 Hashing

DS 10 Rehashing and degree of graph

DS 11 Pre, In and Post Order

DS 12 Asymptotic Notation

13 - DS Asymptotic Notation Part 2

14 - Row Major and Column Major Array Address

15 - Stack and Polish Notation

16 - Queue in DS

9 - COMPUTER NETWORKS

1 - Introduction And Type Of Network

2 - WWW, ISP, URL, DNS Tec.

3 - Server And Topology

4 - Network Model

5 - OSI Model Layers

6 - Application And Presentation Layer Protocol

7 - Protocols and MAC Address

8 - Network Device (Repeater, Hub, Bridge, Switch, Router)

9 - Modem, AM, FM, PM

10 - RJ-11, RJ-45, Twisted Pair And Coaxial Cable

11 - Fiber Optics, Unguided Media (Radio Wave, Microwave, Infrared)

12 - ALOHA

13 - ALOHA (Pure And Slotted Aloha Questions)

14 - CSMA_CD And Multiplexing

15 - Reservation, Token Passing, Polling, ARQ

16 - ARQ And Hamming Code

17 - Hamming Weight, Hamming Distance, Hamming Rate

18 - Error Detection Techniques

19 - CRC, Bit Rate, Baud Rate

20 - Bit Rate, Baud Rate Questions, Nyquist And Shannon Theorem

21 - IP4, Range, Host ID, Network ID

22 - Subnet Mask, CIDR

23 - Subnet, Broadcast, Host ID Questions

24 - What is IPv6 & its Notation

25 - Switching Technology

26 - X.25, Frame Relay, STP, RSTP

27 - Token Ring

28 - Mobile Computing

10 - PREVIOUS YEAR QUESTION PAPER SOLUTIONS

Preview - UP POLICE COMPUTER OPERATOR