Professional Knowledge Questions for IBPS IT Officers Exam Part - 3

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:

15) 2

Download IT Officers Notes here

Smart Prep Kit by Ramandeep Singh - Get here

Bank Exams Today Notes

Join 40,000+ readers and get free notes in your email

Let's block ads! (Why?)

- http://www.bankexamstoday.com/2017/01/professional-knowledge-questions-for.html