Computer Awareness for Bank Exams PDF (Pt.1)

Computer Awareness for Bank PO, SO

Computer Awareness for Exams like IBPS PO, SO, Clerical, SBI, RBI and others.

Computer Knowledge and Awareness is an important section in many govt. exams like IBPS PO, IBPS SO, IBPS Clerical, SBI PO, SBI clerical and others. Also, during the Interviews especially in  IBPS Specialist officers interview , questions are asked which are related computer field. Therefore, it is important to prepare Computer Awareness section well.This series of Article on Computer Awareness gives you some of the important bits of information related to computers. Some of the topics that will be covered in this are DBMS, Computer Networks, Network Security, Web Technologies, E-Banking etc. It will surely help the students in their exam preparations.

DBMS – Basic concepts for Bank Exams:

  1. What is DBMS?
    • DBMS means a collection of inter-related data and a set of programs to access that data. The primary goal of a DBMS is to provide a way to store and retrieve data in an efficient manner.
  2. What is a Database?
    • Database is a collection of inter-related data items.
  3. Why one should use DBMS?
    • DBMS should be used to :
      • Prevent Data Redundancy and Inconsistency.
      • keep the Data Secure.
      • easily access the Data.
      • Access data concurrently while maintaining Atomicity and Integrity of Data.
  4. What is Data Redundancy?
    • Duplication of Data is called as Data Redundancy
  5. What do you mean by Atomicity of Data?
    • Atomicity of Data means that either all the required operations take place on the data item or none of them takes place. There is no scope for ‘Some’ operations taking place.
  6. What are the different Levels of Data Abstraction?
    • Data Abstraction means hiding the complexities from users. Three levels of Abstraction in DBMS:
      • Physical Abstraction – At Physical Level.
      • Logical Abstraction- At Logical Level.Hiding the details about data and the relation between data.
      • View Level- Showing only part of the database to the users.
  7. What is Database Schema?
    • The overall design of the Database is known as Database Schema.
  8. What is Instance of a Database?
    • The collection of information stored in a database at any point of time is the Instance of a Database.
  9. What is a Data Model?
    • Data Model is a way to describe the design of a Database. It is a tool for describing data, data relationship, data semantics and the constraints.
  10. What is the Relational Data Model?
    • The Relational Data model uses a collection of tables to represent both data and the relationship among those data. Each table has a unique name and multiple columns. Each column also has a unique name in a table.
  11. What is E-R Model?
    • E-R Data Model is based on the perception of real world that consists of basic objects called entities and the relationships among those objects.
  12. What is Object-based Data Model?
    • It can be called  as an extending E-R Model with Object oriented features like Encapsulation, Methods etc.
  13. What is DML?
    • It stands for Data Manipulation Language. It lets users to access or manipulate data by using database queries.
    • 2 types – Procedural DMLs and Declarative DMLs.
    • Procedural DMLs- Tells what data is needed and how to get that data.
    • Declarative DMLs – only tells what data is needed.
  14. What  is a DDL?
    • It stands for Data Definition Language. It is used to specify the database schema.
  15. What do you mean by DATA DICTIONARY?
    • Data Dictionary is a special type of Data Structure used by DBMS which contains METADATA i.e. Data about Data.
    • The output of DDLs are stored in the Data Dictionary.
    • Data Dictionary can be accessed only by the DBMS and not the regular user.
  16. What is a Transaction?
    • A Transaction is a set of operations that performs a single logical function in a database application.
  17. What is Normalization?
    • It is an approach to store information without unnecessary redundancy and yet allows us to retrieve the information efficiently.
  18. What is Data Mining?
    • Data Mining is the process of analyzing the large databases to find useful patterns. It attempts to discover rules and patterns from data.

 

Download the above Computer Awareness questions in PDF.

DOWNLOAD Android App for IBPS PO exam preparation

Click here for Computer Awareness for Bank exams PDF Part 2

Please Share this Article if you find it useful. Drop your comments for any Additions/Suggestions
Print Friendly, PDF & Email

You may also like...

16 Responses

  1. What is definitely your opinion of personal sites and on the web journaling?

  2. Just how do Microsoft as well as the owners of Firefox generate income? Google is definitely planning to produce a browser also to compete with them called “chrome”. I used to be wondering exactly where does the origin of income come in? You will find no advertisements, etc . These programs are free..

  3. I know whatever you write is technically copyrighted, but I’m not sure just how you could prove that it was your initial material..

  4. How do I begin a blog? I simply got a brand new account on Yahoo but don’t discover where to start composing.?

  5. I want to start a review blog page. My friend and I would be reviewing books, games, playthings etc ..

  6. I simply arrived in Chiang Mai. I needed to post upon my blog, at Blogspot, but all the headings are actually in Asian, not English. Is the issue with my pc, or the hotel’s wi-fi program, or what? How can I obtain things to English again?.

  7. How do I begin a website? I know that I have to buy a domain or something like that?

  8. hello there and thank you for your information – I’ve definitely picked up something new from proper here. I did on the other hand expertise some technical points using this site, since I experienced to reload the website lots of instances prior to I may just get it to load correctly. I had been pondering if your hosting is OK? Now not that I am complaining, but slow loading circumstances instances will sometimes affect your placement in google and can injury your high-quality rating if ads and ***********|advertising|advertising|advertising and *********** with Adwords. Well I am including this RSS to my e-mail and can glance out for much more of your respective interesting content. Ensure that you update this once more very soon..

  9. besi habim  says:

    I have a portable version of Firefox with an external drive and I’d like to move my current Firefox configurations form my laptop Firefox to this… Is this feasible?.

  10. I have a Blogger blog that is connected to my own website. The actual blog is linked off of the homepage. I would like to know if you will find a widget or something that I can put on my website’s home page that will show my latest blog posts. Not the whole post, but maybe just the headline and a link to go to my blog..

  11. on fire fox,. how do you reach your favorites???. =/. haha im stupid.

  12. I are a little confused on just how I would generate income by blogging, I mean whom pay myself and how, once I blog who arrive to my page and how do I get them there. I really appreciate in the event that some one could break this down for me… Thanks!.

  13. The right way to upload a template that was made in dreamweaver to my joomla site?

  14. How do I start and use a blog? Also, what is the greatest blogging site?

  15. Can you gain access to a computer through the iPod touch with no installing anything onto the computer?

  16. Whenever I actually open chrome, it immediately crashes. We’ve tried opening it in safe setting and still it doesn’t work. I even attempted changing personal homepage. When my buddies give me a hyperlink in my bing messenger, it opens up opera and functions fine, I’m able to browse the internet normally. What do I do? I actually already un-installed and reinstalled it..

Leave a Reply

Your email address will not be published. Required fields are marked *