QUIZ

1) How do we know ‘The Australia and New Zealand Banking Group Limited’?

Ans: ANZ Bank

2) Which stock exchange in the world is referred to as ASX?

Ans: Australian Stock Exchange

3) Which company did Henrry Brayan. Dr J Budd, Harmon Cable, Will McGonaggle and John Dwan start on the North Shore of Lake Superior at 2 Harbors, Minnesota in 1902?

Ans: 3M

4) Which famous TV or radio network in the US is referred to as the Alphabet Network?

Ans: ABC Network

5) Who acquired Macromedia in Dec 2005?

Ans: Adobe

6) High Performance. Delivered is whose promise?

Ans: Accenture

7) Front Row, Sports Grill, American Bar are all brands owned by which company?

Ans: TGIF

8.)Launched in 1958 by Bank of America as the white, blue and gold revolving credit. It was known as Bank Americard. How do we know it today?

Ans: VISA

9) Whose famous ad slogan was- “ The Milk Chocolate melts in your mouth. Not in your hands “

Ans: M&M

10) Who is the shirt sponsor of Manchester United?

Ans: AIG

11) Whose product is Minute Maid- a fruit punch?

Ans: Coca Cola

12) John Jacob and Henry founded which optics company in 1853?

Ans: Bausch & Lomb

13) Get Gorgeous, On the Run, Freedom Express aand Launchpad are programmes on which channel?

Ans: Channel V

14) Who produced the movie ‘Guru’?

Ans: Madras Talkies

SQL Interview Questions

SQL*Plus
SQL*Plus is an application that recognizes & executes SQL commands & specialized SQL*Plus commands that can customize reports, provide help & edit facility & maintain system variables.

NVL : Null value function converts a null value to a non-null value for the purpose of evaluating an expression. Numeric Functions accept numeric I/P & return numeric values. They are MOD, SQRT, ROUND, TRUNC & POWER.

Date Functions
Date Functions are ADD_MONTHS, LAST_DAY, NEXT_DAY, MONTHS_BETWEEN & SYSDATE.

Character Functions
Character Functions are INITCAP, UPPER, LOWER, SUBSTR & LENGTH. Additional functions are GREATEST & LEAST. Group Functions returns results based upon groups of rows rather than one result per row, use group functions. They are AVG, COUNT, MAX, MIN & SUM.
 

TTITLE & BTITLE are commands to control report headings & footers.

COLUMN
COLUMN command define column headings & format data values.

BREAK
BREAK command clarify reports by suppressing repeated values, skipping lines & allowing for controlled break points.

COMPUTE
command control computations on subsets created by the BREAK command.

SET command changes the system variables affecting the report environment.


SPOOL command creates a print file of the report.

JOIN is the form of SELECT command that combines info from two or more tables.
Types of Joins are Simple (Equijoin & Non-Equijoin), Outer & Self join.
Equijoin returns rows from two or more tables joined together based upon a equality condition in the WHERE clause.
Non-Equijoin returns rows from two or more tables based upon a relationship other than the equality condition in the WHERE clause.
Outer Join combines two or more tables returning those rows from one table that have no direct match in the other table.
Self Join joins a table to itself as though it were two separate tables.


Union is the product of two or more tables.

 Intersect is the product of two tables listing only the matching rows.

Minus is the product of two tables listing only the non-matching rows.

Correlated Subquery is a subquery that is evaluated once for each row processed by the parent statement. Parent statement can be Select, Update or Delete. Use CRSQ to answer multipart questions whose answer depends on the value in each row processed by parent statement.


Multiple columns can be returned from a Nested Subquery.

Sequences are used for generating sequence numbers without any overhead of locking. Drawback is that after generating a sequence number if the transaction is rolled back, then that sequence number is lost.

Synonyms is the alias name for table, views, sequences & procedures and are created for reasons of Security and Convenience.
Two levels are Public - created by DBA & accessible to all the users. Private - Accessible to creator only. Advantages are referencing without specifying the owner and Flexibility to customize a more meaningful naming convention.

Indexes are optional structures associated with tables used to speed query execution and/or guarantee uniqueness. Create an index if there are frequent retrieval of fewer than 10-15% of the rows in a large table and columns are referenced frequently in the WHERE clause. Implied tradeoff is query speed vs. update speed. Oracle automatically update indexes. Concatenated index max. is 16 columns.

Data types
Max. columns in a table is 255. Max. Char size is 255, Long is 64K & Number is 38 digits.
Cannot Query on a long column.
Char, Varchar2 Max. size is 2000 & default is 1 byte.
Number(p,s) p is precision range 1 to 38, s is scale -84 to 127.
Long Character data of variable length upto 2GB.
Date Range from Jan 4712 BC to Dec 4712 AD.
Raw Stores Binary data (Graphics Image & Digitized Sound). Max. is 255 bytes.
Mslabel Binary format of an OS label. Used primarily with Trusted Oracle.

Order of SQL statement execution
Where clause, Group By clause, Having clause, Order By clause & Select.

Transaction is defined as all changes made to the database between successive commits.

Commit is an event that attempts to make data in the database identical to the data in the form. It involves writing or posting data to the database and committing data to the database. Forms check the validity of the data in fields and records during a commit. Validity check are uniqueness, consistency and db restrictions.

Posting is an event that writes Inserts, Updates & Deletes in the forms to the database but not committing these transactions to the database.

Rollback causes work in the current transaction to be undone.

Savepoint is a point within a particular transaction to which you may rollback without rolling back the entire transaction.

Set Transaction is to establish properties for the current transaction.

Locking are mechanisms intended to prevent destructive interaction between users accessing data. Locks are used to achieve.

Consistency : Assures users that the data they are changing or viewing is not changed until the are thro' with it.

Integrity
Assures database data and structures reflects all changes made to them in the correct sequence. Locks ensure data integrity and maximum concurrent access to data. Commit statement releases all locks. Types of locks are given below.
Data Locks protects data i.e. Table or Row lock.
Dictionary Locks protects the structure of database object i.e. ensures table's structure does not change for the duration of the transaction.
Internal Locks & Latches protects the internal database structures. They are automatic.
Exclusive Lock allows queries on locked table but no other activity is allowed.
Share Lock allows concurrent queries but prohibits updates to the locked tables.
Row Share allows concurrent access to the locked table but prohibits for a exclusive table lock.
Row Exclusive same as Row Share but prohibits locking in shared mode.
Shared Row Exclusive locks the whole table and allows users to look at rows in the table but prohibit others from locking the table in share or updating them.
Share Update are synonymous with Row Share.


Deadlock is a unique situation in a multi user system that causes two or more users to wait indefinitely for a locked resource. First user needs a resource locked by the second user and the second user needs a resource locked by the first user. To avoid dead locks, avoid using exclusive table lock and if using, use it in the same sequence and use Commit frequently to release locks.


Mutating Table is a table that is currently being modified by an Insert, Update or Delete statement. Constraining Table is a table that a triggering statement might need to read either directly for a SQL statement or indirectly for a declarative Referential Integrity constraints. Pseudo Columns behaves like a column in a table but are not actually stored in the table. E.g. Currval, Nextval, Rowid, Rownum, Level etc.

SQL*Loader is a product for moving data in external files into tables in an Oracle database. To load data from external files into an Oracle database, two types of input must be provided to SQL*Loader : the data itself and the control file. The control file describes the data to be loaded. It describes the Names and format of the data files, Specifications for loading data and the Data to be loaded (optional). Invoking the loader sqlload username/password controlfilename

Get 1500 Rewards Points with SBI Card

SBI Card has announced new way to earn up to 1500 rewards points on your SBI Card. In which you can earn reward points on your card just by doing some simple things mentioned by them.  If you register your SBI Credit Card at Sbicard.com and login at least 2 times during the offer period then you will get 200 rewards points.  Similarly you will 300 points if you can apply for an add-on card and shop using it at least once during the offer period.  Likewise you canearn 200 points and 100 points respectively for ATM PIN request with withdrawal at least once and subscribe to e-statements.

Lateral thinking

1.Acting on an anonymous phone call, the police raid a house to arrest a suspected murderer. They don't know what he looks like but they know his name is John and that he is inside the house. The police bust in on a carpenter, a lorry driver, a mechanic and a fireman all playing poker. Without hesitation or communication of any kind, they immediately arrest the fireman. How do they know they've got their man?

Ans-The fireman is the only man in the room. The rest of the poker players are women.

2. A man lives in the penthouse of an apartment building. Every morning he takes the elevator down to the lobby and leaves the building. Upon his return, however, he can only travel halfway up in the lift and has to walk the rest of the way - unless it's raining. What is the explanation for this?

Ans-The man is a dwarf. He can't reach the upper elevator buttons, but he can ask people to push them for him. He can also push them with his umbrella.

New Symbol for Indian Currency

 

           For Indians used to seeing the dollar symbol on the keyboard, this is a welcome change. While the basic aim of the new symbol is to provide the Indian rupee international recognition as the country’s economy exerts more influence in the global space, the unique sign will also help isolate the currency from the current abbreviation ‘Rs’ which is used by neighbouring Pakistan, Nepal and Sri Lanka. .The Indian rupee (Devanagari: रुपया) (sign: ; code: INR) is the official currency of India. The symbol, designed by Indian Institute of Technology (IIT) postgraduate D. Udaya Kumar.

Bank of India P.O.Exam 2010

1. The Business Correspondence Model being adopted by the banks provides Banking facilities to which of the following ?
(A) Only Corporate borrowers
(B) Only Weaker sections the society and people of small villages
(C) Only those who are taking housing loans
(D) All (A), (B) and (C) above
(E) None of these
Ans : (B)

2. The concept of ‘Carbon Credit’ is associated with which of the following areas ?
(A) Protection of environment
(B) Women empowerment
(C) Development of rural infrastructure
(D) Development of coal mines
(E) None of these
Ans : (A)

3. As we all know Government is paying much attention to improve Public Distribution System (PDS) in our country. Which of the following have been the achievements of the PDS uptill now, owing to which Government wants to further improve it ?
[Pick up correct statement(s).]
1. After implementing PDS in India, no famine was reported. PDS was always there to give people at least the bare minimum to survive.
2. A drought of 1987 was worst in this century but PDS played a vital role in overcoming the drought.
3. Now PDS is feeding the poorest of the poor in this country.
(A) Only 1
(B) Only 2
(C) Only 3
(D) All 1, 2 and 3 are correct
(E) None of these
Ans : (B)


4. Global Micro Credit Summit-2011 will be organized in which of the following countries ?
(A) Britain
(B) South Africa
(C) Spain
(D) Italy
(E) None of these
Ans : (C)

5. Many times we read about SHGs in financial newspapers. What is the full form of the term ?
(A) Small Help Groups
(B) Self Help Groups
(C) Small Hope in Growths
(D) Self Hope Groups
(E) None of these
Ans : (B)

6. Whenever newspapers talk about the performance of core industries, which of the following is not considered among them ?
(A) Petroleum
(B) Automobile
(C) Mining
(D) Steel
(E) Cement
Ans : (B)

7. Which of the following agencies/organizations in India maintains the Micro Finance Development and Equity Fund which was in news recently ?
(A) Confederation of Industries in India (CII)
(B) Indian Bank’s Association (IBA)
(C) Small Industries Development Bank of India (SIDBI)
(D) Reserve Bank of India (RBI)
(E) National Bank for Agriculture and Rural Development (NABARD)
Ans : (D)

8. As per recent newspaper reports UK based Cairn Energy is in the process of selling its stake to which one of the following companies of Indian base ?
(A) ONGC Videsh
(B) Hindustan Petroleum Corporation Ltd.
(C) Vedanta Resources
(D) Posco India
(E) None of these
Ans : (C)

9. Which of the following bills presented in the Parliament will bring some changes in existing tax regime ?
(A) Direct Taxes Code (DTC) Bill
(B) Foreign Exchange Management Regulatory Bill
(C) Companies Act Bill
(D) Salaries and Perks for MPs Bill
(E) Finance Bill 2010-11
Ans : (A)

10. Under Indira Gandhi National Old Age Pension Scheme (IGNOAPS), the benefits are available to the people having minimum age of …….
(A) 50 years
(B) 55 years
(C) 65 years
(D) 60 years
(E) 70 years
Ans : (C)

11. Mr. Katsuya Okada who was on a visit to India few months back is the Foreign Minister of—
(A) South Korea
(B) Myanmar
(C) Japan
(D) Thailand
(E) None of these
Ans : (C)

12. Govt. of India has decided to review its Foreign Direct Investment Rules twice in a year. This will be done from—
(A) 2015
(B) 2012
(C) 2014
(D) 2011
(E) None of these
Ans : (E)

13. Many times we read about ‘Hawala’ transactions in newspapers. Hawala in India is prohibited under the provision of which of the following Acts ?
(A) Fiscal Responsibility and Budget Management Act
(B) Banking Regulation Act
(C) Financial action Task Force Act
(D) Foreign Exchange Management Act
(E) None of these
Ans : (D)

14. India recently reviewed its trade relation policy with Russia. What are the main exports from India to Russia ?
1. Pharmaceuticals
2. Apparel and Clothing
3. Tea and Coffee
(A) Only 1
(B) Only 2
(C) All 1, 2 and 3
(D) Only 2 and 3
(E) Only 1 and 2
Ans : (A)

15. As we all know DIPP is the nodal agency in the field of foreign investments in India. What is the full form of DIPP ?
(A) Department of Industrial Policy and Promotion
(B) Department of Industrial Procedures and Promotions
(C) Directorate of Industrial Procedures and Promotions
(D) Directorate of Industrial Policy and Publicity
(E) None of these
Ans : (A)

16. ‘Israel and Palestinians open talks’ was the headline in some major newspapers. As we all know both the nations were not coming for the talks since 2008. Which of the following is the main dispute between these two nations ?
(A) Membership of World Trade Organisation
(B) Membership of G-20
(C) Selecting Syria, one of the major trade partners by Israel. Palestine is dead against it
(D) Redefining the boundaries as a major glacier between them has erased the same
(E) None of these
Ans : (E)

17. Many times we read about the performance of Asian Markets in various financial newspapers. Which of the following is not included in Asian Market ?
(A) Japan
(B) China
(C) Hong Kong
(D) South Korea
(E) Brazil
Ans : (E)

18. As per the figures released by the World Bank, which of the following countries was the largest recipient of loans from the World Bank during 2009-10 ?
(A) Bangladesh
(B) Pakistan
(C) Brazil
(D) China
(E) India
Ans : (E)

19. Which of the following has been fixed as the target for fiscal deficit 2010-11 ?
(In terms of percentage of GDP)
(A) 3%
(B) 3•5%
(C) 4%
(D) 5%
(E) 5•5%
Ans : (D)

20. As per news in various newspapers ‘kfw’ Group released another instalment of its financial aid to India. kfw is an organization/bank based in—
(A) France
(B) Japan
(C) Italy
(D) China
(E) Germany
Ans : (E)

21. Which of the following countries has become the main supplier of Defence goods to India and has replaced Russia ?
(A) Canada
(B) USA
(C) Israel
(D) France
(E) None of these
Ans : (C)

22. As per existing policy, new foreign investments in manufacturing of which of the following is not allowed ?
(A) White cement
(B) Plastic goods
(C) Cigarette and Cigars
(D) Polythene bags
(E) Pesticides
Ans : (C)

23. The Mixed Double of which of the following Lawn Tennis tournaments was won by Leander Paes along with Cara Black in 2010 ?
(A) Wimbledon
(B) US Open
(C) Australia Open
(D) Dubai Open
(E) None of these
Ans : (C)

24. Which of the following is not amongst the Prime Minister’s new 15 point programme ?
(A) Enhanced Credit Support for economic activities
(B) Modernizing Madarsa Education
(C) Improvement in condition of slums inhabited by minorities
(D) Free train journey for unemployed youths
(E) Rehabilitation of victims of communal riots
Ans : (D)

25. The Summit of Shanghai Cooperation Organisation was held in June in which of the following places ?
(A) Shanghai
(B) Moscow
(C) Tashkent
(D) Astana
(E) None of these
Ans : (C)

26. India’s political relations with its neighbouring countries are a critical part of its …….
(A) Industrial policy
(B) Trade policy
(C) Foreign policy
(D) Development policy
(E) None of these
Ans : (C)

27. Which of the following organizations of Indian Origin is helping Sri Lanka in rehabilitation of its war widows ?
(A) Khadi and Village Commission
(B) SEWA
(C) Action for Food Production
(D) Adhar
(E) Aasha
Ans : (B)

28. Who amongst the following became the first Cricketer to take 800 wickets in Test Cricket ?
(A) Kumar Sangakkara
(B) Saqlain Mustaq
(C) Anil Kumble
(D) Muttiah Murlitharan
(E) None of these
Ans : (D)

29. Which of the following agencies/organizations has decided to make major changes for ULIPs ?
(A) IRDA
(B) RBI
(C) AMFI
(D) FRBI
(E) None of these
Ans : (A)

30. The 16th SAARC Summit was organized in Thimpu. The declaration of the Summit was named as—
(A) Towards Green and Happy South Asia
(B) Silver Jubilee of SAARC
(C) Let us meet again in Delhi
(D) SAARC : The Future of South Asia
(E) None of these
Ans : (B)

31. Which of the following is the name of the programme launched by the Govt. of India to help lonely women by providing vocational training to make them self dependent ?
(A) Apnalaya
(B) Prayas
(C) Abhiyogyata
(D) Swadhar
(E) Swawlamban
Ans : (D)

32. Which of the following terms is not used in the game of Cricket ?
(A) Doosra
(B) Century
(C) Bouncer
(D) Love
(E) Ashes
Ans : (D)

33. Which of the following countries won the Asia Cup Cricket Tournament 2010 held in Sri Lanka ?
(A) Sri Lanka
(B) India
(C) Pakistan
(D) Bangladesh
(E) None of these
Ans : (B)

34. Mr. James Alix Michael who was on a visit to India recently is the President of ……
(A) Australia
(B) New Zealand
(C) Colombia
(D) Seychelles
(E) None of these
Ans : (D)

35. Trupti Murgunde whose name was in news recently is a—
(A) Badminton player
(B) Golf player
(C) Lawn Tennis player
(D) Table Tennis player
(E) Cricket player
Ans : (A)

36. Which of the following is not a financial term ?
(A) Acid Test
(B) Double Fault
(C) Gross Profit
(D) Depreciation
(E) Cash flow
Ans : (A)

37. In the terms of economics, the recession occurring two times with a small gap in between is known as—
(A) Double Deflation
(B) Deflation
(C) Deep Recession
(D) Double Dip Recession
(E) None of these
Ans : (A)

38. Saina Nehwal was in Paris recently to play in World Championship. She lost her match against whom amongst the following players ?
(A) Le Chong Wei
(B) Shixian Wang
(C) Taufik Hidayut
(D) Jung Eun
(E) None of these
Ans : (E)

39. Union Cabinet recently cleared 15000 crore Sukhoi deal. Sukhoi is—
(A) Battle tank
(B) Fighter plane
(C) Submarine
(D) Radar system
(E) None of these
Ans : (B)

40. Who amongst the following is the recipient of the Rajiv Gandhi Khel Ratna Award-2010 announced recently ?
(A) Pankaj Adwani
(B) Leander Paes
(C) Sania Mirza
(D) M. S. Dhoni
(E) None of these
Ans : (C)

41. Which of the following terms is not used in Economics ?
(A) Balance of Payment
(B) Call Money
(C) National Debt
(D) Elasticity of Demand
(E) Boyle’s law
Ans : (E)

42. Which of the following ministries /departments operates the ‘Village Grain Bank’s Schemes’ ?
(A) Ministry of Tribal Welfare
(B) Department of Food and Public Distribution
(C) Department of Social Welfare
(D) Ministry of Forest
(E) None of these
Ans : (B)

43. Which of the following countries recently conducted general election and became the first Parliamentary Democracy of Central Asia ?
(A) Turkmenistan
(B) Uzbekistan
(C) Kyrgyzstan
(D) Kazakhstan
(E) None of these
Ans : (C)

44. Which of the following books is written by Chetan Bhagat ?
(A) The Golden Gate
(B) Journey to Ithaca
(C) Fore on the Mountain
(D) The inheritance of Loss
(E) 2 States : The Story of My Marriage
Ans : (E)

45. Which of the following nations is the recent one to join Non-Aligned Movement (NAM) ?
(A) Fiji
(B) Cuba
(C) Sri Lanka
(D) Colombia
(E) Egypt
Ans : (A)

46. Hiroshima Day is observed on which of the following dates ?
(A) 6th August
(B) 16th August
(C) 6th September
(D) 16th September
(E) 26th July
Ans : (A)

47. Who amongst the following is the Chairperson of the Human Right’s Commission of India at present ?
(A) Prof. M. S. Swaminathan
(B) Justice K. G. Balakrishnan
(C) Justice A. R. Lakshmanan
(D) Justice P. V. Reddi
(E) None of these
Ans : (B)

48. ‘Booker Prize’ is given in the field of ……
(A) Literature
(B) Social service
(C) Films
(D) Science
(E) Sports
Ans : (A)

49. Which of the following games/sports is not included in the list of Commonwealth Games 2010 ?
(A) Table Tennis
(B) Hockey
(C) Weight lifting
(D) Golf
(E) Boxing
Ans : (D)

50. Dronacharya Awards are given to a person associated with—
(A) Education
(B) Social service
(C) Journalism
(D) Sports
(E) Films
Ans : (D)