Interview Questions Answers in Dot Net General, MySQL, Advanced Java, C Code, ASP.NET, Apache Pig, Servlets

mahindhan

{ City } chennai
< Country > india
* Profession * ceo
User No # 125107

Total Questions Posted # 38
Total Answers Posted # 63

Total Answers Posted for My Questions # 42
Total Views for My Questions # 54433

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 0

Questions / { mahindhan }

Questions Answers Category Views Company eMail

. How .NET can support multiple languages?

1 Dot Net General 1427

How can you manage pagination on a page using .Net?

1 Dot Net General 1392

Explain different types of cookies in .NET?

1 Dot Net General 1234

.What is Marshaling?

2 Dot Net General 1670

What are the different parts of an Assembly in .Net?

1 Dot Net General 1432

What are the fundamental objects in ADO.NET?

1 Dot Net General 1415

What is the difference between a Hash Table and a Dictionary?

1 Dot Net General 1356

Garbage collector thread is what kind of a thread?

1 Dot Net General 1289

State the methods used during deserialization and serialization process.

2 Dot Net General 1651

Explain the two different types of typecasting?

1 Dot Net General 1376

Give an example program for Getter /read-only methods in JAVA

1 Dot Net General 1341

Give an example for setter/ write-only methods

1 Dot Net General 1289

Explain the use of ‘this’ keyword in Java?

1 Dot Net General 1378

Explain role-based security in .Net.

2 Dot Net General 1792

How can a user get the current SQL version?

2 MySQL 1802

[1] 2 3 Next

Answers / { mahindhan }

Question { 7805 }

What is serialization and de-serialization ?

Answer

Serialization is the process of converting the state of an object into a form (a stream of bytes) to be persisted or transported. Deserialization converts a stream into an object and is the opposite of serialization. These processes allow data to be stored and transferred.

Is This Answer Correct ?

0 Yes

0 No

Question { Wipro, 27459 }

why java is platform independent?

Answer

Java is called platform independent because of its byte codes which can run on any system irrespective of its underlying operating system.

Is This Answer Correct ?

0 Yes

0 No

Question { Fidelity, 5645 }

WHAT IS OBJECT POOLING

Answer

Object Pooling is a concept for optimal use of limited resources through software constructs. The ready-to-use objects, connections, and threads are stored in a pool (group) of objects in memory for later use. For creating a new object, it is pulled from the pool and allocated for the request. Pooling helps in improving performance and facilitates scalability.

Is This Answer Correct ?

0 Yes

0 No

Question { 1131 }

What is a tuple?

Answer

Tuples refer to the collections of the same or different types of data. The size of tuples is always fixed (1 - 8) and the developer must apply the size that they want at declaration time.

Is This Answer Correct ?

0 Yes

0 No

Question { 1131 }

What is a tuple?

Answer

Tuples refer to the collections of the same or different types of data. The size of tuples is always fixed (1 - 8) and the developer must apply the size that they want at declaration time.

Is This Answer Correct ?

0 Yes

0 No

Question { 1386 }

What is Request Dispatcher?

Answer

Request Dispatcher is an interface whose implementation defines an object which can dispatch the request to any resources on the server.

Is This Answer Correct ?

0 Yes

0 No

Question { 1512 }

What are Heap tables?

Answer

Heap tables are in-memory tables used for high-speed temporary storage. But, TEXT or BLOB fields are not allowed within them. They also do not support AUTO INCREMENT.

Is This Answer Correct ?

0 Yes

0 No

Question { 1400 }

What are the drivers in MySQL?

Answer

In MySQL, standards-based drivers for JDBC, ODBC, and .Net are provided in order to enable developers in building database applications with their language of choice.
Drivers in MySQL:
 PHP Driver
 JDBC Driver
 ODBC Driver
 C WRAPPER
 PYTHON Driver
 PERL Driver
 RUBY Driver
 CAP11PHP Driver
 Ado.net5.mxj

Is This Answer Correct ?

0 Yes

0 No

Question { 1464 }

What is the life cycle of a servlet?

Answer

Loading Servlet.
Then initialising the Servlet.
Handling the Request (invoking service method).
Then destroying the Servlet.

Is This Answer Correct ?

0 Yes

0 No

Question { 1366 }

How is a managed code executed?

Answer

Execute a Managed code by following these steps:
•Choosing a language compiler depending on the language in which the code is written.
•Converting the above code into Intermediate language by its own compiler.
•The IL is then targeted to CLR which converts the code into native code with the help of JIT.
•Execution of Native code.

Is This Answer Correct ?

0 Yes

0 No

Question { 1273 }

How can you find out the version of the installed mysql?

Answer

The version of the installed MySQL server can be found out easily by running the following command from the MySQL prompt. mysql> SHOW VARIABLES LIKE “%version%”;

Is This Answer Correct ?

0 Yes

0 No

Question { 1433 }

Which mysql function is used to concatenate string?

Answer

CONCAT() function is used to combine two or more string data. The use of this function is here with an example.
Example: The following SELECT query with CONCAT() function will combine five words, ‘Welcome ‘, ‘to’, ‘SoftwareTestingHelp’,’.’ and ‘com’.

SELECT CONCAT('Welcome ',to ','SoftwareTestingHelp','.',com');

Is This Answer Correct ?

0 Yes

0 No

Question { 1346 }

What is a join? Explain the different types of mysql joins.

Answer

The SQL statement that is used to make a connection between two or more tables based on the matching columns is called a join. It is mainly used for complex queries.
Different types of SQL joins are mentioned below:
 Inner Join: It is a default join. It returns records when the values match in the joining tables.
 Left Outer Join: It returns all the records from the left table based on the matched records from the right table.
 Right Outer Join: It returns all the records from the right table based on the matched records from the left table.
 Full Outer Join: It returns all the records that match from the left or right table.

Is This Answer Correct ?

0 Yes

0 No

Question { 1326 }

What are aggregate functions in mysql?

Answer

The MySQL aggregate function performs a calculation on a set of values, and it returns a single value as output. It ignores NULL values when it performs calculation except for the COUNT function.
MYSQL Aggregrate functions are listed below:
 AVG()
 COUNT()
 SUM()
 MIN()
 MAX()

Is This Answer Correct ?

0 Yes

0 No

Question { 1291 }

What are the difference between mongodb and mysql?

Answer

MONGO DB
The representation of data in MongoDB is totally different from Mysql, as in MongoDB data is represented in the collection of JSON documents.
MongoDB is an object-oriented database

MYSQL
The representation of Mysql database is totally different form Mongodb, as in Mysql data is stored in the form of tables (Row and columns).
Mysql is a structured query database.

Is This Answer Correct ?

0 Yes

0 No

[1] 2 3 4 5 Next