A OAVS Computer mock test from Toppersexam.com is a practice paper based on the latest exam pattern and syllabus, designed to help you assess your preparation level.
New Vacancy 2026
OAVS Computer 2026 Notification, Online Form & Exam Date
OAVS Computer Vacancy 2026 provides a golden opportunity for aspirants seeking stable government jobs. Interested candidates can apply online for the posts after verifying the official eligibility criteria, age limit, and educational qualifications. Ensure you track the application deadlines and stay updated with the latest OAVS Computer 2026 recruitment news for a smooth registration process.
To crack the OAVS Computer 2026 exam, understanding the detailed syllabus and exam pattern is mandatory. Aspirants should focus on strategic planning and rigorous time management for each selection phase. Boosting your speed through online mock tests and regular practice is the key to securing a high score in this competitive recruitment. For premium study material and practice sets, follow the expert curated resources on toppersexam.com.
To crack the OAVS Computer 2026 exam, understanding the detailed syllabus and exam pattern is mandatory. Aspirants should focus on strategic planning and rigorous time management for each selection phase. Boosting your speed through online mock tests and regular practice is the key to securing a high score in this competitive recruitment. For premium study material and practice sets, follow the expert curated resources on toppersexam.com.
OAVS Computer Free Mock Test
Crack the OAVS Computer Mock Test 2026 with the help of an online Test series or a free mock test. Every sample paper in the OAVS Computer Exam has a designated weight, so do not miss out on any paper. Prepare for the OAVS Computer mock test and check your test scores.
OAVS Computer Teacher Syllabus 2027, Exam Pattern
OAVS Computer Teacher Syllabus 2027, Exam Pattern, Exam Date 2027
Detail Information about OAVS has published notification 2027 for the recruitment of OAVS Computer Teacher vacancies. Those Candidates who are Interested to the following vacancy and completed all Eligibility Criteria can read the Notification & Apply Online. In this page we provide the Complete Syllabus of this Recruitment with Latest Update Exam Pattern and the Exam Date also.
OAVS Computer Syllabus 2027 - Overview
| Exam Name | Odisha Adarsh Vidyalaya Recruitment 2027 |
| Conducting Body | OAVS (Odisha Adarsh Vidyalaya Sangathan) |
| Post Name | Computer Teacher |
| Total Post | 70 |
| Selection Process | Written Exam, Interview |
| Category | Syllabus and Exam Pattern |
| Job Location | Odisha |
| Official Website | oav.edu.in. |
OAVS Computer Teacher Syllabus 2027
English :
1. Synonyms
2. Antonyms
3. Prepositions
4. Sentence Completion
5. Active and Passive Voice
6. Spelling Test
7. Spotting Errors
8. Passage Completion
9. Substitution
10. Sentence Arrangement
11. Transformation
12. Idioms and Phrases
13. Sentence Improvement
14. Para Completion
15. Joining Sentences
16. Error Correction (Underlined Part)
17. Error Correction (Phrase in Bold)
18. Fill in the blanks
Odia Language :
1. Spot the error
2. Fill in the blanks
3. Synonyms
4. Antonyms
5. Spelling/ detecting mis-spelt words
6. Idioms & Phrases
7. One word substitution
8. Improvement of sentences
9. Active/ passive voice of verbs
10. Conversion into direct/ indirect narration
11. Shuffling of sentence parts.
Current Affairs :
1. Sports
2. Awards
3. Politics
4. Finance and Banking sector
5. International happening, etc
Reasoning :
1. Series
2. Ranks
3. Direction
4. Arrangement
5. Coding
6. Decoding
7. Analogy and Classification/Odd Pair
8. Syllogism and Statement Conclusion.
Non-Verbal Reasoning :
1. Figure Formation
2. Dice
3. Triangle
4. Rule
5. Detection
6. Images
7. Completion of Pattern
8. Mirror Images
9. Figure Matrix and Paper Folding, etc.
Concerned Subject (Computer) :
Fundamentals of Information Technology
Computer:
Block Diagram of elements of digital computer-their functions.
Memory, CPU, I-0 devices, Secondary storages, Magnetic Tape, Disk, CD-ROM.
Other recent developments-Scanners, Digitizer, Plotters.
Hardware and Software. Micro, Mini and Main-frame computers-their features.
Representation of Data:
Binary, Octal, Hexadecimal, BCD, EBCDIC, ASCII Conversions. Simple Additions, Subtractions, Multiplications, Divisions (in Octal and Hexadecimals).
Boolean Algebra:
Algebra Rules and DeMorgans rules. Simplification of equations-simple equations. Logic Circuits-AND, OR, NANO, NOR, Exclusive OR and NOR Truth tables. Gated flip-flops, Registers, Accumulators.
Introduction to 8086/8088 microprocessors-architecture Base-Data, Address, Control. Introduction to 80286, 80386 and Pentium chips.
Software:
Introduction to Programming, Flowcharts and Algorithms. System application software, firmware machine, Assembly, and Higher Level Languages, Stored program Concept. MS Office Packages.
Operating System-Introduction:
Process management-FCFS, Round Robbin, Priority based. Memory management-segmentation, paging, virtual memory. I-0 management-concept of 1-0 port. File management-FAT, file handling functions. Software and hardware interrupts, I/0 and Memory based Addresses, DMA channels.
File:
Concept of file. File organization and accessing techniques-Indexed, Line sequential, Hashed. File handling functions : Sorting, Merging, Indexing, Updating
Instructions and Addressing Techniques: Instruction execution cycle. Direct, Indirect, Relative, Paging, Indexed
Broad view of Operating Systems: MS-DOS, UNIX, MS-WINDOWS
Basic Concept of Networking and Data Communications:
Introduction to LAN and basic communication concepts. OSI 7 layers, Topologies, Protocols, Ethernet, Arcnet, TCP/IP Introduction to Virus and Vaccines, Applications, DTP, E-Mail and Internet.
'C' PROGRAMMING
C Fundamentals
C Character Set, Identifiers and Keywords under ANSI C. Data Types, Constants: int, float, double, char. Qualifiers: long, short, unsigned and signed. Escape sequences (like n,b etc.). Arithmetic Expressions and different built-in Operators. Pre-processor directives (like #include, #define), concept of header files, Symbolic constants,Comments, sizeof., steps involved in translation of C Program.
Built-in operators and function
Console based I/0 and related built-in I/0 functions: printf(), scanf();getch(), getchar(), putchar(), gets() 1 puts().
Decision and Case Control Structure 1if statement; if-else construct; use of logical operators and Compound Relational Tests; Nested if statements; The else if construct; the relational operators; the conditional expression (ternary) operator. The Switch Statement with or without break, concept of a case label
Loop Control Structure
Concept of Loop, loops supported by 'C', concept of top tested and bottom tested loops, the for loop statement; Nested for Loop ; for loop variants; the while loop statement; simple and nested while loop, Increment/decrement operators; Use of Break and Continue;the do-while loop, comparison between for, while and do while loops.
Storage Classes
Automatic, Register, Static (local and global), External. Scope rules. Arrays Concept of a collection, types of collections supported by 'C', Array collection and its features, concept of indexing, index variable, index type, positional value of a member of array collection, concept of dimension and size of an array, 'C' syntax for declaration of array,name of the array and its type, Referring individual elements, Entering data into an array, reading data from an array concept of Array initialization and list of initializers, size option, Bounds checking, the concept of two dimension arrays and related syntax,similarities between dimension and nesting.
Character Strings
What are strings, standard library string functions like strlen(),strcat(), strcpy(), strcmp() etc.,similarity between string and 1-D array of char.
Functions
Concept of a subprogram, the interface of a subprogram, role of a interface, Arguments of a subprogram, kinds of subprograms supported by C, return statement as an interface, local variables; Default Return type and the type void; Passing values between functions through interfaces; Declaration of function type; iterative and recursive subprograms, Recursion; concept of call by value, call by reference, return and their underlying implementation should be explained, similarities.
Pointers
Concept of Pointers, Pointer as an address variable, concept of a pointer data type and its syntax, built-in address operator, Pointers to existing variables of different data types and their uses, use of indirection operator, the name of the array as a pointer variable,Pointers and Arrays, Pointers arithmetic, use of unary operators ( ++,--), One Dimension Arrays and Pointer, concept of array of pointers and simple use, command line arguments for the main.
Structures
Structure as a homogeneous and heterogeneous collection, possible applications, syntax of declaring sti-ucture,. Initializing structures,structure variables, accessing structure elements using member operator, Arrays of Structures, and array as member of structure,conceptual difference between array and structure collection,Functions and Structures, nested structures, concept of anonymous structures and their use, Concept of self referential structure, pointer as member of structure and pointer to structure use of member selector operator(->), comparison between indirection (*) operator and member selector operator (-> ), structure as an argument to function and return type of a function.
Unions
Concept of Union collection, Syntax of declaration and its use, comparison of Array, Structure and Union, array of unions and union as a member of structure, structure as a member of union and array as member of union, concept of memory saving and union, union as a generic data type, concept of anonymous union.
File based I/O
Concept of a file, text files in 'C', concept of a predefined FILE pointer and its definition as given in header file stdio.h, meanings of different members of the structure representing FILE, Disk I/0 Functions: High level file I/0 or standard functions- fopen(), putc() ,getc(), fclose(), fgets() ,fputs(), feof(), sim pie file based programs showing the working of different members of FILE structure.
Dynamic Memory Allocation and Memory functions
Concept of dynamic environment as run time environment, concept of dynamic memory management, use of built-in dynamic memory management tools of 'C' viz. malloc(), free(), simple programs using malloc() and free()
Bitwise Operators
Concept of modifying the value using bit shifting, built-in bit shilt operators left bit shift operator(<<) and right bit shift operator ( > >) their uses, limitations of bitwise operators, ·use of bitwise relational operators.
Other features and Miscellaneous functions
Use of atof(), atoi(), atol(), toupper(), tolower(), isalnum(), isalpha(), isdigit( ),exit().
Visual Basic 6.0
a. VB Environment
i. Menu Bar, Toolbars, Tool Box ii. Project explorer iii. Properties Window iv. Form Designer v. From Layout
b. VB The language
i. Variable, Constants, Datatypes, User defined Datatypes
ii. Scope of variable(Global, Local, Modular, static)
iii. Control Flow Statements(IF, IIF, Select Case)
iv. Looping , nesting(Do While, Do until, For, for Each, Exit)
v. Arrays
vi. User defined Procedure, Functions
vii. VB Functions: l.Date 2.Mathematical 3.String 4.Conversion
c. Visual Basic Controls from Toolbox
i. Properties
ii. Methods
iii. Events
iv. Other Controls: 1. Microsoft Windows Common Controls (6.0)
2. Microsoft windows Common controls-3(6.0)
3. Control Arrays (adding controls at runtime& design time)
d. Managing Menus
i. Creating and modifying menu at Design time
ii. Programming menu commands
iii. Shortcuts keys & menus at runtime
VALIDATING AND PROCESSING USER INPUTS
Overview , Importance , Types of validation, Implementing Form level and field level validations, Text box Properties, Using Events, validate Event
USING DEBUGGING TOOLS
a Types of errors & debug menu
i Types of errors
ii Debug menu
b Testing the application
i Immediate window
ii Using debug and local window
iii Setting watch expression
c Implementing error handler
i How VB Handles the runtime error
ii VB error handler
d VB error handling options
i How VB handles the runtime error
ii Disabling the error handler
e lnline error handling
DATABASE CONNECTIVITY
a How VB access data
i Data access interface
ii Relational database concepts
b Introduction to OLE DB & ADO
i What is OLE DB
ii How OLE DB relates to ADO
iii SQL Statements
iv ADO Data Control
Using ADO
Connecting to data source
Binding controls (DataCombo, Datalist, DataGrid
v Coding ADO
Creating record set
· Adding records in record set
· Modify, Delete, Search
vi Data Environment
vii Introduction to crystal Report ( 7.0 or above)
BASIC JAVA
Introduction to JAVA
i. History of Java
ii. Features of Java
iii. JDK Environment
iv. The Java Virtual Machine
v. Garbage Collection
Programming Concepts of Basic Java
i. Identifiers and Keywords , Data Types in Java · Java coding Conventions, Expressions in Java · Control structures, decision making statements
ii. Arrays and its methods
Objects and Classes
i. Object Fundamentals
ii. Data hiding and encapsulation
iii. Relationship between super class object and subclass object
iv. implicit subclass object to super class object Conversion
v. Dynamic method dispatch
vi. Pass by value
vii. 'this' reference
viii. Overloading
ix. Overriding, Constructors
x. Finalization
xi. Subclasses (Inheritance)
Language Features
scope rules
static data, static methods, static blocks
all modifiers of class, method, data members and variable
Abstract Classes
Interfaces
Inner classes
Wrapper Classes
packages
Package access , importing packages and classes
user define packages
Exception Handling
Types of Exceptions
try, catch, finally, throws keywords
creating your own exception
exceptions and Inheritance
Multithreading
Multithreading Concept, Thread Life Cycle
Abstract Window Toolkit
Components and Graphics Containers, Frames and Panels Layout, Managers Border Layout, Flow Layout, Grid Layout, Card Layout, AWT, all Components, Event Delegation Model
Event Source and Handlers Event Categories, Listeners, adapters
Anonymous Classes
Applets
Applet Life Cycle
Applet Context
Inter applet communication
Java utility Packages , classes, Interfaces HashTable Vector Math Random System String StringBuffer Streams and File IO
Files and Stream
Stream classes
Reader Writer classes
File class Tests and Utilities
Serialization and de serialization
DATA BASE MANAGEMENT SYSTEM
Introduction
1.1 History : Advantages and limitations of DBMS; Users of DBMS,
1.2 Software Modules in DBMS; Architecture of DBMS.
2 Modeling Techniques
2.1 Different Types of Models, Introduction to ERD.
3 Hierarchical Database
3.1 Introduction.
4 Network Database
4.1 Introduction
5 Relational Algebra
5.1 Select, Project, Union, Intersection, Difference, Cartesian Product, Simple Join. Queries to be solved based on the above.
6 Relational Database
6.1 Introduction; Codd's 12 Rules; Concept of Domain, Tuple, cardinality; Comparison between HDB-NDB-RDB
7 Normalisation
7.1Advantages & disadvantages of Normalisation; 1NF-2NF-3NFrules with examples; Anomalies.
8 Integrity Constraints
8.1 Entity-Domain-Referential integrity rules; Assertion and Triggers concept.
9 Recovery Mechanisms
9.1 Recovery from various problems of volatile and non-volatile storage devices; Concept-properties-states of Transaction;
Introduction to mechanisms such as - Log, Checkpoint and Shadow Paging.
10 Concurrency Controls
10.1 Problems of concurrent Transactions; Control Mechanisms such as • Locks, Time-Stamps, Optimistic Scheduling and MVT.
11 Distributed Databases
11.1 Concepts, Data Distributions Techniques.
12 Data Warehousing and Data Mining
12.1 Concept, Architecture, Various tools in Data Warehousing, Tools in
Data Mining, Difference between Data mining and normal query.
SQL commands.
List of SQL commands to be covered Create/drop a Database
Create /Modify/Alter/Drop Table DML Commands
Insert,Update, Delete, Select Aggregate Function
Max, Min, Avg, Count, Sum
GROUP BY
ORDER BY
Computer:
Block Diagram of elements of digital computer-their functions.
Memory, CPU, I-0 devices, Secondary storages, Magnetic Tape, Disk, CD-ROM.
Other recent developments-Scanners, Digitizer, Plotters.
Hardware and Software. Micro, Mini and Main-frame computers-their features.
Representation of Data:
Binary, Octal, Hexadecimal, BCD, EBCDIC, ASCII Conversions. Simple Additions, Subtractions, Multiplications, Divisions (in Octal and Hexadecimals).
Boolean Algebra:
Algebra Rules and DeMorgans rules. Simplification of equations-simple equations. Logic Circuits-AND, OR, NANO, NOR, Exclusive OR and NOR Truth tables. Gated flip-flops, Registers, Accumulators.
Introduction to 8086/8088 microprocessors-architecture Base-Data, Address, Control. Introduction to 80286, 80386 and Pentium chips.
Software:
Introduction to Programming, Flowcharts and Algorithms. System application software, firmware machine, Assembly, and Higher Level Languages, Stored program Concept. MS Office Packages.
Operating System-Introduction:
Process management-FCFS, Round Robbin, Priority based. Memory management-segmentation, paging, virtual memory. I-0 management-concept of 1-0 port. File management-FAT, file handling functions. Software and hardware interrupts, I/0 and Memory based Addresses, DMA channels.
File:
Concept of file. File organization and accessing techniques-Indexed, Line sequential, Hashed. File handling functions : Sorting, Merging, Indexing, Updating
Instructions and Addressing Techniques: Instruction execution cycle. Direct, Indirect, Relative, Paging, Indexed
Broad view of Operating Systems: MS-DOS, UNIX, MS-WINDOWS
Basic Concept of Networking and Data Communications:
Introduction to LAN and basic communication concepts. OSI 7 layers, Topologies, Protocols, Ethernet, Arcnet, TCP/IP Introduction to Virus and Vaccines, Applications, DTP, E-Mail and Internet.
'C' PROGRAMMING
C Fundamentals
C Character Set, Identifiers and Keywords under ANSI C. Data Types, Constants: int, float, double, char. Qualifiers: long, short, unsigned and signed. Escape sequences (like n,b etc.). Arithmetic Expressions and different built-in Operators. Pre-processor directives (like #include, #define), concept of header files, Symbolic constants,Comments, sizeof., steps involved in translation of C Program.
Built-in operators and function
Console based I/0 and related built-in I/0 functions: printf(), scanf();getch(), getchar(), putchar(), gets() 1 puts().
Decision and Case Control Structure 1if statement; if-else construct; use of logical operators and Compound Relational Tests; Nested if statements; The else if construct; the relational operators; the conditional expression (ternary) operator. The Switch Statement with or without break, concept of a case label
Loop Control Structure
Concept of Loop, loops supported by 'C', concept of top tested and bottom tested loops, the for loop statement; Nested for Loop ; for loop variants; the while loop statement; simple and nested while loop, Increment/decrement operators; Use of Break and Continue;the do-while loop, comparison between for, while and do while loops.
Storage Classes
Automatic, Register, Static (local and global), External. Scope rules. Arrays Concept of a collection, types of collections supported by 'C', Array collection and its features, concept of indexing, index variable, index type, positional value of a member of array collection, concept of dimension and size of an array, 'C' syntax for declaration of array,name of the array and its type, Referring individual elements, Entering data into an array, reading data from an array concept of Array initialization and list of initializers, size option, Bounds checking, the concept of two dimension arrays and related syntax,similarities between dimension and nesting.
Character Strings
What are strings, standard library string functions like strlen(),strcat(), strcpy(), strcmp() etc.,similarity between string and 1-D array of char.
Functions
Concept of a subprogram, the interface of a subprogram, role of a interface, Arguments of a subprogram, kinds of subprograms supported by C, return statement as an interface, local variables; Default Return type and the type void; Passing values between functions through interfaces; Declaration of function type; iterative and recursive subprograms, Recursion; concept of call by value, call by reference, return and their underlying implementation should be explained, similarities.
Pointers
Concept of Pointers, Pointer as an address variable, concept of a pointer data type and its syntax, built-in address operator, Pointers to existing variables of different data types and their uses, use of indirection operator, the name of the array as a pointer variable,Pointers and Arrays, Pointers arithmetic, use of unary operators ( ++,--), One Dimension Arrays and Pointer, concept of array of pointers and simple use, command line arguments for the main.
Structures
Structure as a homogeneous and heterogeneous collection, possible applications, syntax of declaring sti-ucture,. Initializing structures,structure variables, accessing structure elements using member operator, Arrays of Structures, and array as member of structure,conceptual difference between array and structure collection,Functions and Structures, nested structures, concept of anonymous structures and their use, Concept of self referential structure, pointer as member of structure and pointer to structure use of member selector operator(->), comparison between indirection (*) operator and member selector operator (-> ), structure as an argument to function and return type of a function.
Unions
Concept of Union collection, Syntax of declaration and its use, comparison of Array, Structure and Union, array of unions and union as a member of structure, structure as a member of union and array as member of union, concept of memory saving and union, union as a generic data type, concept of anonymous union.
File based I/O
Concept of a file, text files in 'C', concept of a predefined FILE pointer and its definition as given in header file stdio.h, meanings of different members of the structure representing FILE, Disk I/0 Functions: High level file I/0 or standard functions- fopen(), putc() ,getc(), fclose(), fgets() ,fputs(), feof(), sim pie file based programs showing the working of different members of FILE structure.
Dynamic Memory Allocation and Memory functions
Concept of dynamic environment as run time environment, concept of dynamic memory management, use of built-in dynamic memory management tools of 'C' viz. malloc(), free(), simple programs using malloc() and free()
Bitwise Operators
Concept of modifying the value using bit shifting, built-in bit shilt operators left bit shift operator(<<) and right bit shift operator ( > >) their uses, limitations of bitwise operators, ·use of bitwise relational operators.
Other features and Miscellaneous functions
Use of atof(), atoi(), atol(), toupper(), tolower(), isalnum(), isalpha(), isdigit( ),exit().
Visual Basic 6.0
a. VB Environment
i. Menu Bar, Toolbars, Tool Box ii. Project explorer iii. Properties Window iv. Form Designer v. From Layout
b. VB The language
i. Variable, Constants, Datatypes, User defined Datatypes
ii. Scope of variable(Global, Local, Modular, static)
iii. Control Flow Statements(IF, IIF, Select Case)
iv. Looping , nesting(Do While, Do until, For, for Each, Exit)
v. Arrays
vi. User defined Procedure, Functions
vii. VB Functions: l.Date 2.Mathematical 3.String 4.Conversion
c. Visual Basic Controls from Toolbox
i. Properties
ii. Methods
iii. Events
iv. Other Controls: 1. Microsoft Windows Common Controls (6.0)
2. Microsoft windows Common controls-3(6.0)
3. Control Arrays (adding controls at runtime& design time)
d. Managing Menus
i. Creating and modifying menu at Design time
ii. Programming menu commands
iii. Shortcuts keys & menus at runtime
VALIDATING AND PROCESSING USER INPUTS
Overview , Importance , Types of validation, Implementing Form level and field level validations, Text box Properties, Using Events, validate Event
USING DEBUGGING TOOLS
a Types of errors & debug menu
i Types of errors
ii Debug menu
b Testing the application
i Immediate window
ii Using debug and local window
iii Setting watch expression
c Implementing error handler
i How VB Handles the runtime error
ii VB error handler
d VB error handling options
i How VB handles the runtime error
ii Disabling the error handler
e lnline error handling
DATABASE CONNECTIVITY
a How VB access data
i Data access interface
ii Relational database concepts
b Introduction to OLE DB & ADO
i What is OLE DB
ii How OLE DB relates to ADO
iii SQL Statements
iv ADO Data Control
Using ADO
Connecting to data source
Binding controls (DataCombo, Datalist, DataGrid
v Coding ADO
Creating record set
· Adding records in record set
· Modify, Delete, Search
vi Data Environment
vii Introduction to crystal Report ( 7.0 or above)
BASIC JAVA
Introduction to JAVA
i. History of Java
ii. Features of Java
iii. JDK Environment
iv. The Java Virtual Machine
v. Garbage Collection
Programming Concepts of Basic Java
i. Identifiers and Keywords , Data Types in Java · Java coding Conventions, Expressions in Java · Control structures, decision making statements
ii. Arrays and its methods
Objects and Classes
i. Object Fundamentals
ii. Data hiding and encapsulation
iii. Relationship between super class object and subclass object
iv. implicit subclass object to super class object Conversion
v. Dynamic method dispatch
vi. Pass by value
vii. 'this' reference
viii. Overloading
ix. Overriding, Constructors
x. Finalization
xi. Subclasses (Inheritance)
Language Features
scope rules
static data, static methods, static blocks
all modifiers of class, method, data members and variable
Abstract Classes
Interfaces
Inner classes
Wrapper Classes
packages
Package access , importing packages and classes
user define packages
Exception Handling
Types of Exceptions
try, catch, finally, throws keywords
creating your own exception
exceptions and Inheritance
Multithreading
Multithreading Concept, Thread Life Cycle
Abstract Window Toolkit
Components and Graphics Containers, Frames and Panels Layout, Managers Border Layout, Flow Layout, Grid Layout, Card Layout, AWT, all Components, Event Delegation Model
Event Source and Handlers Event Categories, Listeners, adapters
Anonymous Classes
Applets
Applet Life Cycle
Applet Context
Inter applet communication
Java utility Packages , classes, Interfaces HashTable Vector Math Random System String StringBuffer Streams and File IO
Files and Stream
Stream classes
Reader Writer classes
File class Tests and Utilities
Serialization and de serialization
DATA BASE MANAGEMENT SYSTEM
Introduction
1.1 History : Advantages and limitations of DBMS; Users of DBMS,
1.2 Software Modules in DBMS; Architecture of DBMS.
2 Modeling Techniques
2.1 Different Types of Models, Introduction to ERD.
3 Hierarchical Database
3.1 Introduction.
4 Network Database
4.1 Introduction
5 Relational Algebra
5.1 Select, Project, Union, Intersection, Difference, Cartesian Product, Simple Join. Queries to be solved based on the above.
6 Relational Database
6.1 Introduction; Codd's 12 Rules; Concept of Domain, Tuple, cardinality; Comparison between HDB-NDB-RDB
7 Normalisation
7.1Advantages & disadvantages of Normalisation; 1NF-2NF-3NFrules with examples; Anomalies.
8 Integrity Constraints
8.1 Entity-Domain-Referential integrity rules; Assertion and Triggers concept.
9 Recovery Mechanisms
9.1 Recovery from various problems of volatile and non-volatile storage devices; Concept-properties-states of Transaction;
Introduction to mechanisms such as - Log, Checkpoint and Shadow Paging.
10 Concurrency Controls
10.1 Problems of concurrent Transactions; Control Mechanisms such as • Locks, Time-Stamps, Optimistic Scheduling and MVT.
11 Distributed Databases
11.1 Concepts, Data Distributions Techniques.
12 Data Warehousing and Data Mining
12.1 Concept, Architecture, Various tools in Data Warehousing, Tools in
Data Mining, Difference between Data mining and normal query.
SQL commands.
List of SQL commands to be covered Create/drop a Database
Create /Modify/Alter/Drop Table DML Commands
Insert,Update, Delete, Select Aggregate Function
Max, Min, Avg, Count, Sum
GROUP BY
ORDER BY
Teaching Methodology :
(I) (a) Curriculum: Meaning, Principles, types of curriculum organization, approaches.
(b) Planning: instructional Plan- Year Plan, Unit Plan, Lesson Plan
(c) Instructional material and resources: Text Books, Work books, Supplementary material AV aids, Laboratories,
Library, Clubs-Museums-Community, Information and
Communication Technology.
(d) Evaluation: Types, tools, Characteristics of a good test, Continuous and Comprehensive Evaluation, Analysis and
interpretation of Scholastic Achievement Test.
(II) Communication & Interaction :
1. Theory of Communication
2. Types of Communication
3. Communication & language
4. Communication in the classroom
5. barriers in communication.
OAVS Computer Teacher Exam Pattern 2027
Duration : 200 Minutes
Negative Marking : 0.25
Exam Date : Notified Soon
Starting Date of Application Form : 12th October 2026
Last Date of Application Form : 11th November 2026
Total Post : 70
Negative Marking : 0.25
| S.No | Subject | No.of Question | Marks |
| Part 1 | English | 20 | 20 |
| Odia | 20 | 20 | |
| Part 2 | Current Affairs | 30 | 30 |
| Reasoning | 30 | 30 | |
| Part 3 | Concerned Subject (Computer) & Methodology | 100 | 100 |
| Total | 200 | 200 |
Exam Date : Notified Soon
Starting Date of Application Form : 12th October 2026
Last Date of Application Form : 11th November 2026
Total Post : 70
OAVS Computer Teacher Free Online Test Series
Crack OAVS Computer Teacher Mock Test 2027 with the help of Online Mock test Series or Free Mock Test. Every Sample Paper in OAVS Computer Teacher Exam has a designated weightage so do not miss out any Paper. Preprare for OAVS Computer Mock Test and check your test scores.
OAVS Computer Exam Free Online Question Bank
OAVS Computer question answer with solutions are available in Hindi & English. Join MCQ, Important Questions, Question Bank, questions and answers for Free OAVS Computer exam preparation.
FAQs
OAVS Computer Teacher 2027 Free Mock Test Frequently Asked Questions (FAQ's)
You can find and practice free mock tests for the OAVS Computer exam on the Toppersexam.com portal.
Mock tests are very powerful tool for exam preparation. They help students develop confidence, manage time effectively and improves accuracy to prepare better for OAVS Computer.
You can find a free online mock test for the OAVS Computer on toppersexam.com. By taking frequent online mock tests students can monitor there progress and create a study plan according to the needs.
You can take mock test online for OAVS Computer to know the CBT (computer based test) format of the main exam. You will get latest exam pattern, updated syllabus and type of questions asked in the actual exam.
Mock tests are practice exams to prepare the students for the final one. Taking mock test regularly helps students to improve time management skills and boost confidence.
Students can find a free mock test for OAVS Computer only at toppersexam. Get free online mock test to experience the actual exam format is important to reduce anxiety and improves your confidence.
Advantages of online mock tests are immediate results, accessibility and time management. Sample papers and mock tests are remarkable tools to track students performance and change your study plan according to your weakness.
Free online mock test can improve your score by making you exam ready before the final exam. It is a excellent way to know the exam pattern and identify your weakness for the OAVS Computer.
Toppersexam free online mock test are designed by subject experts to provide the best preparation for OAVS Computer. The questions asked are exactly like the ones which are asked in the actual exam.
Students should practice more and more online mock test for OAVS Computer to evaluate their performance, detect weaknesses, and improve time management without any cost.
Current affairs and general knowledge mock test are important ways to increase knowledge to stay updated about the recent news and events. Regular practicing with current affairs mock test helps students to prepare better for general awareness section for the final exam.
Student Testimonials
What Our Students Say
Real feedback from students who are preparing and achieving their goals with Toppersexam