Best Books for IBPS SO IT Officer Exam Preparation

Specialist Officer recruitment exam conducted by IBPS is one of the most demanded process in banking sector. there are lot of competition, if you are an aiming for Rajbhasha Adhikari, Marketing Officer, IT Officer, Law Officer, Agriculture Officer or HR Officer you shouldn't wait much and start your preparation for IBPS SO 2018 Exams with latest books.If you are sincerely willing and endeavoring to achieve your task then your first and smart move should be to select the IBPS SO Books wisely.Read this article to know about IBPS SO Books and Online Study Material to kick start your preparation.

Read More

Database quiz for IT officer exam

As we all know,DBMS is very important subject for SO exam. For that reading book in detail is not possible,also its boring too. We are providing important question as a quiz

00:00:00

1. In SQL, the CREATE TABLESPACE is used :

To create a place in the database for storage of scheme objects

To create a database trigger

To add/rename data files, to change storage

All of the above

None of the above

2. 'AS' clause is used in SQL for

Selection operation

Rename operation

Join operation

Projection operation

none of the above

3. In SQL, the CREATE VIEW command is used :

To re-compile view

To define a view of one or more tables or views

To re-compile a table

To create a trigger

None of the above

4. In SQL, which command is used to remove a stored function from the database ?

REMOVE FUNCTION

DELETE FUNCTION

DROP FUNCTION

ERASE FUNCTION

None of these

5. Which command is used to remove an index from the database in SQL?

DELETE INDEX

DROP INDEX

REMOVE INDEX

ROLLBACK INDEX

None of the above

6. In SQL, GRANT command is used to

Allow user to access database

Allow user to create database

Grant system privileges, roles and object privileges to uses and roles

Choose auditing for specific SQL commands

None of the above

7. In SQL, which command(s) is (are) used to remove rows from a table :

DELETE

REMOVE

TRUNCATE

Both (a) and (c)

None of the above

8. In SQL, which statement is used to select employee number (EMP_NO) and Department (DEPT) from (EMPLE) table whose salary (SALARY) is 8000?

SELECT EMPNO, DEPT FROM EMPL=8000

SELECT EMPNO, DEPT FROM EMPL WHERE SALARY=8000

SELECT EMPNO, DEPT, SALARY=8000 FROM EMPL

SELECT EMPNO, DEPT, FROM TABLE EMPL WHEN SALARY-800

None of these

9. Multivalued dependencies should ________ be eliminated.

always

commonly

seldom

never

None of these

10. A subquery in an SQL SELECT statement is enclosed in:

braces -- {...}

CAPITAL LETTERS

parenthesis -- (...)

brackets -- [...]

None of these

                                       

Read More

IBPS Specialist IT Officers : Syllabus & Book

 Banking sector offers opportunities for career in specialized fields like Agriculture Field Officer, IT Officer, Law Officer, Technical Officer, Finance Executive, Marketing Officer, HR /Personnel Officer, Chartered Accountant etc. Here is  unique opportunity for aspirants for career in Public Sector Banks through  Single  Written Examination .

In this post I write about IT officers syllabus and related books  . This time IBPS conducted online exam then you need to prepare well according to a systematic  plan .Specialist Officers examination is slightly different from Probationary officer examination.In Specialist Officers examination candidate has to clear Professional Knowledge test.So how to prepare for Specialist Officers examination is a big challenge & candidates need to understand syllabus clearly. There are mainly four section in the paper.

first three subject common in all examination (IBPS)only fourth part is different so you make a plan for every subject. you should more focus on professional knowledge.

Some Important topics (80% question comes from this section) :
1. Database Management (DBMS)
2. Networking
3. Network Security
4. Web Technologies
5. Programming concepts (Basics)
6. Basic hardware (Microprocessor, timer, ALU etc)

Book for IT Officers:

Read More