IT Trainer Questions


Q:

The multi part identifier could not be bound is

Answer

One of the most common errors that you might face in join statements is 


 


Server: Msg 4104, Level 16, State 1, Line 1
The multi-part identifier could not be bound.


 


A multipart identifier is any description of a field or table that contains multiple parts - for instance MyTable.SomeRow - if it can't be bound that means there's something wrong with it - either you've got a simple typo, or a confusion between table and column. It can also be caused by using reserved words in your table or field names and not surrounding them with [].


 


The main reason for this error is that the source table cannot be found, for example if you have statement such as Table1.OrderDate, and then if you get error above, this means that Table1 cannot be found in the query. Sometimes you can see that source table exists in the query, but T-SQL cannot understand it, especially when you write join statements.

Report Error

View answer Workspace Report Error Discuss

0 2229
Q:

What is the difference between creating String as new() and literal ?

Answer

When we create string with new() Operator, it’s created in heap and not added into string pool while String created using literal are created in String pool itself which exists in PermGen area of heap.



String s = new String("Test");

does not put the object in String pool , we need to call String.intern() method which is used to put them into String pool explicitly. its only when you create String object as String literal e.g. String s = "Test" Java automatically put that into String pool.

Report Error

View answer Workspace Report Error Discuss

1 2229
Q:

One major cause of floods is

A) light rain over a large area B) a decrease in stream discharge
C) rapid spring snowmelt D) increased capacity of stream channels
 
Answer & Explanation Answer: C) rapid spring snowmelt

Explanation:

There are lots of reasons behind the flood in any area but the main reason is a heavy downpour or rapid snowmelt can flood canyons with a mixture of soil, rock, and water is a major cause of floods.

 

When the spring times come, sometimes there's a lot of warmth that suddenly comes, especially nowadays when there are things such as global warming. So the snow melts and large amounts of water can flood the fields that are often found at the foot of a mountain or similar things.

 

But they may also be caused by deforestation, drainage channel modification from a landslide, earthquake or volcanic eruption. Examples include outburst floods and lahars.

 

 

Report Error

View Answer Report Error Discuss

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

1 2226
Q:

What is the opposite of opposite?

A) Identical B) Not alike
C) Not same D) Contrast
 
Answer & Explanation Answer: A) Identical

Explanation:

Opposite means not identical, not same, not alike, contrast...

 

Here in the question, the opposite of the word opposite is asked and is opposite of not same , not identical or not alike is same, like, identical,...

Report Error

View Answer Report Error Discuss

Filed Under: English
Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE , TOEFL
Job Role: Analyst , Bank Clerk , Bank PO , IT Trainer

1 2225
Q:

Which is a reserved word in the java programming language?

A) Variable B) Identifier
C) Keyword D) Main
 
Answer & Explanation Answer: C) Keyword

Explanation:

Reserved words are words that cannot be used as object or variable names in a Java program because they're already used by the syntax of the Java programming language.

Java reserved words are keywords that are reserved by Java functions or other uses that cannot be used as identifiers (e.g., variable names, function names, class names).

If a reserved word was used as a variable you would get an error or unexpected result.

 

Examples : Int, Long, Abstract, Class, Break, Catch, Case, Public, Static, Void,...

 

 

Report Error

View Answer Report Error Discuss

1 2213
Q:

A practice to learn something

a_practice_to_learn_something1551439875.jpg image

A) Poem B) Summary
C) Lesson D) Introduction
 
Answer & Explanation Answer: C) Lesson

Explanation:

A practice to learn something is a Lesson.

Report Error

View Answer Report Error Discuss

4 2212
Q:

Callous is the opposite of

A) emotionally hardened B) insensitive
C) sympathetic D) Unkind
 
Answer & Explanation Answer: C) sympathetic

Explanation:

A callous person is insensitive or emotionally hardened.

 

Hence, Callous is the opposite of Sympathetic, kind hearted, sensitive, nice,...

Report Error

View Answer Report Error Discuss

Filed Under: Alphabet Test
Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE , TOEFL
Job Role: Analyst , Bank Clerk , Bank PO , IT Trainer

3 2211
Q:

What is String Args in Java?

Answer

String Args (String []) is an array of parameters of type String.


In Java, 'args' contains the supplied command-line arguments as an array of String objects. In other words, if you run your program as 'java MyProgram Hello World' then 'args' will contain ["Hello", "World"]. When a java class is executed from the console, the main method is what is called.

Report Error

View answer Workspace Report Error Discuss

9 2211