SBI SO 2014 - Morning Session Question

SBI SO exam conducted on 19th April 2014. Here are few questions taken from memory.

1) What is a quarter adder?
2) N flipflop divides the clock frequency by which factor?
3) Which OSI layer act between user services and network services?

Read more »

IBPS Specialist officer Analysis

IBPS published provisional allotment list of Specialist officer 2014-15 year. Candidates can view their result status on IBPS website. The detailed test result is available on IBPS website. According to IBPS, this time there for IT JMGS-1 there are a total of 299 vacancies available, out of which 158 are available for General category.

This time IBPS conducted common online written examination. There was a sectional cutoff and total cutoff for the examination. A total of 112 marks out of 200 was set as total cutoff for general category candidates.

Different types of wireless security system

Most of times we use wireless system for internet access. Since the channel is wireless, it cannot be protected physically. There are several techniques for wireless protection. Here in this article I am trying to explain the features and importance of common wireless protection technique. Let's start with the most common wireless protection system.

WPA&WPA2 Personal

• Acronym for WiFi protected Access and WiFi protected Access II.
• Based on Pre-shared keys
• Excellent to use in home and small office networks
• The network traffic is encrypted using 256 bit key
• The key may be a string 64 hexadecimal digit or as passphrase of 8 to 63 ASCII character

Read more »

Gangur Festival - Rajasthan

Gangur Festival is an important festival of Rajasthan. The festival celebrates the companionship of hindu deities Siva and Parvathi. It is believed that, Parvathi returned to her maternal home during Gangur and Siva accompanied her.

Many tourist from all over the world is interested in this festival. Lots of tourist from various parts of the world is visiting these days.

PS- if you have more information about the festival please feel free to comment here.

Second navigational satellite from ISRO - IRNSS-1B

India to launch second navigational satellite on April 4  2014. If successful, it will be the 25th consecutive launch of ISRO's PSLV.

The satellite is named as Indian Regional Navigational Satellite System(IRNSS-1B). The launch vehicle is PSLV's XL version with more powerful boosters.

According to ISRO all the seven satellite in the IRNSS will be in orbit by 2016. Congrats to the team behind this event.

DBMS mcq questions and answers

1 ) The function of a database is ...
a. to check all input data
b. to check all spelling
c. to collect and organize input data
d. to output data

2) The statement that is executed automatically by the system as a side effect of the modification of the database is
(A)backup
(B)assertion
(C)recovery
(D)trigger

3) what is a second normal form?

Second normal form states that, there should not be any partial dependency

4) The default level of consistency in SQL is

(A) repeatable read
(B)read committed
(C)read uncommitted
(D)serializable

5) Cascading rollback is avoided in all protocol except

1 strict two-phase locking protocol.
2 tree locking protocol
3 two-phase locking protocol

4) validation based protocol.

6) Relational Algebra does not have

(A)Selection operator.
(B)Projection operator.
(C)Aggregation operators.
(D)Division operator.

7) According to the levels of abstraction, the schema
at the intermediate level is called
(A)Logical schema.
(B)Physical schema.
(C)Subschema.
(D)Super schema.

8) Which two files are used during operation of the DBMS????
(A)Query languages and utilities
(B)DML and query language
(C)Data dictionary and transaction log
(D)Data dictionary and query language

Data Dictionary and Transaction Log

What is Data dictionary?
Data dictionary is otherwise names as metadata repository, which contains the information about the data such as relationship, meaning, datatypes used etc. During the operation of a database, this data dictionary will be always checked.Passive data dictonary means, if the data dictionary is used only be the designers of the database and administrators while active data dictionary means the dictionary used by DBMS software too.

What is Transaction log?
It means the history of actions done by the DBMS software. It should be properly kept to ensure the acid properties. 

DBMS questions with solution

 1. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
a) Candidate key
b) Sub key
c) Super key
d) Foreign Key

2. Consider attributes ID , CITY and NAME . Which one of this can be considered as a super key ?
a) NAME
b) ID
c) CITY
d) CITY , ID

Explanation:Superkey means combination of a primary key and another attribute. Here in the above question the only possible key is ID. SO CITY,ID is a superkey.

3. The subset of super key is a candidate key under what condition ?
a) No proper subset is a super key
b) All subsets are super keys
c) Subset is a super key
d) Each subset is a super key

Read more »

SBI SO questions and solutions

Here is SBI SO previous paper with solution. Here answers are curated with at most attention. But there are chances for errors. Those doubtful questions are marked red. If there is any error please mention in comment form. Best wishes

1. To create a copy files in the event of system failure, you create a ___
   1. Firewall
   2. Redundancy
   3. Backup
   4. Restore file
   5. None of these
2. Print server uses___ which is a buffler that holds before it is send to the printer.
   1. Queue
   2. Spool
   3. Node
   4. Stack
   5. None of these
3. Which of the following identifies specific web page and its computer on the web page?
   1. Web site
   2. URL
   3. Web site address
   4. Domain Name
   5. None of these
4. _____ is the computer to computer exchange of routine business data between trading partners in standard data formats.
   1. CTS
   2. DSR
   3. VDR
   4. EDI (Electronic data interchange)
   5. None of these
5. Communication handler is basically an ____ 16 bit micro controller?
   1. 8085
   2. 8086
   3. 8086A
   4. 80C186
   5. None of these

Read more »

Electronic Data Interchange

EDI is an electronic communication system that provide standards for exchanging electronic communication between systems. By following same standards, two organization or two countries can effectively transfer electronic communication such as electronic documents. The electronic documents include Purchase orders, invoices etc. Some example for EDI are X12, EDIFACT, ODETTE. There are industry specific standards for exchanging electronic documents.

Record based logical model

Record based logical model describe data at conceptual and view levels. They are used to provide  a logical structure of a database and also to give  a higher level description of the implementation.

Why named so?
1) It's named so because database is represented as fixed format records of several types
2) Each record type contain fixed number of fields or attributes

Three most widely accepted models are:
1) Relational model
2) Network Model
3) Hierarchical model

Comparison of these three models:
In network model data and relationships are represented using boxes and arrows. Each box represent a record type and each arrow represents a relationship. The hierarchical model is a specialization of network model where it consider a hierarchy in organizing record type. For example in hierarchical model College will be a parent record type for another record type Department. The Relational model represents data in a tabular format, with each row representing an entity of some type, and each column representing a defining attribute of the entity.