Explore topic-wise InterviewSolutions in Current Affairs.

This section includes 7 InterviewSolutions, each offering curated multiple-choice questions to sharpen your Current Affairs knowledge and support exam preparation. Choose a topic below to get started.

1.

The ‘Namami Gange Programme’ is an Integrated Conservation Mission approved by the Union Government in:1. June 2014 2. October 20133. April 20134. January 2014

Answer» Correct Answer - Option 1 : June 2014 

The correct answer is June 2014.

  • Namami Gange Programme is an Integrated Conservation Mission, approved as ‘Flagship Programme’ by the Union Government in June 2014 with budget outlay of Rs.20,000 Crore to accomplish the twin objectives of effective abatement of pollution, conservation and rejuvenation of national River Ganga. 
  • Salient features of "Namami Gange" programme
    • Over Rs. 20,000 crore has been sanctioned in the 2014-2015 budget for the next 5 years.
    • It will cover 8 states, 47 towns &12 rivers under the project.
    • Over 1,632-gram panchayats on the banks of Ganga to be made open defecation-free by 2022.
    • Several ministries are working with the nodal Water Resources Ministry for this project includes - Environment, Urban Development, Shipping, Tourism and Rural Development Ministries.
    • Prime focus will be on involving people living on the river's banks in this project.
    • Under the aegis of National Mission for Clean Ganga (NMCG) & State Program Management Groups (SPMGs) States and Urban Local Bodies and Panchayati Raj institutions will be involved in this project.
    • Setting a river-centric urban planning process to facilitate better citizen connects, through interventions at Ghats and Riverfronts.
    • Expansion of coverage of sewerage infrastructure in 118 urban habitations on banks of Ganga.
    • Development of rational agricultural practices & efficient irrigation methods and Ganga Knowledge Centre.
  • In order to implement Namami Gange Programme, a three-tier mechanism has been proposed for project monitoring comprising of; 
    • ​A high-level task force chaired by Cabinet Secretary assisted by NMCG at the national level.
    • State level committee chaired by Chief Secretary assisted by SPMG at the state level, and
    • District level committee chaired by the District Magistrate.
  • NMCG shall carry out the following key functions:-
    • Implement the work program of National Ganga River Basin Authority (NGRBA).
    • Implement the World Bank supported National Ganga River Basin Project.
    • Coordinate and oversee the implementation of projects sanctioned by Government of India under NGRBA.
    • Undertake any additional work or functions as may be assigned by Ministry of Water Resources, Rural development & GJ in the area of conservation of river Ganga.
    • Make rules and regulations for the conduct of the affairs of the NMCG and add or amend, vary or rescind them from time to time.
    • Accept or to provide any grant of money, loan securities or property of any kind and to undertake and accept the management of any endowment trust, fund or donation not inconsistent with the objectives of NMCG.
    • Take all such action and to enter all such actions as may appear necessary or incidental for the achievements of the objectives of the NGRBA.
2.

The least number of molecules are present inA. 2 gm of hydrogen gasB. 8 gm of oxygen gasC. 4 gm of nitrogen gasD. 16 gm of `CO_(2)` (g)

Answer» Correct Answer - C
(A) Mole of `H_(2)=(2)/(2)=1" mol "=1N_(A)` molecule
(B) Mole of `O_(2)=(8)/(32)=(1)/(4)" mol "=(N_(A))/(4)` molecule
(C ) Mole of `N_(2)=(4)/(28)=(1)/(7)" mol "=N_(A)/(7)` molecule
(D) Mole of `CO_(2)=(16)/(44)=(4)/(11)" mole "=(4N_(A))/(11)` molecule
3.

A suitable unit for gravitational constant isA. `kg-msec^(-1)`B. `Nm^(-1)sec`C. `Nm^2kg^(2)`D. `kgmsec^(-1)`

Answer» Correct Answer - C
`F=(Gm_(1)m_(2))/(d^2)` `because` `G=(fd^2)/(m_1m_2)=(Nm^2)/(kg^2)`
4.

The De-broglie wavelength of a tennis ball of mass 66 g moving with the velocity of 10 metre per second is approximately :A. `10^(-35)` metresB. `10^(-33)` metresC. `10^(-31)` metresD. `10^(-36)` metres

Answer» Correct Answer - B
De-broglie wavelength
`lambda=h/(mv)=(6.62xx10^(-34))/(66xx10^(-3)xx10)=10^(-33) M`
5.

A proton when accelerated through a potential difference of V volt has a wavelength `lamda` associated with it. An alpha-particle in order to have the same `lamda` must be accelerated through a potential difference ofA. V voltB. 4V voltC. 2V voltD. `V/8` volt

Answer» Correct Answer - D
`lambda=h/(sqrt(2m_peV))`..(i)
`lambda=h/(sqrt(2m_alpha(2e)V_alpha))`..(ii)
equation (i) &(ii) we have
`2m_peV=2xx4xxm_pxx2eV_alpha`
`implies V_alpha=V/8`
6.

The photon emitted due to electronic transition of `5^(th)` excited state to `2^(nd)` excited state in `Li^(2+)`, is used to excite `He^+` already in first excited state.`He^+` ion after absorbing the photon reaches in an orbit having total energy equal to :A. `-3.4 eV`B. `-13.6 eV`C. `-6.8 eV`D. `-27.2 eV`

Answer» Correct Answer - A
(A)For `Li^(2+)`, n=6 to n=3
For H, the similar transition is 2 to 1
For `He^+` , the similar transition is 4 to 2
Energy of `4^(th)` orbit of `He^(+)` =`-13.6xx2^2/4^2= -3.4 eV`
7.

Machine Control instructions

Answer»

Machine Control instructions

The Machine control instructions control the bus usage and execution 

i. WAIT – Wait for Test input pin to go low. 

ii. HLT – Halt the process. 

iii. NOP – No operation. 

iv. ESC – Escape to external device like NDP 

v. LOCK – Bus lock instruction prefix. 

17

8.

Flag Manipulation and a Processor Control Instructions

Answer»

Flag Manipulation and a Processor Control Instructions :

These instructions control the functioning of the available hardware inside the processor chip. 

These instructions are categorized into two types: 

1. Flag Manipulation instructions.

Machine Control instructions. Flag Manipulation instructions The Flag manipulation instructions directly modify some of the Flags of 8086.

i. CLC – Clear Carry Flag. 

ii. CMC – Complement Carry Flag. 

iii. STC – Set Carry Flag. 

iv. CLD – Clear Direction Flag. 

v. STD – Set Direction Flag. 

vi. CLI – Clear Interrupt Flag. 

vii. STI – Set Interrupt Flag.

9.

String Manipulation Instructions

Answer»

String Manipulation Instructions 

A series of data byte or word available in memory at consecutive locations, to be referred as Byte String or Word String. A String of characters may be located in consecutive memory locations, where each character may be represented by its ASCII equivalent. 

The 8086 supports a set of more powerful instructions for string manipulations for referring to a string, two parameters are required.

I. Starting and End Address of the String.

II. Length of the String. 

The length of the string is usually stored as count in the CX register.The incrementing or decrementing of the pointer, in string instructions, depends upon the Direction Flag (DF) Status. If it is a Byte string operation, the index registers are updated 15 by one. On the other hand, if it is a word string operation, the index registers are updated by two. 

REP : Repeat Instruction Prefix 

This instruction is used as a prefix to other instructions, the instruction to which the REP prefix is provided, is executed repeatedly until the CX register becomes zero (at each iteration CX is automatically decremented by one).

i. REPE / REPZ - repeat operation while equal / zero. 

ii. REPNE / REPNZ - repeat operation while not equal / not zero. 

These are used for CMPS, SCAS instructions only, as instruction prefixes.

MOVSB / MOVSW :Move String Byte or String Word

Suppose a string of bytes stored in a set of consecutive memory locations is to be moved to another set of destination locations.The starting byte of source string is located in the memory location whose address may be computed using SI (Source Index) and DS (Data Segment) contents. 

The starting address of the destination locations where this string has to be relocated is given by DI (Destination Index) and ES (Extra Segment) contents.

CMPS : Compare String Byte or String Word 

The CMPS instruction can be used to compare two strings of byte or words. The length of the string must be stored in the register CX. If both the byte or word strings are equal, zero Flag is set. 

The REP instruction Prefix is used to repeat the operation till CX (counter) becomes zero or the condition specified by the REP Prefix is False. 

SCAN : Scan String Byte or String Word 

This instruction scans a string of bytes or words for an operand byte or word specified in the register AL or AX. The String is pointed to by ES:DI register pair. The length of the string s stored in CX. The DF controls the mode for scanning of the string. Whenever a match to the specified operand, is found in the string, execution stops and the zero Flag is set. If no match is found, the zero flag is reset. 

LODS : Load String Byte or String Word 

The LODS instruction loads the AL / AX register by the content of a string pointed to by DS : SI register pair. The SI is modified automatically depending upon DF, If it is a byte transfer (LODSB), the SI is modified by one and if it is a word transfer (LODSW), the SI is modified by two. No other Flags are affected by this instruction. 16 

STOS : Store String Byte or String Word 

The STOS instruction Stores the AL / AX register contents to a location in the string pointer by ES : DI register pair. The DI is modified accordingly, No Flags are affected by this instruction. 

The direction Flag controls the String instruction execution, The source index SI and Destination Index DI are modified after each iteration automatically. If DF=1, then the execution follows autodecrement mode, SI and DI are decremented automatically after each iteration. If DF=0, then the execution follows autoincrement mode. In this mode, SI and DI are incremented automatically after each iteration.

10.

Branch Instructions

Answer»

Branch Instructions : 

Branch Instructions transfers the flow of execution of the program to a new address specified in the instruction directly or indirectly. When this type of instruction is executed, the CS and IP registers get loaded with new values of CS and IP corresponding to the location to be transferred. 

The Branch Instructions are classified into two types 

i. Unconditional Branch Instructions. 

ii. Conditional Branch Instructions. 

Unconditional Branch Instructions : 

In Unconditional control transfer instructions, the execution control is transferred to the specified location independent of any status or condition. The CS and IP are unconditionally modified to the new CS and IP. 

CALL : Unconditional Call 

This instruction is used to call a Subroutine (Procedure) from a main program. Address of procedure may be specified directly or indirectly. There are two types of procedure depending upon whether it is available in the same segment or in another segment. 

i. Near CALL i.e., ±32K displacement. 

ii. For CALL i.e., anywhere outside the segment. 

On execution this instruction stores the incremented IP & CS onto the stack and loads the CS & IP registers with segment and offset addresses of the procedure to be called. 

RET: Return from the Procedure. 

At the end of the procedure, the RET instruction must be executed. When it is executed, the previously stored content of IP and CS along with Flags are retrieved into the CS, IP and Flag registers from the stack and execution of the main program continues further. 

INT N: Interrupt Type N. 

In the interrupt structure of 8086, 256 interrupts are defined corresponding to the types from 00H to FFH. When INT N instruction is executed, the type byte N is multiplied by 4 and the contents of IP and CS of the interrupt service routine will be taken from memory block in 0000 segment.

13

INTO: Interrupt on Overflow 

This instruction is executed, when the overflow flag OF is set. This is equivalent to a Type 4 Interrupt instruction. 

JMP: Unconditional Jump 

This instruction unconditionally transfers the control of execution to the specified address using an 8-bit or 16-bit displacement. No Flags are affected by this instruction. 

IRET: Return from ISR 

When it is executed, the values of IP, CS and Flags are retrieved from the stack to continue the execution of the main program. 

LOOP : LOOP Unconditionally 

This instruction executes the part of the program from the Label or address specified in the instruction upto the LOOP instruction CX number of times. At each iteration, CX is decremented automatically and JUMP IF NOT ZERO structure. 

Example: MOV CX, 0004H

MOV BX, 7526H

Label 1 MOV AX, CODE

OR BX, AX 

LOOP Label 1

Conditional Branch Instructions 

When this instruction is executed, execution control is transferred to the address specified relatively in the instruction, provided the condition implicit in the Opcode is satisfied. Otherwise execution continues sequentially. 

JZ/JE Label 

Transfer execution control to address ‘Label’, if ZF=1. 

JNZ/JNE Label 

Transfer execution control to address ‘Label’, if ZF=0 

JS Label 

Transfer execution control to address ‘Label’, if SF=1.

JNS Label 

Transfer execution control to address ‘Label’, if SF=0.

JO Label 

Transfer execution control to address ‘Label’, if OF=1.

14

JNO Label 

Transfer execution control to address ‘Label’, if OF=0. 

JNP Label 

Transfer execution control to address ‘Label’, if PF=0. JP Label Transfer execution control to address ‘Label’, if PF=1. 

JB Label 

Transfer execution control to address ‘Label’, if CF=1. 

JNB Label 

Transfer execution control to address ‘Label’, if CF=0. JCXZ Label Transfer execution control to address ‘Label’, if CX=0 

Conditional LOOP Instructions. 

LOOPZ / LOOPE 

Label Loop through a sequence of instructions from label while ZF=1 and CX=0. LOOPNZ / LOOPENE Label Loop through a sequence of instructions from label while ZF=1 and CX=0.

11.

Explain snapshot replication.

Answer»

Snapshot replication can be used when an application does not require that the data always be current. These applications can be updated by periodic table copying or snapshots. As part of the snapshot effort, all of the data to be included in the snapshot is collected at a primary point. Then a read-only snapshot is taken and the snapshot is sent to each site so that the update can be made.

12.

Explain concurrency transparency.

Answer»

Concurrency transparency is where each transaction in a distributed database is treated as if it is the only one in the system. Therefore if several transactions are running at one time, the results will be the same as if each transaction was run in serial order. The transaction manager helps to provide concurrency control. The three methods that may be used are locking, versioning, and timestamping.

13.

In the following circuit if key K is pressed then the galvanometer reading becomes half. The resistance of galvanometer is(a) 20 Ω (b) 30 Ω (c) 40 Ω (d) 50 Ω

Answer»

Correct option (c) 40 Ω

Explanation:

Galvanometer reading becomes half means current distributes equally between galvanometer and resistance of 40 Ω. Hence galvanometer resistance must be 40 Ω.

14.

What is the difference between horizontal and vertical partitioning?

Answer»

Horizontal partitioning is where some rows of a table are placed into the base relations at one site and other rows are placed at another site. Vertical partitioning is where some columns of a table are placed into the base relations at one site and other columns are placed at another site but each all of these relations must share a common domain.

15.

What is market basket analysis?

Answer»

Market basket analysis is a data mining technique that determines which sets of products tend to be purchased together. A common technique uses conditional probabilities. 

In addition to the basic probability that an item will be purchased, three results are of particular interest:

Support - the probability of two items being purchased together.

Confidence - the probability of a second item being purchased GIVEN that another item has been purchased.

Lift - calculated as confidence divided by a basic probability, this shows the likelihood of a second item being purchased IF an item is purchased.

16.

हिन्दी गद्य-शिक्षण को पाठ-योजना में उद्देश्य-कथन आता है1. पूर्वज्ञान के पश्‍चात्2. प्रस्‍तावना प्रश्‍न के पश्‍चात्3. आदर्श वाचन के पश्‍चात्4. मौन वाचन के पहले

Answer» Correct Answer - Option 2 : प्रस्‍तावना प्रश्‍न के पश्‍चात्
पाठयोजना हेतु प्रारूप:
  • पाठयोजना बनाने तथा पाठयोजना के प्रत्येक चरण को लिखने के लिए कई प्रकार के प्रारूप होते है।
  • परम्परागत पाठयोजना में सामान्य उद्देश्य, विशिष्ट उद्देश्य, सहायक सामग्री, पूर्व ज्ञान, प्रस्तावना, उद्देश्य कथन, शिक्षण विधि. बोध प्रश्न, श्यामपट्ट सारांश, मूल्यांकन, पुनरावृत्ति, गृह कार्य आदि होते है।

अतः हम कह सकते हैं कि हिन्दी गद्य-शिक्षण को पाठ-योजना में उद्देश्य-कथन प्रस्‍तावना प्रश्‍न के पश्‍चात् आता है।

पाठयोजना के पद निम्नवत है-

(क) सामान्य उद्देश्य(General Objective)- पाठयोजना बनाते समय या उसको लिखिते समय सबसे पहले सामान्य उद्देश्य निर्धारित कर लिखे जाते है सामान्य उद्देश्य के अन्तर्गत सम्बन्धित विषय के शिक्षण उद्देश्य को सम्मिलित किया जाता है जो हमारे दैनिक जीवन में व्यवहार परिवर्तन को सम्बोधित करता है। जैसे-
  • बच्चों की हिंदी भाषा में रूचि विकसित करना।
  • छात्रों में शुद्ध व स्पष्ट हिंदी भाषा पढ़ने व लिखने की क्षमता का विकास करना।
  • छात्रों के शब्द भण्डार में वृद्धि करना।
  • छात्रों में सृजनात्मक शक्ति का विकास करना।
  • छात्रों में स्पष्ट अभिव्यक्ति की क्षमता रृका विकास करना।
(ख) विशिष्ट उद्देश्य (Specific Objective)-
विशिष्ट उद्देश्य के अन्तर्गत पढ़ाये जाने वाले प्रकरण के उद्देश्य निर्धारित किये जाते है। विशिष्ट उद्देश्य से पाठ की समाप्ति पर किन शिक्षण सम्बन्धी परिणामों की प्राप्ति होगी, यह स्पष्ट होना चाहिए। विशिष्ट उद्देश्य वे कथन है जो सीखने-सिखाने की प्रक्रिया के उपरान्त छात्रों के ज्ञान, दृष्टिकोण और कौशल के सन्दर्भ में शिक्षण सम्बन्धी परिणामों (Learning Outcomes) का वर्णन करते है। जैसे- विमल बिंदु की विशाल किरणों के लिए बनी पाठ योजना के उद्देश्य-
  • छात्र विमल बिंदु की विशाल किरणों के महत्व को जान सकेंगे।
  • छात्र विमल बिंदु की विशाल किरणों से संबंधित चार्ट माॅडल बना सकेंगे।
  • छात्र विमल बिंदु की विशाल किरणों से जुड़े महतवपूर्ण बिंदुओं पर चर्चा कर सकेंगे।
(ग) सहायक सामग्री-
पाठयोजना में आवश्यक शिक्षण सामाग्री (Required Teaching Material) का उल्लेख किया जाता है, जिसके अन्तर्गत कक्षा-शिक्षण में प्रयोग किये जाने वाली सामग्रियों व टी०एल०एम० का उल्लेख किया जाता है।
  • चार्ट, माॅडल, श्यामपट्ट आदि।
(घ) पूर्व ज्ञान(Previous Knowledge)-
शिक्षण प्रारंभ करने से पूर्व बच्चों के पूर्व ज्ञान के आकलन हेतु गतिविधियों का उल्लेख किया जाए इसके अन्तर्गत यह स्पष्ट रूप से अंकित किया जाना चाहिये कि पढ़ाये जाने वाले प्रकरण से सम्बन्धित पूर्व कक्षा/वादन में क्या पढ़ाया गया था या सिखाया गया था। पूर्व ज्ञान परिवेश से जुड़ा भी हो सकता है। जैसे-
  • छात्र मल बिंदु की विशाल किरणों से संबंधितत सामान्य जानकारी रखते हैं।
(ड़) प्रस्तावना (Introduction)- प्रस्तावना पढ़ाये जाने वाले विषय तक पहुँचने का माध्यम होती है। प्रस्तावना कई प्रकार से हो सकती है जैसे कि प्रश्न द्वारा या अन्य प्रकार से। प्रस्तावना प्रश्नों का डिजाइन इस प्रकार से तैयार किया जाना चाहिए कि उन प्रश्नों से बच्चों की पढ़ाये जाने वाले पाठ या विषयवस्तु के प्रति सोच की जानकारी मिले। प्रस्तावना प्रश्नों में पूर्व ज्ञान व पढ़ायी जाने वाली विषयवस्तु से समन्वय होना चाहिये। जैसे-
छात्राध्यापक क्रियाविद्यार्थी क्रिया
रात के समय आकाश में क्या दिखायी देते हैं?चन्द्रमा, तारें
चन्द्रमा के पर्यायवाची शब्द कौन-कौन से हैं?सुधाकर, मयंक, सोम, राकेश, इंदु
इंदु पृथ्वी पर क्या फैलाता है?रोशनी, प्रकाश की किरणें
'विमल इंदु की विशाल किरणें' कविता के बारे में बताओ।समस्यात्मक प्रश्न
(च) उद्देश्य कथन (Statement of Aim)- प्रस्तावना के बाद शिक्षक बच्चों के समक्ष पढ़ाये जाने वाले पाठ/विषयवस्तु को स्पष्ट करेंगे इसका उल्लेख पाठयोजना में होना चाहिए। जैसे-
  • विद्यार्थियों आज हम 'विमल इंदु की विशाल किरणें' कविता के बारे में अध्ययन करेंगे।
(छ) शिक्षण विधि (Teaching Method and Transaction)- इसके अन्तर्गत पाठ के विकास एवं प्रस्तुतीकरण की विधियों का उल्लेख होगा तथा शिक्षक द्वारा सम्बन्धित प्रकरण का शिक्षण किया जाएगा। अध्याय /प्रकरण का विस्तार प्रश्नोत्तर विधि / व्याख्यान/ गतिविधि/ समूह कार्य टी०एल०एम०/आई0सी0टी0 के प्रयोग तथा अन्य शिक्षण विधियों के माध्यम से किया जा सकता है। यहाँ पर शिक्षक एक या एक अधिक शिक्षण विधियों का प्रयोग कर सकता हैं।
(ज) आकलन हेतु बोध प्रश्न ज्ञान, समझ व कौशल का आकलन (Test of Comprehen- sion) - इसके अंतर्गत पढ़ाये गये विषय में विकसित हुई समझ के आंकलन हेतु प्रयोग की जाने वाली परम्परागत विधियों तथा नवीन विविधों /प्रविधियों का उल्लेख होना चाहिए।
(झ) श्यामपट्ट सारांश (Black-board Summary)- पढ़ायी गयी विषयवस्तु का संक्षेप में यथा आवश्यकता श्यामपट्ट पर अंकन किया जाए। फ्लो डायग्राम चित्र आदि का प्रयोग संक्षिप्तीकरणमें किया जा सकता है अथवा इस हेतु पी0पी0टी0 का भी प्रयोग कर सकते है। यह सामग्रीपाठयोजना में प्रदर्शित होनी चाहिए।
(ञ) मूल्यांकन (Evaluation)- विशिष्ट उद्देश्य / शिक्षण सम्बन्धी परिणाम की सम्प्राप्ति के सापेक्ष ही प्रश्नों/गतिविधियों द्वारा बच्चों के ज्ञानात्मक, बोधात्मक, कियात्मक, मनोप्रेरणा पक्षों का मूल्यांकन करते हुए आकलन किया जाना चाहिए । मूल्यांकन से सम्बन्धित प्रश्न और गतिविधियों पाठयोजना में प्रदर्शित होनी चाहिए। प्रत्येक विशिष्ट उद्देश्य के सापेक्ष प्रश्न और गतिविधि निर्धारित होनी चाहिए. जिससे शिक्षक द्वारा यह आकलन किया जा सके कि उसके द्वारा निर्धारित किये गये विशिष्ट उद्देश्यों की प्राप्ति हुई है अथवा नहीं।
(ट) गृह कार्य (Home Assignment)- गृहकार्य में ऐसी गतिविधियों का समावेश हो जिससे बच्चों के सृजनात्मकता, समस्या समाधान, तार्किक क्षमता, चिन्तन आदि का विकास हो सके तथा वह मूल्यांकन/मापन योग्य
17.

What is a distributed database?

Answer»

A distributed database is a single logical database that is spread across more than one node or locations that are all connected via some communication link. It requires multiple DBMSs, running at each remote site. A distributed database can be either homogenous (same DBMS at each node) or heterogeneous (different DBMS at some nodes).

18.

Describe the difference between homogeneous and heterogeneous distributed database.

Answer»

A homogenous database is one that uses the same DBMS at each node. Either each node can work independently or a central DBMS may coordinate database activities. A heterogeneous database is one that may have a different DBMS at each node. It may support some or all of the functionality of one logical database. It may support full Distributed DBMS functionality or partial Distributed DBMS functionality.

19.

Explain issues for database performance.

Answer»

The installation of the database is an important issue since the better the installation, the better the performance could be. Memory usage is learning how the DBMS uses main memory and then using that knowledge to enable better performance. I/O is usually very intense in a DB, so understanding how users will use the data will help to prepare the database better. CPU usage and application tuning are also important considerations.

20.

What is OLAP?

Answer»

Online Analytical Processing (OLAP) is a Business Intelligence (BI) reporting system. OLAP provides the user with the capability to sum, count, average and do other simple arithmetic operations on groups of data. An OLAP report has measures and dimensions. Measures are the data values to be displayed. Dimensions are characteristics of the measures. OLAP reports are called OLAP cubes, although such reports are not limited to three dimensions.

21.

9. The teacher said, “When iron is heated, it expands.”

Answer»

The teacher explained that Iron expands on heating.

22.

What are the functions of a reporting system?

Answer»

A reporting system has three functions: 

1. Report authoring - connecting to data sources, creating the report structure and formatting the report. 

2. Report management - defining who receives which reports, when they receive them and how the reports are delivered. 

3. Report delivery - based on report management metadata, either pushing the reports to the recipients or allowing them to be pulled by the recipients.

23.

Explain locking.

Answer»

Locking is denying others the ability to update a record until someone completes the update or releases the record. Locking can occur on many different levels in a database. It can occur at the database, table, record, or field level. A lock can be shared (another can read the record while an update is in progress) or exclusive (no one can read the record while an update is in progress).

24.

8. The man asked, “Will the shopkeeper deduct the price of the goods so that I can buy them?”

Answer»

The man asked if the shopkeeper would deduct the price of the good so that he could buy them.

25.

What is arithmetic operation in 8086?

Answer»

The 8086 provides many arithmetic operations: 

addition, subtraction, negation, multiplication and comparing two values.

26.

Describe concurrency control.

Answer»

Concurrency control is the process managing simultaneous operations against a database so that database integrity is not compromised. There are two approaches to concurrency control. The pessimistic approach involves locking and the optimistic approach involves versioning.

27.

What is RFM analysis?

Answer»

RFM analysis is a Business Intelligence (BI) reporting system that analyzes and ranks customers based on their purchasing patterns. R refers to "how recently" a customer placed an order, F refers to "how frequently" the customer orders, and M refers to "how much money" the customer spends. Typically, the customers are ranked into "20%" groups and assigned a number to represent their ranking. Thus 1 means top 20%, 2 the next 20% and so on. In this system a score of 1 is best and a score of 5 is worst. Thus a customer with an RFM score = 1 5 1 would be one who has ordered recently, does not order frequently, and who makes large purchases.

28.

What are some of the important security features of a DBMS?

Answer»

One of the features includes the use of views which allows the presentation of only data needed by someone and limits the capability of database updates. The use of integrity controls includes such things as domains, assertions, and checks. Also authorization rules, user-defined procedures, encryption, authentication schemes, and backups are important.

29.

Describe the difference between data and database administration.

Answer»

Data administration is responsible for the overall management of data resources. Some of the core roles include the creation of data polices, procedures and standards, resolve data ownership issues, and manage the information repository. Database administration is physical database oversight. Some of the core duties include the selection of the DBMS and software tools, the installation and upgrade of the DBMS, and database performance tuning.

30.

What is a data mart?

Answer»

A data mart is a collection of data smaller in scope and size than a data warehouse. It is dedicated to data from a particular business component of business functional area. A data mart may function as a subset of a larger data warehouse. Users of a data mart are usually knowledgeable analysts in the business area using the data mart.

31.

How is Information Technology useful for the organizations?

Answer»

Information technology has a pivotal role in an organization’s operations. It is used across different business functions thereby improving business productivity. On one hand, Information technology is applied in finance function for recording financial transactions and generating financial statements. While, it’s quite useful for the marketing personnel as they can work on enhancing the customer relationship experience. Human resource managers can collect and maintain data of employees by resorting to information technology.

32.

Enlist types of DNA library.

Answer» There are two main types of DNA library, viz. genomic library and c DNA library.
33.

Explain why an information gap exists in most organizations.

Answer»

One reason that an information gap exists is the fact that systems have been developed in separate, segmented efforts. This has helped the data from being stored in an integrated database and thus the data is in an inconsistent structure. The other reason for the gap is that most systems are created to support the operational aspect of an organization. The systems were not developed for decision making.

34.

Describe the differences between a data warehouse and data mart.

Answer»

A data warehouse is for the enterprise and contains multiple subjects. A data mart is for a specific functional area and focuses on one subject. A data warehouse is flexible and data-oriented and contains detailed historical data. A data mart is restrictive and project-oriented and contains some historical data.

35.

Explain the role of metadata for the three-layer architecture.

Answer»

Each of the three layers has a metadata layer linked with it. The metadata layer describes the properties or characteristics of the data. The operational metadata describe the data used in the various operational and external systems. The enterprise data warehouse metadata describe the reconciled data layer. The data mart metadata describes the derived data layer.

36.

Describe a data warehouse.

Answer»

A data warehouse is organized around specific subjects. The data is defined using consistent naming, format, and encoding structure standards. The data contains a time element, so that the data can be studied for trends. No data in a data warehouse can be updated by end users.

37.

There are many ANCIENT cities in Turkey. A) bigB) oldC) fashionable D) modern E) beautiful

Answer»

Correct option is D) modern

38.

Describe why operational and informational systems are separate.

Answer»

Operational systems are used to run the business in real time on a daily basis and contain current data. Non-managers and non-analysts work in this type of system. Operational systems must process large volumes of data. Informational systems are used to support decisions and contain historical data. Managers and analysts work in this type of system. Informational systems have periodic batch updates.

39.

Define the concept of class. Discuss the structure of class in urban india

Answer»

Social class, also called class, a group of people within a society who possess the same socioeconomic status. Besides being important in social theory, the concept of class as a collection of individuals sharing similar economic circumstances has been widely used in censuses and in studies of social mobility.

In the urban areas social classes comprise principally. (i) Capitalists (commercial and industrial), (ii) Professional classes, (iii) Petty traders and shopkeepers and (iv) Working.

40.

The impact of Information Technology on the lives of poor people of India in terms of-A. Economic Development B. Social Development C. Personal Development D. All of the above

Answer»

Correct answer is

D. All of the above

41.

The great Russian poet Pushkin was a REMARKABLE man. A) careless B) clever C) hard D) kind E) extraordinary

Answer»

Correct option is E) extraordinary

42.

A feature is a characteristic of a product/service that automatically comes with-A. Customer Need B. Customer Income C. Customer feedback D. None of these

Answer»

A. Customer Need

A feature is a characteristic of a product/service that automatically comes with Customer Need.

43.

New positive print is known as-A. Sync Sound B. Answer Print C. Shooting Ratio D. Call sheet

Answer»

B. Answer Print

New positive print is known as Answer Print.

44.

Which of the following programme based on Live Broadcasting? A. IPL B. News Bulletin C. Daily Soap D. Bigg Boss

Answer»

A. IPL

IPL based on Live Broadcasting.

45.

For expensive and exclusive goods, which channel (long / short) is more suitable and why?

Answer»

Direct/short channels will be used for expensive and exclusive goods.  This will help in reducing prices to be paid by the consumers. It will also help minimize risk.

46.

Which of the following is not OOH advertising tool? A. Pamphlet B. Television C. Banner D. Billboard

Answer»

B. Television

Television is not OOH advertising tool.

47.

Why is window display in residential areas a must for retailers?

Answer»

To attract more customers near the residential area is important.

48.

Define Service.

Answer»

Service can be defined as activities, benefits and satisfaction which are offered for sale or are provided in connection with the sale of goods

49.

Some firms adopt __ Pricing to prevent new firms from entering the market a) cost-plus pricing b) Markup Pricing c) Competitive Pricing d) below the cost pricing

Answer»

Correct option: d) below the cost pricing

50.

In which situation a firm may opt for publicity?

Answer»

A firm launching a new product may go for publicity.