Interview Questions

Q:

How can I retrieve values from one database server and store them in other database server using PHP?

Answer

we can always fetch from one database and rewrite to another. Here is a nice solution of it.$db1 = mysql_connect("host","user","pwd")
mysql_select_db("db1", $db1);
$res1 = mysql_query("query",$db1);$db2 = mysql_connect("host","user","pwd")
mysql_select_db("db2", $db2);
$res2 = mysql_query("query",$db2);At this point you can only fetch records from you previous ResultSet, i.e $res1 – But you cannot execute new query in $db1, even if you supply the link as because the link was overwritten by the new db.so at this point the following script will fail
$res3 = mysql_query("query",$db1); //this will failSo how to solve that?

take a look below.
$db1 = mysql_connect("host","user","pwd")
mysql_select_db("db1", $db1);
$res1 = mysql_query("query",$db1);

$db2 = mysql_connect("host","user","pwd", true)
mysql_select_db("db2", $db2);
$res2 = mysql_query("query",$db2);

So mysql_connect has another optional boolean parameter which indicates whether a link will be created or not, as we connect to the
$db2 with this optional parameter set to 'true', so both link will remain live.

Now the following query will execute successfully.
$res3 = mysql_query("query",$db1);

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

2 11132
Q:

find all Employee records containing the word "Joe", regardless of whether it was stored as JOE, Joe, or joe.

Answer

SELECT  * from Employees  WHERE  upper(EmpName) like upper('joe%');

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

7 11131
Q:

How many kinds of classes are there in c++?

A) 1 B) 2
C) 3 D) 4
 
Answer & Explanation Answer: B) 2

Explanation:

There are two kinds of classes in c++. They are absolute class and concrete class.

Report Error

View Answer Report Error Discuss

Filed Under: C++

7 11057
Q:

Tell us about a time when you missed a significant deadline

Answer

Tell us about a time when you missed a deadline.


(or)


Let's discuss a time when you missed a significant deadline.


If you answer something like "You never missed a deadline". Most interviewers will immediately conclude you are not experienced and may also feel you are lying. 


Approach - It is absolutely necessary to accept that you have missed a deadline and give reasons how you resolved and what you learned from it. This will demonstrate your experience.


You could say in one of the first projects earlier in your career you missed an important deadline and made the boss very upset. It was a great learning experience and after doing some introspection, you realized, you could have done better planning, prioritization and communication. Now, you use special tools, processes and methods to address these issues. Now your team, colleagues and management are always up to date so no surprises arise on meeting deadlines. 


Below are few things you may emphasize on in your response...


Effective planning


Procedural Improvements


Better Prioritization


Open communication


Better Status reporting

Report Error

View answer Workspace Report Error Discuss

11 11040
Q:

What is the difference between dao,rdo and ado explain simply ?

Answer

DAO (Data access object ) is used for accessing data before ado it was used for database installed on same sys where the application resides.


RDO (Remote data object ) is used for accessing remote data


ADO (Active data object ) most powerful till date it is nothing but combination of both DAO and RDO 

Report Error

View answer Workspace Report Error Discuss

8 11015
Q:

PHP allows you to send emails directly from a script.

php allows you to send emails directly from a script

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

The mail() function allows you to send emails directly from a script.


 

Report Error

View Answer Workspace Report Error Discuss

Subject: PHP
Exam Prep: Bank Exams
Job Role: IT Trainer , Project Manager , Software Architect

10 10918
Q:

How many types of modularization are there in c++?

A) 4 B) 3
C) 1 D) none of these
 
Answer & Explanation Answer: D) none of these

Explanation:

There are two types of modular programming.They are interface and implementation.

Report Error

View Answer Report Error Discuss

Filed Under: C++

6 10895
Q:

Why was PHP developed, what it is used for, and where can you get it?

Answer

PHP developed for less script, time saving, Free Open Source Software and runs on different platforms such as Windows, Linux, Unix, etc. PHP compatible with almost all servers used today such as Apache, IIS, etc.

The PHP scripting language resembles JavaScript, Java, and Perl, These languages all share a common ancestor, the C programming language. PHP has full access to the information that the server has, and very little access to information that the client has. In fact, it only has information that the client tells the server and that the server passes on to PHP. Because it is on the server, however, PHP cannot be modified by the client. While you cannot necessarily trust the information that the client gives to PHP, you can trust that your PHP is doing what you told it to do. Because PHP is on the server end, your PHP scripts can affect your server -- such as by keeping an activity log or updating a database.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

3 10762