Why do systems Fail to perform?
Wrong Choice of Technology
Inefficient Design & code
Poor tuning of technology
All the above
At ABC bank there are 2 million withdrawals per day, 2 million inquires per day, and 1million deposits per day. 75% of transactions occur in a 3 hour window from 11am to 2 pm. What is the peak throughput?
3 million/hour
2.25million / hour
5 million/hour
1.25 million/hour
Which type of flow rule does not include end user intervention?
Screen flow
Straight-through process flow
Starter flow
Subflow
Identify the performance testing tool from below.
HP Load runner
HP Performance tester
Segue Silk Performer
OpenSTA
The mysql contains a user root?
True
False
The default password of root user is
My$ql
Linuxab$
""
None of the above
What will be the output of the query select * from table1 order by rand()
Error
All columns ordered randomly
rows picked in a random way
Which statement is true about properties that begin with prefixes "px", "py" and "pz" ?
They cannot be displayed or used in PRPC
They can only be used in flow action rule
There are no such properties in PRPC
They are provided by Pega and are considered standard properties
What will be the output of the query SELECT column FROM table ORDER BY column DESC LIMIT 7,10;
Would skip the first 7, and then get you the next ten highest.
not a valid mysql query
Would skip the first 10, and then get you the next 7 highest.
Is it a valid mySQL statements? SELECT @min_price:=MIN(price),@max_price:=MAX(price) FROM shop; SELECT * FROM shop WHERE price=@min_price OR price=@max_price;