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

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, 28210 }

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, 5835 }

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 { 1257 }

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 { 1257 }

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 { 1508 }

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 { 1630 }

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 { 1528 }

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 { 1604 }

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 { 1499 }

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 { 1372 }

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 { 1548 }

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 { 1454 }

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 { 1429 }

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 { 1411 }

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

mahindhan