Questions

Q:

Which dml command is used in conjunction with @@identity?

A) INSERT and UPDATE B) UPDATE and DELETE
C) SCOPE_IDENTITY and IDENT_CURRENT D) Commit and rollback
 
Answer & Explanation Answer: C) SCOPE_IDENTITY and IDENT_CURRENT

Explanation:

Using automatically incrementing IDENTITY columns is very popular with database developers. You don’t need to explicitly calculate unique surrogate keys when inserting new data, the IDENTITY column functionality does that for you. The IDENTITY feature also allows you to specify useful Seed and Increment properties. When you use an INSERT statement to insert data into a table with an IDENTITY column defined, SQL Server will generate a new IDENTITY value.

 

You can use the @@IDENTITY variable and the SCOPE_IDENTITY and IDENT_CURRENT functions to return the last IDENTITY value that has been generated by SQL Server. This is very useful when you need to return the key for the row that has just been inserted, back to the caller.

Report Error

View Answer Report Error Discuss

9 6584
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

6 6584
Q:

Who has won the men's singles title at the 82nd Senior National Championship?

A) H S Prannoy B) Ashwini Kumar
C) Rakesh Kumar D) Kidambi Srikanth
 
Answer & Explanation Answer: A) H S Prannoy

Explanation:

H S Prannoy has won the men’s singles title at the 82nd Senior National Championship Senior National Badminton Championships in Nagpur, Maharashtra on November 8, 2017. He defeated higher ranked Kidambi Srikanth in the final by 21- 15, 16- 21, 21-7.

Report Error

View Answer Report Error Discuss

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

21 6581
Q:

The third vehicle in Buddhism was Known as

A) Mahasanghika B) Zen
C) Vajrayana D) None of these
 
Answer & Explanation Answer: C) Vajrayana

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Indian History

7 6580
Q:

What grows when it eats but dies when it drinks?

Answer

A fire grows when it eats but dies when it drinks.

Report Error

View answer Workspace Report Error Discuss

Subject: Logic Puzzles Exam Prep: AIEEE , Bank Exams , GRE
Job Role: Analyst , Bank Clerk , Bank PO , IT Trainer

12 6578
Q:

In which district of Andhra Pradesh, the Kuchipudi village is located from which the Kuchipudi dance

A) Anantapur B) Krishna
C) Kurnool D) Nellore
 
Answer & Explanation Answer: B) Krishna

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Indian Culture

86 6577
Q:

Richest Municipal Corporation in India?

A) Hyderabad B) Mumbai
C) Delhi D) Ludhiana
 
Answer & Explanation Answer: B) Mumbai

Explanation:

Brihanmumbai Municipal Corporation (BMC), is the governing civic body of Mumbai, the Municipal Corporation of Greater Mumbai, Maharashtra is India's richest municipal corporation. The BMC's annual budget exceeds that of some of the smaller states of India.

Richest_Municipal_Corporation_in_India1551769040.jpg image

Report Error

View Answer Report Error Discuss

Filed Under: General Awareness
Exam Prep: Bank Exams , AIEEE , CAT
Job Role: Bank PO , Bank Clerk , Analyst

6 6575
Q:

Heavy water is

A) PH7 B) rain water
C) deuterium oxide D) tritium oxide
 
Answer & Explanation Answer: C) deuterium oxide

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: General Science

22 6574