High Search

Q:

What is WATER MARK in oracle? Explain the significance of High water mark.

Answer

WATER MARK is a divided segment of used and free blocks. Blocks which are below high WATER MARK i.e. used blocks, have at least once contained some data. This data might have been deleted later. Oracle knows that blocks beyond high WATER MARK don’t have data; it only reads blocks up to the high WATER MARK during a full table scan.

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

Write SQL Query to find second highest salary of Employee.

Answer

There are many ways to find second highest salary of Employee in SQL, you can either use SQL Join or Subquery to solve this problem. Here is SQL query using Subquery :

SELECT MAX(Salary) from Employee WHERE Salary NOT IN (select MAX(Salary) FROM Employee );

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

How higher management in an organization gets benefited by payroll reports?

Answer

Payroll reports gives information about the total 'cost to Company' for the Employee Salary, Benefits (Cash and Non-Cash), Taxes, Total Hours worked.

All these information is helpful for the Management decisions.

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: Payroll Interview

Q:

A booster pump can be used for filling as well as for emptying a tank. The capacity of the tank is 2400 $m^{3}$ . The emptying capacity of the tank is 10 $m^{3}$ per minute higher than its filling capacity and the pump needs 8 minutes lesser to empty the tank than it needs to fill it. What is the filling capacity of the pump?

A) 50 m^3/min	B) 60 m^3/min
C) 72 m^3/min	D) None of these

Answer & Explanation Answer: A) 50 m^3/min

Explanation:

Let the filling capacity of the pump be x $m^{3}$ /min.

Then, emptying capacity of the pump=(x+10) $m^{3}$ /min.

so, $\frac{2400}{x} - \frac{2400}{x + 10} = 8 \Leftrightarrow x^{2} + 10 x - 3000 = 0$

$\Rightarrow (x - 50) + (x + 60) = 0 \Leftrightarrow x = 50$

Report Error

View Answer Report Error Discuss

Filed Under: Pipes and Cistern
Exam Prep: CAT , Bank Exams , AIEEE
Job Role: Bank PO , Bank Clerk

Q:

Which is the highest waterfall in the world ?

Answer

Angel, Venezuela

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: Longest, Shortest, Deepest

Q:

Which is highest dam in world ?

Answer

Jinping-I Dam in China at 305 m (1,001 ft) high

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: Longest, Shortest, Deepest

Q:

Study the following graph carefully and answer the questions given below:

Distribution of candidates who were enrolled for MBA entrance exam and the candidates (out of those enrolled) who passed the exam in different institutes:

1. What percentage of candidates passed the Exam from institute T out of the total number of candidates enrolled from the same institute?

A. 50% B. 62.5% C. 75% D. 80%

2. Which institute has the highest percentage of candidates passed to the candidates enrolled?

A. Q B. R C. V D. T

3. The number of candidates passed from institutes S and P together exceeds the number of candidates enrolled from institutes T and R together by:

A. 228 B. 279 C. 399 D. 407

4. What is the percentage of candidates passed to the candidates enrolled for institutes Q and R together?

A. 68% B. 80% C. 74% D. 65%

5. What is the ratio of candidates passed to the candidates enrolled from institute P?

A. 9:11 B. 14:17 C. 6:11 D. 9:17

Answer

1. ANSWER : C

Explanation - Required percentage= $\frac{9 % o f 5700}{8 % o f 8550} \times 100$ % = $\frac{9 \times 5700}{8 \times 8550} \times 100$ % = 75%

2. ANSWER : B

Explanation - The percentage of candidates passed to candidates enrolled can be determined for each institute as under:

P = $\frac{18 % o f 5700}{22 % o f 8550} \times 100$ % = 54.55%

Q = $\frac{17 % o f 5700}{15 % o f 8550} \times 100$ % = 75.56%

R = $\frac{13 % o f 5700}{10 % o f 8550} \times 100$ % = 86.67%

S = $\frac{16 % o f 5700}{17 % o f 8550} \times 100$ % = 62.75%

T = $\frac{9 % o f 5700}{8 % o f 8550} \times 100$ % = 75%

V= $\frac{15 % o f 5700}{12 % o f 8550} \times 100$ % = 83.33%

X= $\frac{12 % o f 5700}{16 % o f 8550} \times 100$ % = 50%

Highest of these is 86.67% corresponding to institute R.

3. ANSWER : C

Explanation - Required difference = [(16% + 18%) of 5700] - [(8% + 10%) of 8550]

= [(34% of 5700) - (18% of 8550)]

= (1938 - 1539)

= 399

4. ANSWER : B

Explanation - Candidates passed from institutes Q and R together = [(13% + 17%) of 5700] = 30% of 57000.

Candidates enrolled from institutes Q and R together = [(15% + 10%) of 8550] = 25% of 8550.

Required Percentage = $\frac{30 % o f 5700}{25 % o f 8550} \times 100$ % = 80%

5. ANSWER : C

Explanation - Required ratio = $\frac{18 % o f 5700}{22 % o f 8550}$ = 6/11

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: Pie Charts

Q:

You develop an enterprise application, called XYZApplication that includes a Windows Form presentation layer, middle-tier components for business logic and data access, and a Microsoft SQL Server database.

You are in the process of creating a middle-tier component that will execute the data access routines in your application. When data is passed to this component, the component will call several SQL Server stored procedures to perform database updates. All of these procedure calls run under the control of a single transaction.

The code for the middle-tier component will implement the following objects:
SqlConnection cn = new SqlConnection();
SqlTransaction tr;

If two users try to update the same data concurrently, inconsistencies such as phantom reads will occur. You must now add code to your component to specify the highest possible level of protection against such inconsistencies.
Which code segment should you use?

A) tr = cn.BeginTransaction(?ReadCommitted?);	B) tr = cn.BeginTransaction(IsolationLevel.ReadCommitted);
C) tr = cn.BeginTransaction(IsolationLevel.Serializable);	D) tr = cn.BeginTransaction(?Serializable?);

Answer & Explanation Answer: C) tr = cn.BeginTransaction(IsolationLevel.Serializable);

Explanation:

Serializable is the highest isolation transaction level. It provide the highest possible level of protection against concurrent data errors. The correct syntax to begin a transaction with this transaction isolation level is: cn.BeginTransaction(IsolationLevel.Serializable)

Report Error

View Answer Report Error Discuss

Filed Under: MCAD - Microsoft Certified Application Developer

Searching for "High"

Quick Links