Database Administration Questions


Q:

I jump when i walk and sit when i stand, who am I?

Answer

Kangaroo.

Report Error

View answer Workspace Report Error Discuss

3 2646
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 2636
Q:

Is boiling water a chemical change?

Answer

No. Boiling water is not a chemical change. Because in this process it doesn't loss its properties. It just changes its state i.e, from liquid state to gaseous.


 


Hence, Boiling water is a Physiacl change and not a chemical change.

Report Error

View answer Workspace Report Error Discuss

0 2633
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 2604
Q:

Define Executive Plan in Database SQL ?

Answer

Executive plan can be defined as:


* SQL Server caches collected procedure or the plan of query execution and used thereafter by subsequent calls.


* An important feature in relation to performance enhancement.


* Data execution plan can be viewed textually or graphically.

Report Error

View answer Workspace Report Error Discuss

7 2601
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 2601
Q:

You can use display planner to

A) add ads B) research keywords
C) display network D) All of the above
 
Answer & Explanation Answer: C) display network

Explanation:

Display Planner is a free Google Ads tool you can use to plan your Display Network ad campaigns.

Report Error

View Answer Report Error Discuss

3 2593
Q:

What areas would you like to further develop professionally?

Answer

Why they ask this and what they are looking for:


 


This question "What areas would you like to further develop professionally?" will uncover whether you are interested and knowledgeable about your own development and as such will can be a cloaked attempt to discover your weaknesses.


A common target of the question is to discover how motivated you are to extend yourself. If you are motivated to learn, then you are probably more motivated to do the job well.


 


How to answer this:


First show that you are concerned and active about your own development. You can indicate how development has worked for your in the past.


You're right, continued learning and development is important and I continue to work to improve key skills.


Do answer the question, of course, but do not show gaping holes in your skill set and especially those in key areas required in the job. A good trick is to talk about developing your skills in new areas that will be of future benefit to the company.


 


For example : I am in programming now and love the work, but one day I would like to develop into a management role.


 


Hope this helps you..!

Report Error

View answer Workspace Report Error Discuss

1 2593