Searching for "L"

Q:

State the difference between View and Materialized View ?

Answer

The main differenc between View and Materialized View states that -


1. View means it stores the SQL statement in the database and let you use it as a table. Everytime you access the view, the SQL statement executes.


2. Materialized view means it stores the results of the SQL in table form in the database. SQL statement only executes once and after that everytime you run the query, the stored result set is used. Advantage include quick query results.

Report Error

View answer Workspace Report Error Discuss

Q:

Which city is known as 'Gold capital of the world' ?

A) Johannesburg B) Paris
C) Dubai D) Saudi
 
Answer & Explanation Answer: A) Johannesburg

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: World Geography
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Bank Clerk , Bank PO

Q:

It costs Rs. p each to send the first thousand messsages and Rs. q to send each subsequent one . If r is greater than 1,000, how many Rupees will it cost to send r messages ?

A) 1000 (r - p) + pq B) 1000 p + qr
C) 1000 (r - q) + pr D) 1000(p - q) + qr
 
Answer & Explanation Answer: D) 1000(p - q) + qr

Explanation:

We need to find the total cost to send r messsages, r > 1000.

The first 1000 messsages will cost Rs.p each (Or) 

The total cost of first 1000 messsages = Rs.1000p

The remaining (r - 1000) messsages will cost Rs.q each (Or)

The cost of the (r - 1000) = Rs.(r - 1000)y

 

Therefore, total cost = 1000p + rq - 1000q

= 1000(p - q) + qr

Report Error

View Answer Report Error Discuss

Filed Under: Average
Exam Prep: GATE , CAT , Bank Exams , AIEEE
Job Role: Bank PO , Bank Clerk

Q:

36 identical books must be arranged in rows with the same number of books in each row. Each row must contain at least three books and there must be at least three rows. A row is parallel to the front of the room. How many different arrangements are possible ?

A) 5 B) 6
C) 7 D) 8
 
Answer & Explanation Answer: A) 5

Explanation:

The following arrangements satisfy all 3 conditions.

Arrangement 1: 3 books in a row; 12 rows.

Arrangement 2: 4 books in a row; 9 rows.
Arrangement 3: 6 books in a row; 6 rows.
Arrangement 4: 9 books in a row; 4 rows.
Arrangement 5: 12 books in a row; 3 rows.

 

Therefore, the possible arrangements are 5.

Report Error

View Answer Report Error Discuss

Filed Under: Permutations and Combinations
Exam Prep: GATE , CAT , Bank Exams , AIEEE
Job Role: Bank PO , Bank Clerk

Q:

Lucky started working 2 years ago. Her starting salary was half of Karthik's salary at that time. Each year since then Lucky and Karthik have received a rise of 10% in their respective salary. What percentage (to the nearest percent) of Karthik's current salary is Lucky's current salary ?

A) 75% B) 22.5%
C) 35% D) 50%
 
Answer & Explanation Answer: D) 50%

Explanation:

Let the salary of Karthik 2 years ago be Rs.100
So, Lucky's salary 2 years ago was Rs.50

 

Karthik's present salary has seen two 10 percent increases. So as Lucky's salary.

So, Karthik's salary 1 year ago = 100 + 10% of 100 = 100 + 10 = 110.
Karthik's present salary = 110 + 10% of 110 = 110 + 11 = 121.

 

Lucky's salary 1 year ago = 50 + 10% of 50 = 50 + 5 = 55
Lucky's present salary = 55 + 10% of 55 = 55 + 5.5 = 60.5

 

Lucky's present salary of 60.5 = 50% of Karthik's present salary of 121.

Report Error

View Answer Report Error Discuss

Filed Under: Percentage
Exam Prep: CAT , Bank Exams , AIEEE
Job Role: Bank PO , Bank Clerk

Q:

A mother can do a certain job in x hours. Her daughter takes twice as long to do the job. Working together, they can do the job in 6 hours. How many hours does the mother take to do the job ?

A) 3 B) 6
C) 9 D) 12
 
Answer & Explanation Answer: C) 9

Explanation:

The mother completes the job in x hours.
So, the daughter will take 2x hours to complete the same job.

 

In an hour, the mother will complete 1/x of the total job.
In an hour, the daughter will complete 1/2x of the total job.

 

So, if the mother and daughter work together, in an hour they will complete 1/x + 1/2x of the job.
i.e., in an hour they will complete 3/2x of the job.

 

The question states that they complete the entire task in 6 hours if they work together.
i.e., they complete 1/6 th of the task in an hour.

 

Equating the two information, we get 3/2x = 1/6
By solving for x, we get 2x = 18 or x = 9.

 

The mother takes 9 hours to complete the job.

Report Error

View Answer Report Error Discuss

Filed Under: Time and Work
Exam Prep: GATE , CAT , Bank Exams , AIEEE
Job Role: Bank PO , Bank Clerk

Q:

If two fractions, each of which has a value between 0 and 1, are multiplied together, the product will be :

A) always greater than either of the original fractions B) always less than either of the original fractions
C) sometimes greater and sometimes less than either of the original fractions D) remains the same
 
Answer & Explanation Answer: B) always less than either of the original fractions

Explanation:

We can easily Answer this by taking some values.

 

The question states that the two fractions, each have values between 0 and 1.

Let us say one of the fraction is 1/2 and the other fraction is 1/3 .

The product of the two fractions is 1/2 x 1/3 = 1/6 .
 is lesser than both 1/2  and 1/3 .

So, the correct answer is that the product is always less than either of the original fractions

Report Error

View Answer Report Error Discuss

Filed Under: Decimal Fractions
Exam Prep: CAT , Bank Exams , AIEEE
Job Role: Bank PO , Bank Clerk

Q:

An owner of a Dry fruits shop sold small packets of mixed nuts for Rs. 150 each and large packets for Rs. 250 each. One day he sold 5000 packets, for a total of Rs. 10.50 lakh. How many small packets were sold ?

A) 2000 B) 3000
C) 2500 D) 3500
 
Answer & Explanation Answer: A) 2000

Explanation:

Let 's' be the number of small packets and 'b' the number of large packets sold on that day.

 

Therefore, s + b = 5000 ... eqn (1)

 

Each small packet was sold for Rs.150.
Therefore, 's' small packets would have fetched Rs.150s.

 

Each large packets was sold for Rs.250.
Therefore, 'b' large packets would have fetched Rs.250b.

 

Total value of sale = 150s + 250b = Rs. 10.5 Lakhs (Given)

 

Or 150s + 250b = 10,50,000 ... eqn (2)

 

Multiplying equation (1) by 150, we get 150s + 150b = 7,50,000 ... eqn (3)

 

Subtracting eqn (3) from eqn (2), we get 100b = 3,00,000
Or b = 3000

 

We know that s + b = 5000
So, s = 5000 - b = 5000 - 3000 = 2000.

 

2000 small packets were sold.

Report Error

View Answer Report Error Discuss

Filed Under: Simplification
Exam Prep: GATE , CAT , Bank Exams , AIEEE
Job Role: Bank PO , Bank Clerk