Professional Knowledge Questions for IBPS SO IT Mains 2017

Dear Aspirants,

Prepare Professional Knowledge Questions for IT Officer Mains Examination. Solve these questions to test your knowledge and to prepare for SO IT Mains Exam. This quiz contains a set of 10 questions from various chapters or subjects like Networking, DBMS, Information Security, Data Structure, Computer Hardware and Software that are important for IT Officer Mains Exam.

Q1. Which of the following are two most important network architecture or reference model?
i) Layered reference model
ii) OSI reference model
iii) DSL reference model
iv) TCP/IP reference model
(a) i and ii
(b) ii and iii
(c) iii and iv
(d) ii and iv
(e) only iii

S1. Ans.(d)

Q2. CREATE TABLE Employee(Emp_id NUMERIC NOT NULL, Name VARCHAR(20) , dept_name VARCHAR(20), Salary NUMERIC UNIQUE(Emp_id,Name));
INSERT INTO Employee VALUES(1002, Ross, CSE, 10000)
INSERT INTO Employee VALUES(1006,Ted,Finance, );
INSERT INTO Employee VALUES(1002,Rita,Sales,20000);

Consider the given SQL statements in the description. What will be the result of the query?
(a) All statements executed
(b) Error in create statement
(c) Error in insert into Employee values(1006,Ted,Finance, );
(d) Error in insert into Employee values(1008,Ross,Sales,20000);
(e) Error in Create Table;

S2. Ans.(d)
Sol. The unique specification says that no two tuples in the relation can be equal on all the listed attributes.

Q3. A variable X is called pointer if:
(a) X contains the address of an element in data
(b) X points to the address of first element in data
(c) X can store only memory addresses
(d) X contain the data and the address of data
(e) X cannot store a value more than 1 bit.

S3. Ans.(d)

Q4. Which among the following operation cannot be performed on a queue?
(a) Traversal
(b) Insertion
(c) Deletion
(d) Retrieval
(e) All of the above operations are performed on a queue

S4. Ans.(a)

Q5. Which of the following is used to get back all the transactions back after rollback?
(a) Commit
(b) Rollback
(c) Flashback
(d) Redo
(e) Save

S5. Ans.(c)

Q6. Which among the following is an example of a network database?
(e)Both (a) and (b)

S6. Ans.(c)

Q7. Which of the following is IaaS service provider?
(a) EC2
(b) EC1
(c) EC10
(d) Hybrid
(e) Both (a) and (b)

S7. Ans.(a)
Sol. On Amazon EC2, a client would provision a computer in the form of a virtual machine image

Q8. Which statement is true regarding synonyms?
(a) Synonyms can be created for tables but not views
(b) Synonyms are used to reference only those tables that are owned by another user
(c) A public synonym and a private synonym can exist with the same name for the same table
(d) The DROP SYNONYM statement removes the synonym, and the status of the table on which the synonym has been created becomes invalid
(e) All of the given statements are true

S8. Ans.(c)
Sol. A synonym is an alias or alternate name for a table, view, sequence, or other schema object. They are used mainly to make it easy for users to access database objects owned by other users.

Q9. A binary search tree whose left subtree and right subtree in differ in height by at most 1 unit is called _______.
(a) Lemma Tree
(b) Redblack Tree
(c) AVL Tree
(d) Both (a) and (c)
(e) None of the above

S9. Ans.(c)

Q10. What does Rollback do after commit?
(a) Undo the transactions before commit
(b) Clears all transactions
(c) Redo the transactions before commit
(d) No action
(e) Redo (one) previous transaction

S10. Ans.(d)

To prepare Professional Knowledge for IT Officer, you can get IT Officer Handbook or Video Course by Adda247. The Book is divided into modules that incorporate all the important topics of Networking, DBMS, Web Technology, Operating System, Data Structure, Computer Organization and Microprocessor, Software Engineering and much more.  And you'll not only get the study material framed in modules, exercises and Questionnaire for practice but also Video Solution for Practice Sets.