# Tricks To Solve Profit & Loss Problems

414
2986

## Tricks To Solve Profit & Loss Problems

Profit & Loss is a basic concept of arithmetic in which we study the gain or loss in a business transaction.Profit & loss are the terms related to transactions in trade & business.Whenever a purchase article is sold, then either profit is earned or loss is incurred.This topic teaches us how to calculate such profit & loss.

Cost Price (CP): The price at which an article is purchased.

Selling Price (SP): The Price at which an article is sold.

Marked Price (MP) or List Price: The price that is indicated or marked on the article.It is sometimes also referred to as label price.

Discount: It is reduction offered on the marked price.

Profit = SP – CP

Profit % = (Profit/CP) * 100

SP = [(100 + Profit %)/100] * CP

Loss = CP – SP

Loss % = (Loss/CP) * 100

SP = [(100 – Loss %)/100] * CP

#### Few Basic Concepts:

• When there are 2 successive profit of x% and y%, then the resultant profit percent is given by:

• If there is a profit of x% and loss of y% in a transaction, then the resultant profit or loss % is given by:

• If CP of ‘m’ articles is equal to SP of ‘n’ articles, then Profit % is given by:

• A single discount equivalent to discount series of x% and y% given by the seller is equal to:

• If a seller marks his goods at x% above his CP and allows purchasers a discount of y% for cash, then overall profit or loss will be:

• If a trader professes to sell his goods at CP, but uses false weights,then:

(Visited 2,814 time, 2 visit today)
SHARE
Previous articleAges Related Problem Set 4
Next articleRBI Grade B Phase II Exam Analysis

I have been helping aspirants to clear different competitive exams. Sehpaathi as a team gave me an opportunity to do it on a larger level an reach out to more students. Do comment below if you have any questions or feedbacks.

• aur jiii kal se roj LIC aur RailwaYs ki quiz chalu hone ja rhi hai… Taeyaari kr lo jiii

• Kya bole Bhaijaan… Aise thodi na hoga… Jb tk aap ho hame umeed hai jiii

Waise to reply mil jata hai pr kabhi nhi mile aapko aur bhut urgent ho [email protected] pr mail drop kr do ya fr hamare fb page pr aakar post kr do… Turant reply mil jayega…

There is a reason behind this…

• jini

hehe

• SUN RAHA HAI NA TU

ok sehpaathi
uncle aunty ko namaste bolio
nd shadi ho gai hai to
bhabhi ji ko pranam
bye

• SUN RAHA HAI NA TU

okk okk fir thik h

• aarohi :| LIMITLESS :|

iska naam hai re kisi aur ne bola
maine dekh liya tha

• SUN RAHA HAI NA TU

ho hoho
meko to bhai manta hai
teko kuch bola kya
samjha dege
bade code word ate h teko bhi

• aarohi :| LIMITLESS :|

he he he lolzzzzzzzzz
mugli bhut bolta hai yr isko chup krva
isko bol himanshu

• SUN RAHA HAI NA TU

tumko majak lag raha h
jab entry ho jaegi
fir vote karte hue chillaogi
ye mera fren tha

• SUN RAHA HAI NA TU

meko kya pata

• aarohi :| LIMITLESS :|

ramandeep kon hai ??

• aarohi :| LIMITLESS :|

@sehpaathi:disqus paa ji?

• aarohi :| LIMITLESS :|

LOLZ

• SUN RAHA HAI NA TU

its not joke brooooo
m serious

• SUN RAHA HAI NA TU

railway h
nd state govt k bhar rakhe h
unki date ni aai abhi

tehsildar lag gaya to sare jakhm bhar jaege
ya fir bb10 me entry

• jini

aa gye aap

• Hahahahaha

• jini

tera next exam?

• SUN RAHA HAI NA TU
• SUN RAHA HAI NA TU

aive hi

• SUN RAHA HAI NA TU

agggar po me no. hote to sahi usi me lag jata
ab studies karni pad rahi h

• aarohi :| LIMITLESS :|

puch l usse tu

• jini

heheeeeeeeeee

• SUN RAHA HAI NA TU

yar gym join kana hai
bigg boss k lie video bhejnei hai 31 may tak
my dreammmmmmmmmm

• SUN RAHA HAI NA TU

tu tukke mar le u hi

• jini

wo to chlne se raha

• aarohi :| LIMITLESS :|

sweety ne

• SUN RAHA HAI NA TU

pata to chale kisne

• jini

• SUN RAHA HAI NA TU

aryan rrb scale 1

• SUN RAHA HAI NA TU

but kisi ne mera nam dala wo bhi real wala

• aarohi :| LIMITLESS :|

aryan konn?

• SUN RAHA HAI NA TU

are wo to aryan se commited h
nd chidti hai merse

• jini

haha… pta mujhe b bheja tha link pr mera koi crush hi ni to mene kuch kia hi ni.. majja aya.. popat ho gya uska

• aarohi :| LIMITLESS :|

• SUN RAHA HAI NA TU

tumhe pata hai kisne mera nam dala tha calculator me nerd wale

• SUN RAHA HAI NA TU

ok baba try k aruga kam karu but chodta to nai abhi yar

• jini

arey to tujhe kya padi.. kuch b karein

• SUN RAHA HAI NA TU

gaali kya sunata ni kya
frustrate ho jata hu
fir nakli ques puchti hai to dimag kharab ho jata h

• aarohi :| LIMITLESS :|

nerd ko bol sbki pol khole

• jini

kuch b pr isse kya milta.. faltu gali khaata

• SUN RAHA HAI NA TU

are wo koi sara din hote hai
mehfil bana k chala jauga bas

• SUN RAHA HAI NA TU

ha ha ha hahah
ab kya karu

• jini

kyu pange leta tu ladkio se udhar?

• aarohi :| LIMITLESS :|

fir yha sara din rhna hoga manjur hai

• SUN RAHA HAI NA TU

ya to meko handover kar de samrajya

• aarohi :| LIMITLESS :|

aaegi tension na le re

• SUN RAHA HAI NA TU

kudi sehpaathii to aa sakti thi na
she must be responsible
maine aise hi uske bare me itna acha soch liya

• aarohi :| LIMITLESS :|

hmmm

• aarohi :| LIMITLESS :|

hmmmm

• jini

mai UP

• SUN RAHA HAI NA TU

ha hahahah
sab lomria hai yaha yar
koi maze wali bat ni

• aarohi :| LIMITLESS :|

kudi kha hai
??
tum kon c state se ho jini

• aarohi :| LIMITLESS :|

hmmmmmmmmmmm

• jini

bahar rehte honge… subha padha tha ek post unka mene

• aarohi :| LIMITLESS :|

ghr mtlb?

• jini

Sehpaathi aj ghar gye hain bhot din bad.. isliye ni aa rhe

• aarohi :| LIMITLESS :|

i mean kal valentine day hai na

• SUN RAHA HAI NA TU

kab decide hua
nd kon kon aega

• aarohi :| LIMITLESS :|

aaj raat 12 bje se ba p ronak lagegi

• SUN RAHA HAI NA TU

okk

• jini

activate krke btaungi

• SUN RAHA HAI NA TU

yo

• aarohi :| LIMITLESS :|

sun?

• SUN RAHA HAI NA TU

teri bhi bata fb id

• aarohi :| LIMITLESS :|

paaajjjjjjjjjjjiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii

• aarohi :| LIMITLESS :|

sehpaati paaji aram kr rhe hai

• jini

hmm ryt

• aarohi :| LIMITLESS :|

hmmm bta dungi

• SUN RAHA HAI NA TU

sehpaathi aa jao nd mujhe mod bana do
sab set kar dege
dont worry

• SUN RAHA HAI NA TU

its okk

• SUN RAHA HAI NA TU

bata diyo kisi ko thikane lagana ho
n to wajib karan se dhota hu
baki aata bhi to frustration dur karen hu na

• aarohi :| LIMITLESS :|

vo kal accept hogi

• aarohi :| LIMITLESS :|

hmmmm ;p
ba p ladke bhut bkwas krte hai yr
ek vo baba ji
aur ek aur hai

• SUN RAHA HAI NA TU

yo

• SUN RAHA HAI NA TU

yad ni mai to ata hi pange lene hu
tune ek dialogue to sai chepa tha mere bandar wala

• aarohi :| LIMITLESS :|

fb p?

• SUN RAHA HAI NA TU

oberoi sab ko request bhej di gai h

• aarohi :| LIMITLESS :|

mere sath kitni br panga hua hai tera??

• SUN RAHA HAI NA TU

pehle fly high bhi chir gai thi
ab to samajh gai

• aarohi :| LIMITLESS :|

hmmm

• SUN RAHA HAI NA TU

yashi,z se hai ek, nd one more

• aarohi :| LIMITLESS :|

he he he taklu toh tum nhi hoo
tension nt
;p

• SUN RAHA HAI NA TU

ab dono ne dekh hi rakha hai to
pata hoga m not taklu
nd thoda sa to handsome laga hi houga

nd wo to pic vagarah ni lagata abhi kuch bana ni na

• aarohi :| LIMITLESS :|

konn naam kya hai?

• SUN RAHA HAI NA TU

yar ye fake nam se aati hai
pata bhi ni chalta
ek to kal jiske sath ladai hui

• jini

thnks tklu

• aarohi :| LIMITLESS :|

^_^

• aarohi :| LIMITLESS :|

kon kon ?

• jini

hmm :)) thanks

• SUN RAHA HAI NA TU

all d very best
acha hoga

• aarohi :| LIMITLESS :|

aisa mt socho
be +ve
sb aata hai tumko

• SUN RAHA HAI NA TU

are aur bhi teen char hai
wo to dushman hai meri
nd wo detail dhund rai thi

• jini

hehe yar IT me kuch ni ata

• aarohi :| LIMITLESS :|

:)) hmm hmmmm

• jini

hmm mujhe b.. isiliye tum yahan dikh jati ho.. or mai b yahan aa jati 😛

• jini

ye kya post kia hai ba pr? :/

• SUN RAHA HAI NA TU

mil gai

• aarohi :| LIMITLESS :|

• aarohi :| LIMITLESS :|

do well fod k aana
nimbu ki trha nichodna hai tumne

• jini

tumko akele rehna acha lagta?

• SUN RAHA HAI NA TU

aage bhi hai kuch
ya sirf itna hi
nd ny indentification

• jini

thnkss dear :))

• aarohi :| LIMITLESS :|

hmmmm same same

• aarohi :| LIMITLESS :|

best of luck dearuuuu

• SUN RAHA HAI NA TU

isi nam se hai kya

• aarohi :| LIMITLESS :|

mei hu fb p hang p bhi

• jini

kal exam kuch ni ata 😐

• SUN RAHA HAI NA TU

gai kya dono ki dono

• SUN RAHA HAI NA TU

kaise pata
nd fir request to bhej deti atleast

• jini

Kya ji?

• SUN RAHA HAI NA TU

oh teri sab janti ho tum
aur khud chupa rakha hai apne ap ko

• SUN RAHA HAI NA TU

kaise

• aarohi :| LIMITLESS :|

??

• aarohi :| LIMITLESS :|

fb p dekha maine tujhe naam yaad nhi
hang p bhi dekha hai

• jini

😛

• SUN RAHA HAI NA TU

teko bhi mera real name pata hai kya

• aarohi :| LIMITLESS :|

hmmm :))

• SUN RAHA HAI NA TU

kaise moti nd fb par dekh rakha h kya

• SUN RAHA HAI NA TU

ohkk great enjoy d eng,, ceremony
aa jana hansi bhi
agar man kare to
most welcome hai

• jini

meko tera pta hai pr 😛

• aarohi :| LIMITLESS :|

he he he point
meri cousin ki engagement hai just kal mrng mei aana hai parso ya narsho tk wapis

• SUN RAHA HAI NA TU

pura bta fir

• SUN RAHA HAI NA TU

ohkk great
ab mai milne k lie formality bhi karuga to kahegi line mar raha hai
gudd kitne time bad aa rai ho

• jini

jini 😐

• aarohi :| LIMITLESS :|

hmmm cool life set kr lo fir shaadi krna direct
waise shyad mei kal hissar aana hai

• SUN RAHA HAI NA TU

jinni to sab bulate hai
tera real name kya h moti

• SUN RAHA HAI NA TU

okk vse bhi ab gf banane k shonk khtam ho gae
ub chuka hu in sabse

• aarohi :| LIMITLESS :|

@kudisehpaathi:disqus ji???

• jini

pta ni… jinii.. 😐

• aarohi :| LIMITLESS :|

@sehpaathi:disqus paa ji ??

• aarohi :| LIMITLESS :|

leave dost

• SUN RAHA HAI NA TU

okk fir babu baby bhi teko pasand nai
kya bolu

• jini

jinner i m not liking pr :/

• SUN RAHA HAI NA TU

just express dont feeel shy
i will not say to anyone

• aarohi :| LIMITLESS :|

he he he mei kya bolu ab

• SUN RAHA HAI NA TU

jinni ka nam bigar k jinner hi kahuga
ab tu khas hai jada ulta to teko bol ni sakta na

• jini

jinner kya :/

• aarohi :| LIMITLESS :|

attitude 😮

• SUN RAHA HAI NA TU

ku soni ni h kya

• SUN RAHA HAI NA TU

aa gai jinner

• aarohi :| LIMITLESS :|

haan maam ko real mei dekhega
gunnu gunnu krna bhul jaega

• SUN RAHA HAI NA TU

bahut reh liya kool
nd bahut impress kar li gals
now something different

• jini

taklu

• SUN RAHA HAI NA TU

mai to chahta hu bhai ka kuch ho jae
vse to gunnu bhi apni khas hai

• aarohi :| LIMITLESS :|

galat hai cool rhao acha rahega

• SUN RAHA HAI NA TU

mera to attitude hi aisa hai yar

• aarohi :| LIMITLESS :|

sehpaati ki promotion krte toh tum hi ho ba p

• aarohi :| LIMITLESS :|

dant laga dete ho jb bhi aate ho tum

• SUN RAHA HAI NA TU

bhai sehpaathi aise channel ni chalta
aap online ni raoge to
jo 4-5 aa rae hai
wo bhi kat lege

dedication hona chahie yar
comeon

• SUN RAHA HAI NA TU

make me mod sehpaathi
sab set kar dege

• SUN RAHA HAI NA TU

kithe kalli o bai bai k

• jini

hello aarohi :))

• SUN RAHA HAI NA TU

okk le lo team me fir
apki site mai hit kar duga

• aarohi :| LIMITLESS :|

hie jini :))

• jini

hello

• aarohi :| LIMITLESS :|

hmmmm

• Miss Banker(Akshu ☺ sanguine)

accha ok

• aarohi :| LIMITLESS :|

baby maine hang p ping kiya tumko deko jara jaldi

• Miss Banker(Akshu ☺ sanguine)

@@disqus_aNiBw7PIWH:disqus

• aarohi :| LIMITLESS :|

@sehpaathi:disqus paa ji kitne hooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo???

• aarohi :| LIMITLESS :|

koi hai ??

• Rafael Nadal :- Mr RBI IBPS PO

Are dhyan rakho 🙂

• Are mast jayega… Tension na lo

For interview questions
https://sehpaathi.in/interview-preparation

• Hahahahaha…. Are aap hamari team mein aa jao jiii
Yahan sab kuch possible hai… Aap quiz krwao

• Rafael Nadal :- Mr RBI IBPS PO

Thnx sir 🙂

• Quintessential :||LimitLess

Tx Bhai
Interview ki chal rahi h ..
Atb For ur iv also
Gud Luck
aur ab mandir jao to hamare liye bhi dua kia karo 😛

• Rafael Nadal :- Mr RBI IBPS PO

Sahi hai congrats ….interview ki full prepration krna 😉

Mene to starting me hi Rbi grade B target kiya ..bina koi even exam diye. And success bhi mili ….hoping ab final thing interview bhi Accha jaye 🙂

• Quintessential :||LimitLess

ATB

and Gud Luck bhai

Waise PO to 100% h tumhara

• All d best acha jaega ?

• Quintessential :||LimitLess

Bhai humko samjhte der lagi aur 2013 wale ne
bahut time kahrab kia so dono dene lag gaye
AB jake paas huye h 😛

• Rafael Nadal :- Mr RBI IBPS PO

Sahi hai to usi pe kro phir. ..nhi to dono me time waste hoga

• Quintessential :||LimitLess

ha bhai

• Rafael Nadal :- Mr RBI IBPS PO

Sir me to ek me hi hu. ….Rbi grade B interview Accha jaye ab 🙂

• Haan Ek PR Hi tiko yaar…

• Rafael Nadal :- Mr RBI IBPS PO

Me bank ki prepration hi kr rha throughout. …tum ssc ki?

• Quintessential :||LimitLess

OK Koi Na bhai

• Rafael Nadal :- Mr RBI IBPS PO

Usme tier 1 me out …..prepration started in Aug aur GS abi bi ni aati

• Rafael Nadal :- Mr RBI IBPS PO

Ye to bura hua na?

• Quintessential :||LimitLess

2015 wala??

• Rafael Nadal :- Mr RBI IBPS PO

Bhar duga prepration nhi kr rha per ……baad me time milega to dekhuga

• Quintessential :||LimitLess

mera nahi h 😛

• jini

acha

• jini

same to u

• Quintessential :||LimitLess

• Rafael Nadal :- Mr RBI IBPS PO

Mera pc off ho gya :/

• Quintessential :||LimitLess

All the best Dear
Gud Luck

• jini

• jini

1 bje

• Rafael Nadal :- Mr RBI IBPS PO

To phir :/

• jini

over!!

• jini

bb

• jini

__________ is a simple form of Data Warehouse that is

focused on single subject.

B. Data Mart

C. Both (A) and (B)

D. None of the Above

• jini

nhi

• Rafael Nadal :- Mr RBI IBPS PO

jini subah hai na u ka b 😐

• Rafael Nadal :- Mr RBI IBPS PO

william??

• jini

Who is known as the father of data warehousing?

A. Grace Hopper

B. Niklaus Wirth

C. James Gosling

D. William H.Imnon

• Rafael Nadal :- Mr RBI IBPS PO

house DD

• jini

___________ is a centralized repository that stores data from

multiple sources and transforms them into a common, multi

dimensional model for efficient querying and analysis.

A. Data Selection

B. Data Cleaning

C. Data Integration

D. Data Warehouse

• jini

😛

• Rafael Nadal :- Mr RBI IBPS PO

ab kya bolu :/

• jini

Which of the following is the process of combining data from

different resources?

A. Data Selection

B. Data Cleaning

C. Data Integration

D. None of the Above

Ans – C. Data Integration

• Rafael Nadal :- Mr RBI IBPS PO

safai karna 😐

• jini

Which of the following is the process of detecting and

correcting the wrong data?

A. Data Selection

B. Data Cleaning

C. Data Integration

D. None of the Above

• Rafael Nadal :- Mr RBI IBPS PO

forecasting

• jini

Which parameter is used to discover patterns in data that can

A. clustering

B. classification

C. Association

D. Forecasting

• jini

aa

• Rafael Nadal :- Mr RBI IBPS PO

cluster

• Quintessential :||LimitLess

bb??

• jini

The process of grouping a set of objects into classes of similar

objects is called ___________

A. clustering

B. classification

C. Association

D. All of the Above

• Rafael Nadal :- Mr RBI IBPS PO

• jini

________ a special type of computational cluster that is

specifically designed for storing and analysing large amount of

unstructured data.

B. Failover Cluster

C. Both (A) and (B)

D. None of the Above

• jini

ok

• Rafael Nadal :- Mr RBI IBPS PO

O_O nhi ho sakta

• jini

bb

• Rafael Nadal :- Mr RBI IBPS PO

aa :/

• jini

Which of the following is used to examine data collected by

search engines and web spiders?

A. Web structure mining

B. Web content mining

C. Web usage mining

D. None of the Above

• Rafael Nadal :- Mr RBI IBPS PO

bb

• jini

________ is a type of data mining used in Customer

Relationship Management(CRM)

A. Clustering

B. Web mining

C. Both (A) and (B)

• Rafael Nadal :- Mr RBI IBPS PO

unshare

• jini

The shared pool is also able to support ________ in data

warehousing applications.

A. Shared SQL

B. Stored SQL

C. Unsorted SQL

D. Unshared SQL

• Rafael Nadal :- Mr RBI IBPS PO

oltp

• jini

Shared pool size is an important factor for ______ applications.

A. On-line Transaction Processing (OLTP)

B. Decision Support Systems (DSS)

C. Both (A) and (B)

D. None of the above

• Rafael Nadal :- Mr RBI IBPS PO

very hard

• jini

If the parsed form of the statement is not found in the shared

pool then new statement is parsed and its parsed version is stored in

Shared SQL area. This is known as ________

A. Library cache hit

B. Soft parsing

C. Hard parsing

D. None of the above

• Rafael Nadal :- Mr RBI IBPS PO

sab

• jini

Information stored in dictionary cache includes ______

A. User names

B. Profile data

C. table space information

D. All of the above

• Rafael Nadal :- Mr RBI IBPS PO

aa

• Rafael Nadal :- Mr RBI IBPS PO

ye kab O_O bb
fast ho 😐

• jini

Which stores the executable(parsed) form of SQL cursors and

PL/SQL programs?

A. library Cache

B. dictionary Cache

C. Both (A) and (B)

D. None of the above

• jini

bb

• jini

ok

• jini

Oracle Database segregates a small amount of the shared pool

for large objects(Over 5KB).The segregated area of the shared pool

is called ______

A. Fixed Pool

B. Reserved Pool

C. Allocated Pool

D. None of the above

• Rafael Nadal :- Mr RBI IBPS PO

ye to same na :/

• SUN RAHA HAI NA TU

tu rehne d jinnrii

• SUN RAHA HAI NA TU

okkk

• Rafael Nadal :- Mr RBI IBPS PO

accha option same lage mujhe ok 😐

• jini

:

• Rafael Nadal :- Mr RBI IBPS PO

😐

• jini

ques pdho

• jini

The ________ performs process recovery when a user process

fails.

A. Log Writer(LGWR)

B. Checkpoint(CKPT)

C. System Monitor(SMON)

D. Process Monitor(PMON

• jini

mene dia

• Rafael Nadal :- Mr RBI IBPS PO

• jini

pmon

• Rafael Nadal :- Mr RBI IBPS PO

ho gya ye :/

• jini

9876543210

• jini

The ________ performs process recovery when a user process

fails.

A. Log Writer(LGWR)

B. Checkpoint(CKPT)

C. System Monitor(SMON)

D. Process Monitor(PMON

• SUN RAHA HAI NA TU

• Rafael Nadal :- Mr RBI IBPS PO

cc

• Rafael Nadal :- Mr RBI IBPS PO

sahi ho gya 🙂

• jini

The ________ performs recovery when a failed instance starts

up again.

A. Log Writer(LGWR)

B. Checkpoint(CKPT)

C. System Monitor(SMON)

D. Process Monitor(PMON

• jini

lock manager server

• Rafael Nadal :- Mr RBI IBPS PO

lock manager 😕

• jini

The ______ process is used for inter-instance locking in Real

Application Clusters

• Rafael Nadal :- Mr RBI IBPS PO

well laughed 🙂

• jini

:/

• SUN RAHA HAI NA TU

ha hahahahahahah

• Rafael Nadal :- Mr RBI IBPS PO

222222222222222222222222222222222

• jini

Oracle 9i Reports gives us _______options for building a Web

report.

A. two

B. three

C. four

D. Five

• Rafael Nadal :- Mr RBI IBPS PO

8^3

• jini

Oracle 9i can scale tens of thousands of concurrent users

support upto _________ petabytes data.

A. 124

B. 256

C. 512

D. 624

• jini

hmm copy ni hua

• Rafael Nadal :- Mr RBI IBPS PO

9i hoga jini

• jini

___________ Database is the only database specifically

designed as an Internet development and deployment platform

A. Oracle 6i

B. Oracle 7i

C. Oracle 8i

D. Oracle 9

• Rafael Nadal :- Mr RBI IBPS PO

sql*plus

• jini

________ is a tool for entering and running ad-hoc based

database statements.

• Rafael Nadal :- Mr RBI IBPS PO

fetch

• jini

Which of the following is an example for Embedded SQL

Statement?

A. ROLLBACK

B. SETROLE

C. ALTER SYSTEM

D. FETCH

• Rafael Nadal :- Mr RBI IBPS PO

dd

• Rafael Nadal :- Mr RBI IBPS PO

are karo yr mene kab mana kiya :/

• jini

Which Normal Form(NF) is considered adequate for normal

relational database design?

A. 2NF

B. 5NF

C. 4NF

D. 3NF

• Rafael Nadal :- Mr RBI IBPS PO

Mysql

• jini

The most open source DBMS is _______

A. Oracle

B. Microsoft Access

C. MySQL

D. None of the Above

• jini

acha thodi der or bas

• Rafael Nadal :- Mr RBI IBPS PO

• jini

u want to go? or to end this?

• Rafael Nadal :- Mr RBI IBPS PO

ok 😐

• jini

ni

• Rafael Nadal :- Mr RBI IBPS PO

say 😐

• jini

:/

• Rafael Nadal :- Mr RBI IBPS PO

aa

• Rafael Nadal :- Mr RBI IBPS PO

u want to me ja rha 😐

• jini

Which privilege is required to create a database?

A. SYSDBA

B. DBA

C. SYSOPER

D. RESOURCE

• Rafael Nadal :- Mr RBI IBPS PO

history

• jini

Which password management feature ensures a user cannot

reuse a password for a specified time interval?

A. Account Locking

D. None of the Above

• Rafael Nadal :- Mr RBI IBPS PO

control hona chahiye :/

• jini

Which type of file is a part of the Oracle database?

A. Control file

C. Parameter files

D. log files

• Rafael Nadal :- Mr RBI IBPS PO

bb na

• jini

What is the type of Oracle backup in which all uncommitted

changes have been removed from the data files?

A. Full backup

B. Consistent backup

C. Inconsistent backup

D. Differential backup

• Rafael Nadal :- Mr RBI IBPS PO

dd

• jini

When is the System Global Area (SGA) created in an Oracle

database environment?

A. When the database is created

B. When a user process is started

C. When the database is mounted

D. When the instance is started

• Rafael Nadal :- Mr RBI IBPS PO

data

• jini

Which Oracle backup and recovery file contains user and

system data?

A. Control file

B. Data file

C. Offline Redo file

D. None of the Above

• jini

🙂

• jini

dukele hu vese

• Rafael Nadal :- Mr RBI IBPS PO

me nhi bhaguga 😐

• jini

• jini

padh rhi bas apna mai to

• Rafael Nadal :- Mr RBI IBPS PO

kyu :/

• SUN RAHA HAI NA TU

akele akele me kya qiz jinnri

• jini

flash wala kyu ni kar rhe

• Rafael Nadal :- Mr RBI IBPS PO

bb na 😐

• jini

What type of failure occurs when Oracle fails due to an

operating system or computer hardware failure?

A. Application failure

B. Instance Failure

C. Media Failure

• Rafael Nadal :- Mr RBI IBPS PO

tiny text

• jini

Which of the following datatype holds a string with maximum length

of 255 characters?

• Rafael Nadal :- Mr RBI IBPS PO

union na :

• jini

Which of the following operator combines two or more SELECT

statements?

(A) In

(B) Like

(C) Union

(D) None of the above

• Rafael Nadal :- Mr RBI IBPS PO

memo na :/

• jini

Which datatype is used to store up to 65,536 characters?

(A) Memo

(B) Text

(C) Integer

(D) None of the above

• jini

hehe

• jini

easy

• Rafael Nadal :- Mr RBI IBPS PO

SQRT na?

• Rafael Nadal :- Mr RBI IBPS PO

hmm acha

• jini

Which of the following is used to generate a square root of a

number?

(A) MySQL SQRT Function

(B) MySQL RAND Function

(C) MySQL AVG Function

(D) None of the above

• jini

hmm

• Rafael Nadal :- Mr RBI IBPS PO

quora

• Rafael Nadal :- Mr RBI IBPS PO

auto and bus travelling things 😐

• jini

The feature that database allows to access only certain records in

database is______

(A) Queries

(B) Reports

(C) Forms

(D) Tables

• jini

bus? 😛

• Rafael Nadal :- Mr RBI IBPS PO

kya band karne ko nhi kaha 🙂

• jini

ok

• Rafael Nadal :- Mr RBI IBPS PO

auto bus :/

• jini

Which of the following field type is the best to store serial numbers?

(A) Number

(B) Auto Number

(C) Text

(D) Memo

• Rafael Nadal :- Mr RBI IBPS PO

both

• jini

Which of the following method can be used to add more tables in a

database?

(A) Design View

(B) Table Wizard

(C) Both (A) & (B)

(D) None of the above

• Rafael Nadal :- Mr RBI IBPS PO

bb

• Rafael Nadal :- Mr RBI IBPS PO

• jini

_______ statement is used in conjunction with the aggregate

functions to group the result-set by one or more columns.

(A) Select

(B) Group By

(C) Distinct

(D) None of the above

• jini

• Rafael Nadal :- Mr RBI IBPS PO

uff yr pata nhi ..ye sab exam time pe kyu ho rha :/

• jini

cc

• jini

aj hi ho rha tha.. abi thik hai pr

• Rafael Nadal :- Mr RBI IBPS PO

tumhara ab pain theek hai na?

• jini

Which of the following field type is used to store photograph of

employees?

(A) Memo

(B) Picture

(C) OLE

(D) Photo

• jini

Assertion

• jini

Domain constraints, functional dependency and referential integrity

are special forms of _________

• Rafael Nadal :- Mr RBI IBPS PO

primary

• jini

A Foreign key in one table points to a ________ key in another table.

(A) Alternate

(B) Default

(C) Primary

(D) None of the above

• Rafael Nadal :- Mr RBI IBPS PO

check it 😐

• jini

Which of the following constraint is used to limit the value range that

can be placed in a column?

(A) Check

(B) Default

(C) Unique

(D) None of the above

• Rafael Nadal :- Mr RBI IBPS PO

dd

• Rafael Nadal :- Mr RBI IBPS PO

yah ..ye hui baat 🙂

• jini

_______ allows a unique number to be generated when a new

record is inserted into a table.

(A) Insert Into Select

(B) Insert Into

(C) Select Into

(D) Auto Increment

• Rafael Nadal :- Mr RBI IBPS PO

backup 😐

• jini

Which allows to make copies of the database periodically to help in

the cases of crashes and disasters?

(A) Recovery utility

(C) Monitoring utility

(D) Backup Utility

• jini

ok dono take care

• Rafael Nadal :- Mr RBI IBPS PO

constraints

• Rafael Nadal :- Mr RBI IBPS PO

mera to jo hai so hai but u should take care 🙂

• jini

Which of the following is preferred method for enforcing data

integrity?

(A) Cursors

(B) Constraints

(C) Triggers

(D) None of the above

• Rafael Nadal :- Mr RBI IBPS PO

log

• jini

Each modification done in database transaction are first recorded

into the______

(A) Hard Drive

(B) Disk

(C) Log File

(D) Data Mart

• jini

good.. take care 🙂

• Rafael Nadal :- Mr RBI IBPS PO

B hai na?

• Rafael Nadal :- Mr RBI IBPS PO

not much better ….infact ,,,its ok yr 😐

• jini

7. Which of the following is a special type of integrity constraint that

relates two relations and maintains consistency across the relations?

(A) Entity Integrity Constraints

(B) Referential Integrity Constraints

(C) Domain Integrity Constraints

(D) None of the above

• Rafael Nadal :- Mr RBI IBPS PO

semi :/

• jini

An operator is basically a join followed by a project on the attributes

of first relation is known as_______

(A) Join

(B) Inner Join

(C) Full Join

(D) Semi-Join

• jini

ur fever?

• Rafael Nadal :- Mr RBI IBPS PO

aa

• jini

The candidate key is that you choose to identify each row uniquely is

called_______

(A) Primary Key

(B) Foreign Key

(C) Alternate Key

(D) None of the above

• jini

hmm ni kr rhi

• Rafael Nadal :- Mr RBI IBPS PO

unique

• jini

Which of the following is used to determine whether of a table

contains duplicate rows?

(A) Unique predicate

(B) Like Predicate

(C) Null predicate

(D) In predicate

• Rafael Nadal :- Mr RBI IBPS PO

pretend ni karna 😐

• jini

🙂

• Rafael Nadal :- Mr RBI IBPS PO

bb

• jini

_______ is the process of organizing data into related tables.

(A) Generalization

(B) Normalization

(C) Specialization

(D) None of the above

• Rafael Nadal :- Mr RBI IBPS PO

smile

• Rafael Nadal :- Mr RBI IBPS PO

having

• jini

han ji

• Rafael Nadal :- Mr RBI IBPS PO

@petallll:disqus u r ok na?

• jini

2. Which of the following clause is an additional filter that is applied to

the result?

(A) Having

(B) Group-by

(C) Select

(D) Order by

• Rafael Nadal :- Mr RBI IBPS PO

cc

• jini

. ______ is the complex search criteria in the WHERE clause.

(A) Substring

(B) Drop Table

(C) Predicate

(D) None of the abov

• Rafael Nadal :- Mr RBI IBPS PO

dd? :/

• jini

__________ are used to temporarily rename a table or heading of a

column.

(A) Wildcards

(B) Constraints

(C) Joins

(D) Aliases

• Thnk you rafael

• jini

good

• Rafael Nadal :- Mr RBI IBPS PO

%.

• Rafael Nadal :- Mr RBI IBPS PO

now good

• jini

In SQL, which of the following wildcard character is used as a

substitute for Zero or more characters?

(A) *

(B) _

(C) ^

(D) %

• jini

kya hua

• Rafael Nadal :- Mr RBI IBPS PO

IN :/

• jini

Which operator allows to specify multiple values in a WHERE Clause?

(A) LIKE

(B) IN

(C) BETWEEN

(D) None of the above

• Rafael Nadal :- Mr RBI IBPS PO

like

• jini

In SQL, Wildcard characters are used with the _______ operator.

(A) LIKE

(B) RANGE

(C) BETWEEN

(D) None of the above

• Rafael Nadal :- Mr RBI IBPS PO

cc

• jini

The _____clause is used to specify the number of records to return.

(A) FROM

(B) WHERE

(C) SELECT TOP

(D) None of the above

• Rafael Nadal :- Mr RBI IBPS PO

cics

• jini

DBMS may be combined with or used by ______ type of transaction

manager.

(A) DB2

(B) Customer Information Control System (CICS)

(C) Oracle

(D) None of the above

• Rafael Nadal :- Mr RBI IBPS PO

gud job @Kudisehpaathi:disqus

• jini

aa

• jini

Which of the following is the most common type of Join?

(A) INNER JOIN

(B) INSIDE JOIN

(C) JOINED

(D) None of the above

• jini

cc

• jini

1. Which operator is used to select values within a range?

(A) WITHIN

(B) RANGE

(C) BETWEEN

(D) None of the above

• jini

aa

• jini

Which method of Online Analytical Processing stores data in both a

relational and a multi dimensional database.

(A) Hybrid OLAP

(B) Relational OLAP

(C) OLAP

(D) None of the above

• jini

dd

• jini

Which SQL statement is used to extract data from a database?

(A) EXTRACT

(B) GET

(C) OPEN

(D) SELECT

• jini

cc

• jini

The management information system (MIS) structure with one main

computer system is called a________

(A) Decentralized MIS structure

(B) Distributed MIS structure

(C) Centralized MIS structure

(D) None of the above

• jini

aa

• jini

. A unit of storage that can store one or more records in a hash file

organization is denoted as_______

(A) Bucket

(B) Disk pages

(C) Blocks

(D) Nodes

• Rafael Nadal :- Mr RBI IBPS PO

:/

• Miss Banker(Akshu ☺ sanguine)

bye 😐

• SUN RAHA HAI NA TU

quiz karwana tumhara kam hai
nd if u r preeti
i like ur gestures

• Rafael Nadal :- Mr RBI IBPS PO

ok 😐

• To quiz krwa do yha ?

• jini

ok papa

• SUN RAHA HAI NA TU

koi math ki problem ho to puch lena
math nd english ka papa hu mai

• jini

cc

• jini

The resolution of externally defined symbols is performed by?

(A) Compiler

(B) Assembler

(D) None of the above

• jini

bb

• jini

…… provides an Interface between the process and the Operating

System

(A) Synchronization

(B) System call

(C) Segmentation

(D) None of the above