Monday, January 18, 2016

Professional Knowledge Questions Asked in Morning Shift of SBI SO Exam held on 17/01/2016

  1. What is Kernel - (The Kernel is a computer program that manages input/output requests from software, and translates them into data processing instructions for the central processing unit and other electronic components of a computer. The Kernel is a fundamental part of a computer's operating system.) - This was not the option i have written this for understanding.
  2. Question related to primary key- Primary Key is a type of Candidate Key that defines the record of a table uniquely for example in Employee Table  Customer Id can be primary key because it is unique.
  3. Which file is part of oracle database
  4. What does (*) mean in SQL - Select the whole table like (SELECT *FROM Employee) means it will select all the data from Employee Table.
  5. Security is supported by 802.11b access point ( In other shift question was on 802.11a now u can see how these questions can be important)
  6. Data warehouse support (OLAP, OLTP, operational db)
  7. Class A assignable range
  8. Security protocols in network layer
  9. One question related to Spoofing Attack
  10. In which phase of SDLC prototyping is used
  11. Message is convert into non-readable is called - encryption 
  12. What is Key-logger - A key logger is a piece of software — or, even scarier, a hardware device — that logs every key you press on your keyboard. It can capture personal messages, passwords, credit card numbers, and everything else you type.
  13. Function of physical layer- Data Encoding, Signaling and Physical Component
  14. Key loggers comes under - Keyloggers are generally installed by malware, but they may also be installed by protective parents, jealous spouses, or employers who want to monitor their employees. Hardware key loggers are perfect for corporate espionage.
  15. In database of 50 rows we have to select 20 rows, what operation should be used
  16. Disaster recovery plan time and cost
  17. TCP and UDP functions
  18. Standby in oracle DB
  19. Group of server that share task
  20. Which query structure is true
  21. Question related to oracle 9i shared pool
  22. Data Mining Tool
  23. Class of IP and its range?
  24. Dataware house supports oltp or olap or both?
  25. What is cloud computing- The practice of using a network of remote servers hosted on the Internet to store, manage, and process data, rather than a local server or a personal computer.
  26. OSI layer in which routing will be done
  27. What will be done in OSI layer 1
  28. Data and Method together inside
  29. What is prototyping - It is a set of rules on which the whole project will work like in a project of student management system first we will have to design the whole module like how the project will work.
  30. In which stage prototyping will come?
  31. Which one is middle ware technology
  32. One question related to which of the following "SELECT" query is correct in the following queries
  33. Network of servers to work in case of one server is failed
  34. If two tables are having same "primary key" in 2 tables, what will happened(scenarios were given as options)