Searching for "and"

Q:

Define what is a Fact, Dimension and Measure ?

Answer

Fact is key performance indicator to analyze the business.From the additive values, which are used to analyse the business by using report generation. Dimension is used to analyze the fact, are the non-additive ( text format) values, Which are used to drill down reports.Without dimension there is no meaning for fact. Measure is the quantity of data we create to process.

Report Error

View answer Workspace Report Error Discuss

Q:

In the following pieces of code, B and D will compile without any error. True or false ?

A: StringBuffer sb1 = "abcd";

B: Boolean b = new Boolean("abcd");

C: byte b = 255;

D: int x = 0x1234;

E: float fl = 1.2;

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

The code segments B and D will compile without any error. A is not a valid way to construct a StringBuffer, you need to create a StringBuffer object using "new". B is a valid construction of a Boolean (any string other than "true" or "false" to the Boolean constructor will result in a Boolean with a value of "false"). C will fail to compile because the valid range for a byte is -128 to +127 (i.e., 8 bits, signed). D is correct, 0x1234 is the hexadecimal representation in java. E fails to compile because the compiler interprets 1.2 as a double being assigned to a float (down-casting), which is not valid. You either need an explicit cast, as in "(float)1.2" or "1.2f", to indicate a float.

Report Error

View Answer Workspace Report Error Discuss

Q:

Both Joyel and Susy share a Windows 10 tablet with different user accounts. Joyel needs to access some files in Susy’s Documents folder. How can he do this ?

A) Joyel can access the files only if he has administrative rights B) Susy must choose to make the Documents folder Public for Joyel to see them
C) Joyel can, by default, see and access the files in any Documents folder on this computer D) Joyel cannot access those files without Susy moving them to another folder
 
Answer & Explanation Answer: A) Joyel can access the files only if he has administrative rights

Explanation:
Report Error

View Answer Report Error Discuss

Q:

What is the output after compile and run the following code ?

int Output = 10;
boolean b = false;
if((b == true) && ((Output += 10) == 20))
{
System.out.println("We are equal " + Output);
}
else
{
System.out.println("Not equal! " + Output);
}

A) Compilation and output of "We are equal 10" B) Compilation and output of "Not equal! 10"
C) Compilation error, attempting to perform binary comparison on logical data type D) Compilation and output of "Not equal! 20"
 
Answer & Explanation Answer: B) Compilation and output of "Not equal! 10"

Explanation:

The output will be "Not equal! 10". Please note that && is logical AND operator. If first operand before (&&) is false then the other operand will not be evaluated. This illustrates that the Output +=10 calculation was never performed because processing stopped after the first operand was evaluated to be false. If you change the value of b1 to true, processing occurs as you would expect and the output would be "We are equal 20".

Report Error

View Answer Report Error Discuss

Filed Under: Oracle Certification
Job Role: Analyst

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:

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