My Bday Offer- Use Code MYBDAY30

Register Now

Professional Knowledge Questions for IBPS IT Officers Exam Part - 3

Published on Monday, January 16, 2017
1. The number of tuples in a relation is called its______ While the number of attributes in a relation is called it’s___________
(1) Degree, cardinality
(2) Cardinality, Degree
(3) Rows, Columns
(4) Columns, Rows
(5) None of these



2. Which of the following is false for a query?
1) It is an expression which on evaluation returns result from the DBMS.
2) It is a command given to the DBMS.
3) DBMS might support some kind of command to execute a query.
4) Queries make the database useful.
5) None of these

3. What are the valid responses of a RDBMS?
1) Completion codes
2) Messages
3) Result of the queries
4) All of the above
5) None of these

4. The GROUP BY clause is not:
1) Used to combine, or group, rows with related values into elements of a smaller set of rows.
2) Often used in conjunction with SQL aggregate functions.
3) Used to preserve duplicate rows in a result set.
4) Used to eliminate duplicate rows from a result set.
5) None of these.

5. The parameter which gives probability of the transport layer itself spontaneously termination 2 a connection due to internal problem is called?
1) Protection
2) Resilience
3) Option negotiable
4) Transfer fund
5) None of these

6. What is the valid host range the IP address 172.16.10.22 255.255.255.240 is a part of?
1) 172.16.10.20 through 172.16.10.22
2) 172.16.10.1 through 172.16.10.255
3) 172.16.10.16 through 172.16.10.23
4) 172.16.10.17 through 172.16.10.31
5) 172.16.10.17 through 172.16.10.30

7. Which of the following are valid SQL language % elements?
1) Colon
2) Queries which retrieve data based on specific criteria.
3) Expressions which can produce either scalar values or tables consisting of columns and rows of data.
4) Statements which may have a persistent effect on schemas, and data, or which may control transactions, program flow, connections, sessions, or diagnostics.
5) None of these

8. Which protocol working at the Transport layer provides a connectionless service between hosts?
1) IP
2) ARP
3) TCP
4) UDP
5) None of these.

9. Which of the following categories of the data integrity RDBMS will enforce specific business rules:
1) Entity integrity
2) Domain integrity
3) Referential integrity
4) User- Defined integrity
5) None of these

10. SQL is all but:
1) SQL is an ANSI standard computer language
2) SQL allows you to access a database.
3) SQL allows you to execute queries against a database.
4) SQL does not allow you to update records in a database.
5) None of these.

11. Disk scheduling includes deciding
1) Which should be accessed next.
2) Order in Which disk access requests must be serviced.
3) The physical location of the file.
4) The logical location of the file.
5) None of these.

12. Which among following scheduling algorithms give minimum average waiting time
1) FCFS
2) SJF
3) Round robin
4) On priority
5) None of these

13. What is not true about COMMIT and ROLLBACK?
1) Interact with areas such as transaction control and locking.
2) COMMIT alone cannot make data permanent.
3) Both terminate any open transaction and release any locks held on data.
4) Both maintain consistency of database.
5) None of these.

14. Which of the following is a function of e-mail system?
1) Composition
2) Transfer
3) Reporting
4) All of above
5) None of these

15. Mobile computers and personal digital assistant (PDAs) are the examples of?
1) Radio broadcasting
2) Wireless network
3) Geosynchronous
4) LAN
5) None of these

Answers:

1) 2
2) 2
3) 4
4) 3
5) 2
6) 5
7) 1
8) 4
9) 4
10) 4
11) 2
12) 2
13) 2
14) 4
15) 2

Download IT Officers Notes here
ebook store

About us

ramandeep singh

Ramandeep Singh, your guide to banking and insurance exams. With 14 years of experience and 5000+ selections, Ramandeep understands the path to success, having transitioned himself from Dena Bank and SBI. He's passionate about helping you achieve your banking and insurance dreams.

  • Follow me:
Close Menu
Close Menu