SQL Server 2008

1. What are the basic functions for master, msdb, model, tempdb and resource databases?
   1. The master database holds information for all databases located on the SQL Server instance and is theglue that holds the engine together. Because SQL Server cannot start without a functioning masterdatabase, you must administer this database with care.
   2. The msdb database stores information regarding database backups, SQL Agent information, DTS packages, SQL Server jobs, and some replication information such as for log shipping.
   3. The tempdb holds temporary objects such as global and local temporary tables and stored procedures.
   4. The model is essentially a template database used in the creation of any new user database created in the instance.
   5. The resoure Database is a read-only database that contains all the system objects that are included with SQL Server. SQL Server system objects, such as sys.objects, are physically persisted in the Resource database, but they logically appear in the sys schema of every database. The Resource database does not contain user data or user metadata.
2. What is Service Broker?
   Service Broker is a message-queuing technology in SQL Server that allows developers to integrate SQL Server fully into distributed applications. Service Broker is feature which provides facility to SQL Server to send an asynchronous, transactional message. it allows a database to send a message to another database without waiting for the response, so the application will continue to function if the remote database is temporarily unavailable.
3. Where SQL server user names and passwords are stored in SQL server?
   They get stored in System Catalog Views sys.server_principals and sys.sql_logins.
4. What is Policy Management?
   Policy Management in SQL SERVER 2008 allows you to define and enforce policies for configuring and managing SQL Server across the enterprise. Policy-Based Management is configured in SQL Server Management Studio (SSMS). Navigate to the Object Explorer and expand the Management node and the Policy Management node; you will see the Policies, Conditions, and Facets nodes.
   

International - Latest Current Affairs

1.U.S. approves sale of Rs. 98,000 crore THAAD missiles to __________.

Iran Saudi Arabia South Korea Russia

2.Which country agrees to purchase S400 missile defence systems from Russia?

Pakistan Iraq Saudi Arabia Nigeria

3.Which country plans to help strengthen Myanmar's women police force?

Australia Pakistan Nepal India

4.With which country India signed a Mou on Technical Cooperation in Rail Sector?

Norway Malaysia Iraq Switzerland

5.Which countr launched world's largest nuclear-powered icebreaker ship Siberia?

Russia Japan China India

Business

1.Which of the following is India's best FMCG company in the food sector by the International Advertising Association (IAA)?

Patanjali Ayurved Nestle India Amul Dabur India

2.This company ties up with Bajaj Finserv to buy the products at no-cost EMI option.

Lenova Samsung LG Dell

3.With which company Andhra Pradesh ties up for Digital Dhan Sankalp project?

Mobikwik ICICI Pockets Visa Mswipe

4.With which company IIT Kharagpur signed MoU for Digital Academy?

Vodafone Samsung Apple Nokia

5.Which company inks Agreement with IREDA for Rs 300 cr Loan?

Reliance Commercial Finance HDFC Finance Peerless Group Hero fincorp

Important Days - Latest Current Affairs

1.28th September was observed as __________.

World Earth Day World Peace Day National Youth Day World Rabies Day

2.World Maritime Day is observed as ___________.

Sep 28th Sep 26th Sep 24th Sep 21st

3.Ministry of Rural Development conducted an event 'Antyodaya Diwas' on __________.

Sep 25th Sep 24th Sep 23rd Sep 22nd

4.24 September 2017 is observed as __________.

World Alzheimer's Day World Cancer Free Day World Coconut Day World Rivers Day

5.On which day, Indian Army celebrates 'Haifa Day'?

September 23 September 25 September 22 September 21

Politics - Latest Current Affairs

1.Who is selected as the President of India 2017?

Ram Nath Kovind Suresh Kumar Rajesh kumar Meira kumar

2.Which ministry launched the Talent Hunt for artists and give them a platform to showcase their talent on the national stage?

Minister of Environment and climate change Ministry of culture and tourism Ministry of Skill Development and Entrepreneurship Ministry of Labour and Employment

3.Who approves 20 lakh houses for urban poor approved under PM Awas Yojna recently?

Shri Venkaiah Naidu Shri Arun Jaitley Shri Naveen Patnaik Shri Suresh Menon

4.This ministry launched the Mission Retro-Fitment recently.

Ministry of Railways Ministry of Rural Development Ministry of Consumer Affairs Ministry of External Affair

5.Which ministry bans the cattle slaughter Across India?

Ministry of Environment Ministry of Civil Aviation Ministry of Human Resource Development Ministry of agriculture and Farmer welfare

Defence - Latest Current Affairs

1.Indian Navy's second CU (landing craft utility) Mark IV L52 ship was commissioned at __________.

Goa Chennai Mumbai Port Blair

2.Which country appoints First Tamil Navy Chief After Four Decades?

Russia Sri Lanka Australia Africa

3.What is the name of the ship which is Circumnavigating the Globe on an Indian-Built SailBoat INSV Tarini by Women Naval Officers?

USS Jimmy Carter USS Carl Vinson Surface Combalant Navika Sagar Parikrama

4.Which ship was commissioned at Goa by Indian Coast Guard?

Flagship Shaurya Santa Maria USS Arizona

5. India and this country hold Major Tri Service 'Indra' Combat Exrecise in October

Iraq Nigeria Russia South Korea

Famous Places in India

1.The Centre for Cellular and Molecular Biology is situated at

Patna Jaipur Hyderabad New Delhi

2.Where is the Railway Staff College located?

Pune Allahabad Vadodara Delhi

3.The famous Dilwara Temples are situated in

Uttar Pradesh Rajasthan Maharashtra Madhya Pradesh

4.Wadia Institute of Himalayan Geology is located at

Delhi Shimla Dehradun Kulu

5.Bijapur is known for its

severe drought condition Gol Gumbaz heavy rainfall statue of Gomateswara

Technology - GK

1.What frequency range is the High Frequency band?

100 kHz 1 GHz 30 to 300 MHz 3 to 30 MHz

2.The first step to getting output from a laser is to excite an active medium. What is this process called?

Pumping Exciting Priming Raising

3.Which motor is NOT suitable for use as a DC machine?

Permanent magnet motor Series motor Squirrel cage motor Synchronous motor

4.After the first photons of light are produced, which process is responsible for amplification of the light?

Blackbody radiation Stimulated emission Planck's radiation Einstein oscillation

5.Which is NOT an acceptable method of distributing small power outlets throughout an open plan office area?

Power Poles Power Skirting Flush Floor Ducting Extension Cords

Indian Geography

1.The Yarlung Zangbo river, in India, is known as

Ganga Indus Brahmaputra Mahanadi

2.The Salal Project is on the river

Chenab Jhelum Ravi Sutlej

3.The only zone in the country that produces gold is also rich in iron is

North-eastern zone North-western zone Southern zone None of the above

4.The percentage of earth surface covered by India is

2.4 3.4 4.4 5.4

5.The India's highest annual rainfall is reported at

Namchi, Sikkim Churu, Rajasthan Mawsynram, Meghalaya Chamba, Himachal Pradesh

Chemistry

1.The oldest rocks in the earth's crust were once molten, and came from deep inside the earth. The molten rock, called magma, spewed out in volcanic eruptions during the earth;s early life and solidified into hard rock's called

granite basalt igneous rocks sedimentary rocks

2.The law which states that the amount of gas dissolved in a liquid is proportional to its partial pressure is

Dalton's law Gay Lussac's law Henry's law Raoult's law

3. The gas present in the stratosphere which filters out some of the sun's ultraviolet light and provides an effective shield against radiation damage to living things is

helium ozone oxygen methane

4.The most commonly used bleaching agent is

alcohol carbon dioxide chlorine sodium chlorine

5.The heat required to raise the temperature of body by 1 K is called

specific heat thermal capacity water equivalent None of the above

Technology

1.What is part of a database that holds only one type of information?

Report Field Record File

2.'OS' computer abbreviation usually means ?

Order of Significance Open Software Operating System Optical Sensor

3.'.MOV' extension refers usually to what kind of file?

Image file Animation/movie file Audio file MS Office document

4.The purpose of choke in tube light is ?

To decrease the current To increase the current To decrease the voltage momentarily To increase the voltage momentarily

5.Who developed Yahoo?

Dennis Ritchie & Ken Thompson David Filo & Jerry Yang Vint Cerf & Robert Kahn Steve Case & Jeff Bezos

Honours and Awards

1. Pulitzer prize is awarded for outstanding work in the field of

Science and Technology Environmental Studies Literature and Journalism International Understanding

2.Saraswathi Samman is given annually for outstanding contribution to

classical music education literature fine arts

3.The first Indira Gandhi Award for International Justice and Harmony has been given to

Larry Pressler Amnesty International Hussain Ibrahim Zaki Yasser Arafat

4.'Ashoka Chakra' is awarded for

acts of gallantry in the presence of enemy gallantry by children outstanding contribution to literature the most conspicuous bravery or self sacrifice on land, air or sea but not in the presence of the enemy

5.Who among the following is the recipient of the first Dayawati Modi Award for art, culture and education?

Dharmavir Bharti Amitabh Bachchaan B. V. Karanth Ashok Vajpeyi

Indian Geography

1.The Paithan (Jayakwadi) Hydro-electric project, completed with the help of Japan, is on the river

Ganga Cauvery Narmada Godavari

2.The percentage of irrigated land in India is about

45 65 35 25

3.The southernmost point of peninsular India, that is, Kanyakumari, is

north of Tropic of Cancer south of the Equator south of the Capricorn north of the Equator

4.The pass located at the southern end of the Nilgiri Hills in south India is called

the Palghat gap the Bhorghat pass the Thalgat pass the Bolan pass

5.The principal copper deposits of India lie in which of the following places?

Hazaribag and Singbhum of Bihar Khetri and Daribo areas of Rajasthan Anantapur in Andhra Pradesh Siwaliks in Uttar Pradesh and in Karnataka

Chemistry

1.The nucleus of an atom consists of

electrons and neutrons electrons and protons protons and neutrons All of the above

2.The number of moles of solute present in 1 kg of a solvent is called its

molality molarity normality formality

3.The most electronegative element among the following is

sodium bromine fluorine oxygen

4.The metal used to recover copper from a solution of copper sulphate is

Na Ag Hg Fe

5.The metallurgical process in which a metal is obtained in a fused state is called

smelting roasting calcinations froth floatation

Books and Authors

1.Who wrote the famous book - 'We the people'?
T.N.Kaul J.R.D. Tata Khushwant Singh Nani Palkhivala

2.Who is the author of the book 'Nineteen Eighty Four'?
Thomas Hardy Emile Zola George Orwell Walter Scott

3.Who is the author of the book 'Forbidden Verses'?
Salman RushDie Abu Nuwas Ms. Taslima Nasrin D.H. Lawrence

4.The lead character in the film 'The Bandit Queen' has been played by
Rupa Ganguly Seema Biswas Pratiba Sinha Shabama Azmi

5.Who wrote the line: ' A thing of beauty is a joy forever'?
John Keats Robert Browing P.B.Shelley William Wordsworth

Public Service Commission QP

1. Ranchi city is located in
Bihar
Madhya Pradesh
Orissa
Jharkhand

2. The 47.78 percent irrigation potential of India is created through
Major Project
Minor project Major Project
Minor Projects
Medium Projects

3. The Railway zone head quarters Hajipur is located in
Chhattisgarh
Uttar Pradesh
Jharkhand
Bihar

4. Indian Development Forum (IDF) was earlier known as:
Aid India Consortium
Aid India Bank
World Bank
None of the above

5. It will be true to classify India as
A food-deficit economy
A labour-surplus economy
A trade surpluses economy
A capital surplus economy

Public Service Commission QP

1. Swine flu is caused by

(A) bacteria
(B) virus
(C) protozoa
(D) fungi

2. How many members are there in the Rajya Sabha from Assam?

(A) 7
(B) 5
(C) 8
(D) 6

3. The States which have common boundaries with Bangladesh are

(A) Bihar, West Bengal, Tripura, Assam
(B) Manipur, Tripura, Assam, Meghalaya, West Bengal
(C) West Bengal, Assam, Meghalaya, Tripura, Mizoram
(D) Manlpur, Assam, Meghalaya, Tripura

4. The slogan of the Commonwealth Games-2010 held in New Delhi was

(A) Get out and play
(B) Come here and play
(C) Come out and play
(D) Jiyo Utho Badho

5. Which one of the following States is not touched by Tropic of Cancer?

(A) Madhya Pradesh
(B) Mizoram
(C) Bihar
(D) Chhattisgarh

All India Service Commissions exams - GK

1. The capital of British India was shifted to Delhi in the year

(A) 1908
(B) 1911
(C) 1937
(D) 1947

2. Indian National Army was headed by

(A) Netaji Subhas Chandra Bose
(B) General Cariappa
(C) A. G. Khan
(D) M. N. Roy

3. The Swadeshi Movement started during

(A) Anti Bengal Partition Movement
(B) Non-Cooperation Movement
(C) Civil Disobedience Movement
(D) None of the above

4. How are latitude and Longitude lines drawn on a globe of the earth?

(A) Latitude lines are parallel and longitude lines meet at the equator
(B) Longitude lines are parallel and latitude lines meet at the equator                   
(C) Latitude lines are parallel and longitude lines meet at the poles
(D) longitude lines are parallel and latitude lines meet at the poles

5. Which radioactive isotope is most useful for nuclear power generation?

(A) Uranium-238
(B) Uranium-235                           
(C) Carbon-14
(D) Rubidium-87

Combined Competitive (Preliminary) Examination

1. Which of the following types of budgeting is followed in India?

(A) Plural budgeting
(B) Cash budgeting
(C) performance budgeting
(D) Surplus budgeting

2. Which of the following Articles of the Constitution of India is related to the independence of the Union Public Service Commission?

(A) Article 323
(B) Article 324
(C) Article 325
(D) Article 326

3. Which of the following Schedules to the Constitution of India relates to languages?

(A) 7th Schedule
(B) 8th Schedule
(C) 9th Schedule
(D) 10th Schedule

4. Which of the following is not a part of the financial management?

(A) Preparation of the budget
(B) Approval of the budget by the Cabinet
(C) Execution and rendering of accounts
(D) Audit and accounts of public expenditure

5. Who initiated the Home Rule Movement in India?

(A) Chittaranjan Das
(B) Lajpat Rai
(C) Annie Besant
(D) Maulana Azad

Combined Competitive (Preliminary) Examination

1. Pacemaker is implanted in heart when one of the following is defective

(A) SA node
(B) AV node
(C) Purkinje fibre
(D) Bundle of His

2. When a person is undergoing prolonged fasting, his/her urine will contain abnormal quantity of

(A) fat
(B) ketone
(C) amino acid
(D) glucose

3. Science of improving human race is

(A) eugenics
(B) epigenesis
(C) epistasis
(D) euthenics

4. A photon will have less energy, if its

(A) amplitude is higher
(B) frequency is higher
(C) wavelength is longer
(D) wavelength is shorter

5. Liquefied petroleum gas (LPG) is mainly a mixture of

(A) propane and butane
(B) butane and isobutane
(C) propane and isobutane
(D) propane and tetralin