LAMP Test
'Perfect Services' provides financial services worldwide. You want to display data from the table pers for joining_date from #1/1/2005# to #31/12/2005# and the job should either be of an analyst, a...
'Web Logic', a web hosting company, has two system administrators, and one of them has just been terminated from his position. What is the first thing that the current administrator should do to en...
A construction company is working on three projects: mall construction, residential construction and building business towers. A civil engineer can work only on one type of construction project but...
A production house has two sale outlets. Both the outlets are maintaining their data separately in servers A and B. The MD wants to see the sale of both the outlets in one report. Both the outlets ...
A user is trying to set a new password for his account. He wants to use the name of the company "MNC" as his password. Why would the system not allow this password?
Based on the code given below, what will be the value of $num if mytable contains 12 records? $result=mysql_query("DELETE from mytable"); $num=mysql_affected_rows();
Based on the code given below, what will be the value of, $num, if mytable contains 20 records out of which 10 have myprice=19, 5 have myprice=20 and 5 have myprice=2, before running the mysql_quer...
Check the structure of the following tables: Employee --------- Empno Employeename Salary Deptno Department --------- Deptno Departname Mike wants to see the departments that have more than 100 ...
Consider the following sample code: $x = 0xFFFE; $y = 2; $z = $x && $y; What will be the value of $z?
During heavy INSERT, UPDATE, and DELETE activity, indexes slow down the performance. Which of the following setting controls this behavior?
Food Cart Accounting System (FOCAS) is maintaining products in the products table, and wants to see the products which are 50 or more than 50 short of the minimum stock limit. The structure of the ...
How would you convert the date set in the following format into a PHP timestamp? $date = "Monday, July 28, 2008 @ 12:15 am";
Indexes are known to speed up the search but they have some limitations also. Which of the following queries take much time despite having indexes on table?
John Mark, an administrator, wants to set the Web server so that it will not show a directory listing if a user requests a page which is a directory. Which modification should he set up in the http...
Mike Johnson is running Apache on an extremely busy server where hundreds of requests per second is a requirement. He might have to change the default hard limits set in the MPM module. Which of th...
One of your PHP pages is very heavy and loading it takes about two minutes. But before it loads, a browser timeout occurs. Which of the following will help solve this problem?
Read the following code snippet: 1. for filename in *; do 2. if [ -f $filename ]; then 3. ls -l $filename 4. file $filename 5. else 6. echo $filename is not a regular file. 7...
Refer to the classes that are defined as follows: abstract class BaseCls{ protected abstract function getName(); } class ChildCls extends BaseCls{ } Which of the following implementation...
Refer to the code given below and select the while condition from the following options: $db = mysql_connect("localhost","root"); mysql_select_db("mydb",$db); $result = mysql_query("select state_i...
Refer to the following declarations of the php variables: $company = 'ABS Ltd'; $$company = ', Sydney'; ?> Which of the following is not a correct way of printing 'ABS Ltd , Sydney'?
Refer to the following statement: Select CustomerName, AccountNumber from Customers where AccountNumber in(select AccountNumber from Transactions where TransactionDate=#12/12/2005#) Which of the ...
Refer to the small php script given below: <?php class person{ function getSal() { . . . . . . } } class emp extends person{ function getSal() { ??? } } ?>...
Refer to the statements given below and identify which of the following is correct. Statement 1: Without any indexes, the database uses a lot of disk I/O and can effectively pollute the disk cache...
rpm -Uvh filename- 1.2-2.i386.rpm can be used to install an RPM package. What functions does it perform?
Sometimes it is necessary to create a temporary file to collect output for use by a later command. While creating such a file, you must make sure that the filename is unique enough so that no other...
State whether true or false: By allowing the use of .htaccess files in user (or customer or client) directories, you are essentially extending a bit of your Webmaster privileges to anyone who can ...
The Apache source distribution comes with a script called configure that allows you to configure the source tree before you compile and install the binaries. Which of the following is an incorrect ...
The architecture of MySql sets it apart from nearly every other database server. Which of the following are correct about different layers of MySql?
The include directive inserts the text of a document into the SSI document being processed. Which of the following statements has the correct syntax for the include directive?
The Manager and Office classes are as follows: <?php class Manager{ function printName() { echo "Manager"; } } class Office{ function getManager() { ...
To start the MySql server in Linux, you type the following from the command line: bin/safe_mysqld & What does the '&' mean in the command mentioned above?
What do you infer from the following code? <?php $str = 'Dear Customer, Thanks for your query. We will reply very soon.? Regards. Customer Service Agent'; print $str; ?>
What is the condition indicated if only the LI appears while attempting to boot a Linux system with LILO?
What is the function of the 'swapon' command while installing Linux in the command line interface mode?
What will be the output of the following code? $Rent = 250; function Expenses($Other) { $Rent = 250 + $Other; return $Rent; } Expenses(50); echo $Rent;
What will be the output of the following code? $var1="a"; $$var1="b"; echo "$var1 $a";
What will happen if the following code is executed? $resultSet = mysql_query("SELECT fname, lname FROM customers") for ($nIndex = 0; $nIndex < mysql_num_rows($resultSet) ; $nIndex++) { if ...
When a Unix program finishes, it leaves an exit code for the parent process that started the program. The exit code is a number. Which of the following numbers is returned if the program ran withou...
When Apache receives a URL request, it processes the request by serving the file to the client (the Web browser). It provides you with a flexible mechanism for rewriting the requested URL to a new ...
Whenever you create a table, MySQL stores the table definition in a file with the same name as the table. Which of the following is the extension of the table definition file?
Where would you install LILO to allow a dual bootable system on a 'system' which already has Microsoft Windows NT 4.0 with an installed NTFS partition?
Which of the following are correct regarding Linux devices?
Which of the following are correct regarding the .htaccess file in an Apache server?
Which of the following are correct with regard to indexes in MySql?
Which of the following are correct with regard to the sbin subdirectory of the root directory in Linux?
Which of the following are the valid operations that MySQL performs simultaneously when a table is dropped?
Which of the following can be used to implement data validation while creating a table in MySql?
Which of the following commands will you use if you need to strip the extension off of a filename or get rid of the directories in a full pathname?
Which of the following helps to keep an eye on the existing number of objects of a given class without introducing a non-class member variable?
Which of the following is correct for specifying the default value?
Which of the following is correct regarding the statements given below? Statement 1: Before the server can send the page to the browser it must send the http headers. Statement 2: session_start() ...
Which of the following is correct with regard to the statements given below? Statement 1: If the internal network uses nonroutable IP addresses for either security or cost reasons, you can use a p...
Which of the following is correct with regard to the statements given below? Statement 1: The current implementation of the optional proxy module does not support reverse proxy or the latest HTTP ...
Which of the following is correct with regard to the statements given below? Statement 1: When you set up Apache on an Internet host it can respond to an HTTP request for that host. Statement 2: A...
Which of the following is introduced in PHP5?
Which of the following is the correct way to check whether the cookie is set or not before retrieving the value from "LoginCookie"?
Which of the following is the standard authentication module, which implements Basic HTTP authentication?
Which of the following is true with regard to references in PHP?
Which of the following lines of the class mentioned below should be commented to execute the code without errors? 1 class Insurance 2 { 3 function clsName() 4 { 5...
Which of the following MySQL field names are correct?
Which of the following queries will correctly retrieve the ages and addresses of those students who have been studying in the school for the last 2 years?
Which of the following special variables of a shell script holds the number of arguments passed onto the script?
Which of the following statements are correct with respect to PHP connections?
Which of the following statements are correct with respect to the get_browser function of PHP?
Which of the following statements are incorrect regarding referential integrity?
Which of the following statements are true with regard to comparisons in PHP5?
Which of the following statements are true? Statement 1: mysql_fetch_object - Returns an object with properties that correspond to the fetched row, or FALSE if there are no more rows Statement 2: ...
Which of the following statements is incorrect with regard to PHP interfaces?
Which of the following subdirectory of the root directory provides system statistics through a directory-and-file interface which you can browse with standard Unix tools?
Which of the following ways of creation of a virtual web site is not supported by Apache?
Which permission setting allows a user to run an executable with the permission of the owner of that file?
Which program automatically determines the number of blocks in a device and sets some reasonable defaults?
Which sequence will run successfully for the code given below? <?php function Expenses() { function Salary() { } function Loan() { functi...
You are building Apache from the source distribution. Which of the following is a mandatory requirement for Apache installation?
You are facing a low key buffer problem. You want to increase the size of the key buffer from what it was set to at the startup. Which of the following is the correct syntax to perform this?
You have a table phone_book with 2 billion rows in it. Adding an index on last_name will require a lot of space. If the average last_name is 8 bytes long, you are looking at roughly 16 GB of space ...
You have an HTML file called mypage.html and you want to store meta headers of this html page. Which of the following directives specifies the filename extension for metainformation files?
You have defined three variables $to, $subject, and $body to send an email. Which of the following methods would you use to send an email?
You have just installed a Linux system. You have upgraded the kernel and packages to the latest versions and you have turned off all unnecessary services and daemons. What else should you do to enh...
You have to upload a file named "SalesFile" using the form post method mentioned below. What should be the code in line 3 to accomplish the same? 1 <input type="hidden" name="MAX_FILE_SIZE" val...
You need to allow only selected users from the users file into a particular area and you do not want to keep the username information in your .htaccess files. Which of the following is a correct st...
You want to enable SSI for a directory called '/www/mysite/htdocs/parsed'. Which of the following is the correct configuration to be added in httpd.conf?
You want to open a file in the PHP application and you also want this application to issue a warning and continue execution, in case the file is not found. Which of the following idea functions wou...
You want to see the block and character devices for which your system currently has drivers. Which of the following commands should you use in this scenario?