[nilesh]

Discuss about pnb syllabus for specialist officer here. Welcome to Courses.ind.in and this page is for pnb syllabus for specialist officer discussion. If you are looking for information on pnb syllabus for specialist officer then ask your question is as much details as possible in the “Reply” box provided below. The more detailed your question will be, the more easy will it be for our experts to answers your query. And if you have any updated or latest information on pnb syllabus for specialist officer, then please share you knowledge with our experts in the “Reply” box below. Your reply will be published here and your knowledge can help many people. Thanks for stopping by at Courses.ind.in. Please visit again.

Would you please help me here to get the Specialist IT Officer exam syllabus issued by Punjab National Bank, so that I can check it?

[prince karak]

Don’t worry I will provide you Punjab National Bank, Specialist IT Officer exam syllabus so that you can prepare well from it.

General Awareness
Important Days.
Awards and Honours.
Budget and Five Year Plans.
Current Affairs – National & International.
Indian Economy.
Books and Authors.
General Polity.
International & National Organizations.
Science – Inventions & Discoveries.
Science & Technology.
Sports.
Abbreviations.
Countries & Capitals
General Science.
Indian History.
Indian National Movement.

English Language
Verb.
Tenses.
Subject-Verb Agreement.
Articles.
Comprehension.
Fill in the Blanks.
Adverb.
Error Correction.
Sentence Rearrangement.
Unseen Passages.
Vocabulary.
Antonyms.
Synonyms.
Grammar.
Idioms & Phrases, etc.

Quantitative Aptitude
Number System.
Average.
Percentages.
Ratio and Proportions.
HCF & LCM.
Time and Work.
Decimal & Fractions.
Problems on Ages.
Profit and Loss.
Simplification.
Simple & Compound Interest.
Time and Distance.
Mixtures & Allegations.
Data Interpretation etc.

Reasoning
Number Series.
Coding-Decoding.
Directions.
Analogy.
Mirror Images.
Clocks & Calendars.
Embedded Figures
Blood Relations.
Non-Verbal Series.
Decision Making.
Alphabet Series.
Number Ranking.
Arithmetical Reasoning.
Cubes and Dice etc.

Professional Knowledge
Database Management System
File Based Data Management – Disadvantages of file system

Database systems – Need for Database, Advantages of using a database

Characteristics of data in a database – Functions of DBMS, Components of a database, Comparison between Database and file-processing systems

Data dictionary – Data abstraction, Data independence – Logical and Physical data independence

Architecture: Overall Architecture of DBMS

Three level architecture – Hierarchical, Networking, Relational Data Models (E-R Model, E-R Diagrams, EER Model), Advantages and Disadvantages of each model.

Advanced Concepts: Introduction to Data warehousing and Data mining – Different types

Client/Server Technology: Client – Server – Distributed and Co-operative processing – Peer- to – Peer processing – Application components – Transaction management.

Relational Structure – Characteristics of Relational Database Model – CODD’s rules – Tables (Relations), Rows (Tuples), Domains, Attributes, Extension, Intention.

Keys: Candidate Key, Primary Key, Foreign Key, Super Keys, Unique Keys.

Data Constraints: Referential Integrity Constraints, Entity Integrity Constraints, Constraints like Primary key constraint, Unique, Check constraint strong Entity, Weak Entity.

Normalization: Introduction – Purpose of Normalization – Definition of Functional Dependence (FD) Relational database Design, – Normal forms: 1NF, 2NF, 3NF, BCNF, 4Nf and 5 NF.

Database Administration: DBA Tasks – DBA Tools – User Privileges – Performance monitoring and tuning – Query tracing – Backup and Recovery

Introduction to SQL: Advantages of SQL – Invoking SQL*PLUS, The Oracle Data-types, Data Definition Language (DDL), Data Manipulation language (DML), Data Control Language (DCL), Data Query Language ( DQL) and all related commands.

Queries using Group by and Order by clause & Join: Querying a Single Table, Ordering results, grouping the results, Joins, Types of Joins, Sub queries.

Operators: Logical, Value, Syntax and Query expression operators – Set operators.

Functions: Character, Arithmetic, Date and time, Group and Miscellaneous Functions, Commit, Rollback, Savepoint.

Format models: Character, Numeric & Date Format models.

Views: Introduction – Advantages of views – The Create View Command, Updating Views, Views and Joins, Views and Sub queries – Dropping Views.

Sequences: Creating Sequences, Altering Sequences, Dropping Sequences.

Indexes: Index Types, Creating of an Index: Simple Unique and Composite Index, Dropping Indexes.

Snapshots: Creating a Snapshot, Altering Snapshot, Dropping a Snapshot.

Introduction to PL/SQL: The PL/SQL Syntax, The PL/SQL Block Structure, Fundamentals of PL/SQL, Advantages of PL/SQL data Types.

Control Structure: Conditional Control, Iterative Control, Sequential Control.

Exception handling: Predefined Exception – User defined Exception.

Cursors: Implicit and Explicit Cursors

Procedures: Advantages – Creating – Executing and Deleting a Stored Procedure.

Functions: Advantages – Creating – Executing and Deleting a Function.

Database Triggers: Use of Database Triggers – How to apply database Triggers – Types of Triggers – Syntax for Creating Trigger – Deleting Trigger.

For full information please check the file