[PDF] Assistant Database Administrator Kerala Water authority Syllabus|521/2023 syllabus Kerala PSC

Assistant Database Administrator Kerala Water authority Syllabus: DETAILED SYLLABUS FOR THE POST OF ASSISTANT DATA BASE ADMINISTRATOR IN KERALA WATER AUTHORITY, (Cat.No.: 521/2023)

(Total Marks – 100 )

521/2023 syllabus Kerala PSC

Contents:

Discrete Mathematics, Probability and Statistics (12 Marks)

Join My Notebook Whatsapp Channel

Compound Statements, Truth Tables, The Algebra of Propositions, Logical
Arguments, Sets, Operations on Sets, Binary Relations, Partial Orders,
Mathematical Induction, The Principle of Inclusion-Exclusion, Probability
theory: Sample spaces, Events and probability, Discrete probability: Union,
Intersection and Compliment of events, Conditional probability, Baye’s
theorem. Linear correlation coefficient, Linear regression, Non Linear
regression, Multiple correlation and Multiple regression, Theory of sampling
and population

Digital Electronics, Computer Organization and Operating System (14 Marks)

Digital Logic Systems and Microprocessors: Boolean expressions, K-maps, TTL
and CMOS logic families, combinational logic design, synchronous sequential
system design. Microprocessors: 8086 architecture, data transfer scheme and
interfaces, Addressing modes.
Computer Organization and Architecture: Von-Neumann architecture of
computers. Registers and micro operations, control logic, processor
addressing and bus organization. Processor input/output and DMA. Memory
organization and cache coherence.
Operating Systems: CPU scheduling, Deadlocks, Memory management,
file systems, disk scheduling. Process, threads and their synchronization. Real
Time OS: clock synchronization and task scheduling. System initialization,
booting and handling user accounts. Backup and restore, Bourne shell
programming for Linux.

Data Structures and Programming in C (12 Marks)

Data Structures: Linked List, Stack, Queue, Priority Queues, Hashing, Binary
trees, Tree traversal, AVL trees, Graphs- shortest paths, minimum spanning
trees; Sorting algorithms.
Programming in C: Operators and expressions, Control statements, Storage
types, Functions, Arrays, Strings, Structures, Pointers and dynamic memory
management, File Handling.

Object Oriented Programming through C++/Java (12 Marks)
Data Abstraction, Encapsulation, classes, constructors and destructors,
Classes, and dynamic memory allocation, Inheritance, Polymorphism, generic
classes, exception handling and File processing.

Java applets, Java features, Byte codes, Internet classes, wrapper classes,
multithreading support classes, vector, stack, interface observer, stream
tokenizer, GUI classes, Java I/O, classes, The Applet class, applet architecture,
applet display methods and repainting

Database Management System (12 Marks)

Keys, E-R Model, Normalization – 1NF to 5NF; Aggregate functions, Nested
Sub queries, Views, Joined Relations, Transaction- ACID properties;
Concurrency Control, triggers, stored procedures

Client Server Architectures and Web Programming (12 Marks)

Two and three-tier client server architectures, web servers, HTML & XML, Style
Sheets, client side scripting-java script and VB script; Server Side Scripting-php,
JSP and ASP.NET programming for creating dynamic web pages using database,
forms and session; AJAX and SignalR

Computer networks and Programming (14 Marks)

Computer networks and security: TCP/IP & OSI/ISO reference models,
functions and protocols of different layers, characteristics of physical media,
multiplexing, medium access protocols, introduction to 802.3, 802.4, 802.5,
802.11 LAN technology, IP protocol including routing and congestion control,
TCP and UDP, DNS. Email protocols. Symmetric and asymmetric encryption
including DES, AES, IDEA, RSA algorithms, key management in symmetric
and asymmetric encryption, viruses and trusted systems, Kerberos.
Network Programming: Sockets Programming: TCP Programming

(TELNET, HTTP). UDP Sockets: TFTP, DNS. Secure Sockets (SSL), TLS, SSH,
HTTPS, Remote Method Invocation (RMI). Simple Object Access Protocol
(SOAP), UDDI, and Web Services.

Software Engineering (12 Marks)

System modeling, system engineering process, life cycle models, design and
implementation, validation, evolution, automated, process support – software
requirements, SRS, feasibility studies – elicitation and analysis – validation –
management – system models, context models, behavior models, data
models, object models, object-oriented design, design evolution, real-time
software design, critical systems specifications – critical system development,
software testing.