> > LAMP MCQs > Basic LAMP MCQs

Basic LAMP MCQ

1.
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?

.tab

.frm

.tbk

.str

None of the above

Answer

Correct Answer: .frm

Note: This Question is unanswered, help us to find answer for this one

2.
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 following is correct?

In the sub query, * should be used instead of AccountNumber

The sub query can return only one row, so "in" should be replaced with "=in" the prime query

The sub query should be used first

None of the above

Answer

Correct Answer: None of the above

Note: This Question is unanswered, help us to find answer for this one

3.
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 more than one civil engineer can work on one project whereas a sales person can handle any type of projects and any number of sales people can work on one project. Define the nature of the relationship between (civil engineer and projects) and (sales person and projects)?

one to many, one to one

one to one, one to many

many to one, many to many

many to one, many to one

Answer

Correct Answer: many to one, many to many

Note: This Question is unanswered, help us to find answer for this one

4.
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 enhance security on the system?

Change the root password

Set up a telnet session

Audit your log files

Turn off network card

Answer

Correct Answer: Change the root password

Note: This Question is unanswered, help us to find answer for this one

5.
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.
Statement 2: Some extra disk space and a bit of CPU overhead is sacrificed on each INSERT, UPDATE, and DELETE query while using indexes.

Statement 1 is true but statement 2 is false

Statement 1 is false but statement 2 is true

Both the statements are true

Both the statements are false

Answer

Correct Answer: Both the statements are true

Note: This Question is unanswered, help us to find answer for this one

6.
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?

Directory "/www/mysite/htdocs/parsed"> Options +Includes SetFilter INCLUDES /Directory>

<Directory "/www/mysite/htdocs/parsed"> SetOutputFilter INCLUDES </Directory>

<Directory "/www/mysite/htdocs/parsed"> Options Included </Directory>

<Directory "/www/mysite/htdocs/parsed"> Options +Includes SetOutputFilter INCLUDES </Directory>

None of the above

Answer

Correct Answer: <Directory "/www/mysite/htdocs/parsed"> Options +Includes SetOutputFilter INCLUDES </Directory>

Note: This Question is unanswered, help us to find answer for this one

7.
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" value="30000" />
2    Send this file:
3
4    <input type="submit" value="Send File" />

input name="SalesFile" type="file" />

Answer

Correct Answer: input name="SalesFile" type="file" />

Note: This Question is unanswered, help us to find answer for this one

8.

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?

relativename

basename

firstname

None of the above

Answer

Correct Answer: basename

Note: This Question is unanswered, help us to find answer for this one

9.
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?

select * from articles (body) match against ('database')

select * from pages where page_text like "%buffy%"

select last_name from phone_book where last_name rlike "(son|ith)$"

select * from articles where body = "%database%"

All of the above

Answer

Correct Answer: select * from pages where page_text like "%buffy%"

Note: This Question is unanswered, help us to find answer for this one

10.
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 without problems?

108

None of the above

Answer

Correct Answer: 0

Note: This Question is unanswered, help us to find answer for this one

11.
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?

The minimum length of a password should be at least six characters

The characters cannot be in alphabetical order

Capital letters in a password cannot be used

The password is already in use by another user

Answer

Correct Answer: The minimum length of a password should be at least six characters

Note: This Question is unanswered, help us to find answer for this one

12.
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               echo get_class($this);
6           }
7        }

8        $cl = new Insurance();
9        $cl->clsName();
10        Insurance::clsName();

Line 8 and 9

Line 10

Line 9 and 10

All the three lines 8,9, and 10 should be left as it is

Answer

Correct Answer: Line 10

Note: This Question is unanswered, help us to find answer for this one

13.
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 edit those files.

True

False

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

14.
Refer to the small php script given below:

<?php

class person{

function getSal()

{

         . . .

         . . .

}

}

class emp extends person{

function getSal()

{

           ???

}

}

?>

The getSal() of emp has to behave exactly as getSal() of person. Which of the following lines of code would you use to replace the '???'

parent::getSal();

person::getSal();

parent::getSal;

person::getSal;

Answer

Correct Answer: parent::getSal();

Note: This Question is unanswered, help us to find answer for this one

15.
Which sequence will run successfully for the code given below?

<?php

function Expenses()

{

        function Salary()

     {

        }

        function Loan()

        {

                function Balance()

                {        }

        }

}

?>

Expenses();Salary();Loan();Balance();

Salary();Expenses();Loan();Balance();

Expenses();Salary();Balance();Loan();

Balance();Loan();Salary();Expenses();

Answer

Correct Answer: Expenses();Salary();Loan();Balance();

Note: This Question is unanswered, help us to find answer for this one

16.
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?

mysql> SET buffer=50M;

mysql> SET key_buffer=50M;

mysql> SET GLOBAL key_buffer=50M;

mysql> SET DEFAULT key_buffer=50M;

None of the above

Answer

Correct Answer: mysql> SET GLOBAL key_buffer=50M;

Note: This Question is unanswered, help us to find answer for this one

17.
What should you do before beginning the installation of Linux?

Partition the hard drive

Obtain a detailed hardware list

Configure the GUI interface

Install the boot manager

Answer

Correct Answer: Obtain a detailed hardware list

Note: This Question is unanswered, help us to find answer for this one

18.
Which of the following is true with regard to references in PHP?

It means accessing different variable content by a different name

It means accessing the same variable content by a different name

It means accessing the same variable content by the same name

It means accessing different variable content by the same name

Answer

Correct Answer: It means accessing the same variable content by a different name

Note: This Question is unanswered, help us to find answer for this one

19.
Which of the following statements are correct with respect to the get_browser function of PHP?

It is used to extract the client's browser information

It requires the browscap.ini to be placed on the server

It requires the browscap.ini to be placed on the client

None of the above is correct

Answer

Correct Answer: It is used to extract the client's browser information

Note: This Question is unanswered, help us to find answer for this one

20.
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 proxy server to provide Internet resources to hosts that normally cannot access the Internet.

Statement 2: Using a caching proxy such as Apache (with mod_perl), you can provide seemingly faster access to Internet resources to the local users.

Statement 1 is true but statement 2 is false

Statement 1 is false but statement 2 is true

Both the statements are true

Both the statements are false

Answer

Correct Answer: Both the statements are true

Note: This Question is unanswered, help us to find answer for this one

21.
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: Apache does not allow virtual hosts to inherit configuration from the main server, which makes the virtual host configuration quite manageable in large installations.

Statement 1 is true but statement 2 is false

Statement 1 is false but statement 2 is true

Both the statements are true

Both the statements are false

Answer

Correct Answer: Statement 1 is true but statement 2 is false

Note: This Question is unanswered, help us to find answer for this one

22.
Which of the following statements are correct with respect to PHP connections?

mysql_pconnect keeps the connection open across multiple requests

mysql_connect keeps the connection open across multiple requests

mysql_pconnect opens up a database connection for each page load

mysql_connect opens up a database connection for each page load

Answer

Correct Answer: mysql_pconnect keeps the connection open across multiple requests

Note: This Question is unanswered, help us to find answer for this one

23.
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();

undefined

Answer

Correct Answer: 0

Note: This Question is unanswered, help us to find answer for this one

24.
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 topmost layer is composed of the services that are not unique to MySQL

The second layer is made up of storage engines

c.The third layer is made up of storage engines

The interface between the second and the third layers is a single API not specific to any given storage engine

Answer

Correct Answer: The topmost layer is composed of the services that are not unique to MySQL

Note: This Question is unanswered, help us to find answer for this one

25.
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 option for the configure script?

--cache-file=file

--help-file

--exec-prefix=eprefix

--libexecdir=dir

None of the above

Answer

Correct Answer: --help-file

Note: This Question is unanswered, help us to find answer for this one

26.
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 employees. Which of the following queries returns the required result?

Select departname from department where deptno in (select deptnofrom employee group by deptno having count(*) > 100);

Select departname from department where deptno in (select count(*)from employee group by deptno where count(*) > 100);

Select departname from department where count(deptno) > 100;

Select departname from department where deptno in (select count(*)from employee where count(*) > 100);

Answer

Correct Answer: Select departname from department where deptno in (select deptnofrom employee group by deptno having count(*) > 100);

Note: This Question is unanswered, help us to find answer for this one

27.
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?

Master Boot Region

First sector of the NTFS partition

Last sector of the boot partition

First sector of the boot partition

Answer

Correct Answer: First sector of the boot partition

Note: This Question is unanswered, help us to find answer for this one

28.
Which of the following are correct regarding the .htaccess file in an Apache server?

The name '.htaccess' is universally acceptable

Any text editor can be used to create or make the changes to the .htaccess files

An .htaccess file is simply a text file containing Apache directives

Directives residing in the .htaccess file apply to the documents in the directory where the .htaccess file is located

Answer

Correct Answer: Any text editor can be used to create or make the changes to the .htaccess files

Note: This Question is unanswered, help us to find answer for this one

29.
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

etc

sbin

proc

lib

None of the above

Answer

Correct Answer: proc

Note: This Question is unanswered, help us to find answer for this one

30.
Which of the following MySQL field names are correct?

EmpNo

25Block

#AccountID

_CustomerName

Product.Name

Answer

Correct Answer: EmpNo

Note: This Question is unanswered, help us to find answer for this one

31.
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 the following hard limits should he change?

HARD_SERVER_LIMIT

HARD_THREAD_LIMIT

HARD_MPM_LIMIT

HARD_PROCESS_LIMIT

Answer

Correct Answer: HARD_SERVER_LIMIT

Note: This Question is unanswered, help us to find answer for this one

32.
Which program automatically determines the number of blocks in a device and sets some reasonable defaults?

mkbds4

mke2fs

mksdef

mkcntd

None of the above

Answer

Correct Answer: mke2fs

Note: This Question is unanswered, help us to find answer for this one

33.
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?

set_time_limit(60);

set_time_out(60);

set_time_limit(150);

set_time_out(150);

Answer

Correct Answer: set_time_limit(150);

Note: This Question is unanswered, help us to find answer for this one

34.
Refer to the classes that are defined as follows:

abstract class BaseCls{
protected abstract function getName();
}
class ChildCls extends BaseCls{
}

Which of the following implementations of getName() is invalid in ChildCls?

protected function getName(){}

function getName(){}

private function getName(){}

public function getName(){}

Answer

Correct Answer: private function getName(){}

Note: This Question is unanswered, help us to find answer for this one

35.
What is the function of the 'swapon' command while installing Linux in the command line interface mode?

It creates a swap area in RAM

It activates a created swap partition

It creates a swap partition

It creates and activates a swap partition

Answer

Correct Answer: It activates a created swap partition

Note: This Question is unanswered, help us to find answer for this one

36.
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 for the data portion of the index. Which of the following will help in reducing the size of index space?

Indexing only the first 4 bytes

Indexing on partition

Keeping the index in more than one file

None of the above

Answer

Correct Answer: Indexing only the first 4 bytes

Note: This Question is unanswered, help us to find answer for this one

37.
Which of the following are the valid operations that MySQL performs simultaneously when a table is dropped?

It removes all the rows from the table

It drops all the table's indexes

It removes all dependent views

It removes all dependent procedures

Answer

Correct Answer: It removes all the rows from the table

Note: This Question is unanswered, help us to find answer for this one

38.
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 1.1 protocol.

Statement 2: Apache can be turned into a caching (forward) proxy server.

Statement 1 is true but statement 2 is false

Statement 1 is false but statement 2 is true

Both the statements are true

Both the statements are false

Answer

Correct Answer: Both the statements are true

Note: This Question is unanswered, help us to find answer for this one

39.
Which of the following statements is incorrect with regard to PHP interfaces?

A class can implement multiple interfaces

An abstract class cannot implement multiple interfaces

An interface can extend multiple interfaces

Methods with the same name, arguments and sequence can exist in the different interfaces implemented by a class

Answer

Correct Answer: An abstract class cannot implement multiple interfaces

Note: This Question is unanswered, help us to find answer for this one

40.
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?

include file="path"

include virtual="URL"

include directive="path"

All of the above

Answer

Correct Answer: include file="path"

Note: This Question is unanswered, help us to find answer for this one

41.
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_id, state_text from states");
if ($result)
   {
   echo "<SELECT NAME='state_id'>";
   while (...condition...)
      {
      echo "<OPTION VALUE=\"".$myrow["state_id"]."\">".
           $myrow["state_text"]." </OPTION> ";
      }
   echo "</SELECT>";
   }

$myrow = mysql_fetch_array()

$myrow

$myrow = mysql_fetch_array($result)

$myrow = fetch_array($result)

Answer

Correct Answer: $myrow = mysql_fetch_array($result)

Note: This Question is unanswered, help us to find answer for this one

42.
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 would you use in this scenario?

include()

require()

nowarn()

getFile(false)

Answer

Correct Answer: include()

Note: This Question is unanswered, help us to find answer for this one

43.
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?

mail($to,$subject,$body)

sendmail($to,$subject,$body)

mail(to,subject,body)

sendmail(to,subject,body)

Answer

Correct Answer: mail($to,$subject,$body)

Note: This Question is unanswered, help us to find answer for this one

44.
How would you convert the date set in the following format into a PHP timestamp?

$date = "Monday, July 28, 2008 @ 12:15 am";

$date = replace("@ ","",$date); $date = strtotimestamp($date);

$date = replace("@ ","",$date); $date = strtotime($date);

$date = str_replace("@ ","",$date); $date = strtotime($date);

$date = str_replace("@ ","",$date); $date = strtotimestamp($date);

Answer

Correct Answer: $date = str_replace("@ ","",$date); $date = strtotime($date);

Note: This Question is unanswered, help us to find answer for this one

45.
You are building Apache from the source distribution. Which of the following is a mandatory requirement for Apache installation?

ANSI C Compiler

Perl 5 Interpreter

Dynamic Shared Object support

None of the above

Answer

Correct Answer: ANSI C Compiler

Note: This Question is unanswered, help us to find answer for this one

46.
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_query?

$resultSet=mysql_query("UPDATE mytable set myprice = 20 where myprice < 20");
$num=mysql_affected_rows();

Answer

Correct Answer: 10

Note: This Question is unanswered, help us to find answer for this one

47.
Consider the following sample code:

$x = 0xFFFE;
$y = 2;
$z = $x && $y;
What will be the value of $z?

Answer

Correct Answer: 1

Note: This Question is unanswered, help us to find answer for this one

48.
rpm -Uvh filename- 1.2-2.i386.rpm can be used to install an RPM package. What functions does it perform?

It installs with additional information and hash marks

It upgrades with additional information and hash marks

It does not upgrade if an older package is not already installed. If the older package exists, then it upgrades with additional information and hash marks

It installs the package with additional information and hash marks, then removes the old packages

Answer

Correct Answer: It installs with additional information and hash marks

Note: This Question is unanswered, help us to find answer for this one

49.
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?

It forces Mysql to ask the password

It forces Mysql to run in the background

It logins with windows login credentials

None of the above

Answer

Correct Answer: It forces Mysql to run in the background

Note: This Question is unanswered, help us to find answer for this one

50.
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?

$SQL_QUERY="select age,address from student where regdate ="; $SQL_QUERY .= "DATE_SUB(CURRENT_DATE,Interval 2 YEAR)";

$SQL_QUERY="select age,address from student where regdate ="; $SQL_QUERY .= "DATE_SUB(CURRENT_DATE,Interval 2)";

$SQL_QUERY="select age,address from student where regdate ="; $SQL_QUERY .= "CURRENT_DATE-2";

$SQL_QUERY="select age,address from student where regdate ="; $SQL_QUERY .= "Year(CURRENT_DATE)-Year(CURRENT_DATE-2)";

Answer

Correct Answer: $SQL_QUERY="select age,address from student where regdate ="; $SQL_QUERY .= "DATE_SUB(CURRENT_DATE,Interval 2 YEAR)";

Note: This Question is unanswered, help us to find answer for this one

51.
Read the following statement:

select * from Orders where OrderID=(select OrderID from OrderItems where ItemQty>50)

Which of the following correctly defines the error in the code given above?

In the sub query, * should be used instead of OrderID

The sub query can return more than one row, so, = should be replaced with in

The sub query should be used first

None of the above

Answer

Correct Answer: The sub query can return more than one row, so, = should be replaced with in

Note: This Question is unanswered, help us to find answer for this one

52.
What do you infer from the following code?

<?php
$str = 'Dear Customer,\nThanks for your query. We will reply very soon.?\n Regards.\n CustomerService Agent';
print $str;
?>

Only the first "\n" character will be recognized and the new line will be inserted

The last "\n" character will not be recognized and only the first two parts will come in the new lines

All the "\n" characters will work and the text will be printed on the respective new lines

All will be printed on one line irrespective of the "\n" characters

Answer

Correct Answer: All will be printed on one line irrespective of the "\n" characters

Note: This Question is unanswered, help us to find answer for this one

53.
You want to set the variable "sort_buffer_size" as non global so that it applies only to the current MySQL client session. Which of the following statements is correctly defined with regard to this case?

mysql> SET -ng sort_buffer_size=50M;

mysql> SET SESSION sort_buffer_size=50M;

mysql> SET SESSION_BASED sort_buffer_size=50M;

mysql> SET THREADED sort_buffer_size=50M;

Answer

Correct Answer: mysql> SET SESSION sort_buffer_size=50M;

Note: This Question is unanswered, help us to find answer for this one

54.
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?

list /proc/devices

show /proc/devices

find /proc/devices

cat /proc/devices

None of the above

Answer

Correct Answer: cat /proc/devices

Note: This Question is unanswered, help us to find answer for this one

55.
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 (!mysql_data_seek($resultSet, $nIndex))
        {
            echo "Cannot seek to row $nIndex\n";
            continue;
        }
        if(!($row = mysql_fetch_object($resultSet)))
            continue;
        echo "$row->fname $row->lname<br />\n";
}

The fnames and lnames of all the customers will be printed

The lnames and fnames of all the customers will be printed

The fnames and lnames of all the customers will be printed in the reverse order

Only the fname and lname of the first customer will be printed

Only the fname and lname of the last customer will be printed

Answer

Correct Answer: The fnames and lnames of all the customers will be printed

Note: This Question is unanswered, help us to find answer for this one

56.
What is the condition indicated if only the LI appears while attempting to boot a Linux system with LILO?

Primary boot loader has been started

Secondary boot loader has been loaded

Tertiary boot loader has been loaded

Secondary boot loader signals it has been loaded

Answer

Correct Answer: Secondary boot loader has been loaded

Note: This Question is unanswered, help us to find answer for this one

57.
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 one using custom URL rewrite rules. Which of the following is an incorrect server variable for URL Rewrite rules?

SERVER_PROTOCOL

SERVER_SOFTWARE

HTTP_REFERER

REMOTE_FORWARD

REMOTE_ADDR

Answer

Correct Answer: REMOTE_FORWARD

Note: This Question is unanswered, help us to find answer for this one

58.
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 programs accidentally write on the temporary file. Which of the following are correct with regard to creation of temporary files?

mktemp command can be used to create temporary filenames

The $$ special variable can be used to construct a temporary filename based on the process ID

All Linux flavors come with mktemp

You must use exit in the handler to explicitly end script execution

Answer

Correct Answer: mktemp command can be used to create temporary filenames

Note: This Question is unanswered, help us to find answer for this one

59.
'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 clerk or a salesman. Which of the following is correct?

select * from Pers where joining_date from #1/1/2005# to #31/12/2005#, job=Analyst or clerk or salesman

select * from Pers where joining_date between #1/1/2005# to #31/12/2005#, job=Analyst or job=clerk or job=salesman

select * from Pers where joining_date between #1/1/2005# and #31/12/2005# and (job=Analyst or clerk or salesman)

None of the above

Answer

Correct Answer: select * from Pers where joining_date between #1/1/2005# and #31/12/2005# and (job=Analyst or clerk or salesman)

Note: This Question is unanswered, help us to find answer for this one

60.
Which of the following statements are incorrect regarding referential integrity?

A foreign key can refer to a primary key

A foreign key can refer to a unique key

The on delete cascade clause will work only if there is a reference to a primary key

The referred key can either be in the same table or in some other table

A foreign key can be composite

Referential integrity can only be applied while creating the table

Answer

Correct Answer: A foreign key can refer to a primary key

Note: This Question is unanswered, help us to find answer for this one

61.
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: mysql_fetch_row - Returns a positive MySQL result resource to the query result, or FALSE on error.

All the statements are true

All the statements are false

Only Statement 1 is true

Only statement 2 is true

Answer

Correct Answer: Only Statement 1 is true

Note: This Question is unanswered, help us to find answer for this one

62.
Which of the following are correct regarding Linux devices?

The character devices work with data streams

The sockets are special-purpose I/O files offering a type of network interface

A block device's total size varies and a program has random access to any block in the device

A named pipe is like a character device, but there is another process at the other end of the I/O stream instead of a kernel driver

Answer

Correct Answer: The character devices work with data streams

Note: This Question is unanswered, help us to find answer for this one

63.
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?

Addition of a member variable that gets incremented in the default constructor and decremented in the destructor

Addition of a local variable that gets incremented in each constructor and decremented in the destructor

Addition of a static member variable that gets incremented in each constructor and decremented in the destructor

This cannot be accomplished since the creation of objects is being done dynamically via "new"

Answer

Correct Answer: Addition of a static member variable that gets incremented in each constructor and decremented in the destructor

Note: This Question is unanswered, help us to find answer for this one

64.
What will be the output of the following code?

$var1="a";

$$var1="b";

echo "$var1 $a";

a b

$var1 $a

Error: $a is undefined

Error: Parse error in line 2 ($$var1 = "b")

Answer

Correct Answer: a b

Note: This Question is unanswered, help us to find answer for this one

65.
Which of the following can be used to implement data validation while creating a table in MySql?

Checking constraint with specified values

Referential constraint by creating a foreign key for another table

Default value of a column

Null constraint

Answer

Correct Answer: Default value of a column
Null constraint

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

66.
Which of the following are correct with regard to indexes in MySql?

With clustered indexes, the primary key and the record itself are "clustered" together

When your data is almost always searched through via its primary key, clustered indexes can make lookups drastically slow

With separate indexes on first_name and last_name, MySQL can eliminate rows based on both fields

Indexes are not always used to locate matching rows for a query

Answer

Correct Answer: With clustered indexes, the primary key and the record itself are "clustered" together

Note: This Question is unanswered, help us to find answer for this one

67.
Which of the following is introduced in PHP5?

__construct

__construct and __destruct

__constructor and __destructor

__constructor

Answer

Correct Answer: __construct and __destruct

Note: This Question is unanswered, help us to find answer for this one

68.
Which of the following is the correct way to check whether the cookie is set or not before retrieving the value from "LoginCookie"?

isset($COOKIE['LoginCookie'])

isset($_COOKIE['LoginCookie'])

isCookieSet('$LoginCookie')

isCookieSet(['$LoginCookie'])

Answer

Correct Answer: isset($_COOKIE['LoginCookie'])

Note: This Question is unanswered, help us to find answer for this one

69.
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 httpd.conf?

User

ServerName

Remove indexes from configuration file

DocumentRoot

Answer

Correct Answer: Remove indexes from configuration file

Note: This Question is unanswered, help us to find answer for this one

70.
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 Products table is:
      ProductID
        ProductName
        CurrentStock
        MinimumStock

Two possible queries are:

Query 1:select * from products where currentStock>MinimumStock+50

Query 2:select * from products where currentStock-50>MinimumStock

Which of the following is correct?

Query 1 is true but Query 2 is false

Query 1 is false but Query 2 is true

Both the queries are true

Both the queries are false

Answer

Correct Answer: Both the queries are true

Note: This Question is unanswered, help us to find answer for this one

71.
Which of the following are correct with regard to PHP functions?

include() includes and evaluates a specific file

require() includes and evaluates a specific file

include_once() includes and evaluates a specific file only if it has not been included before

require_once() includes and evaluates a specific file only if it has not been included before

All of the above

Answer

Correct Answer: All of the above

Note: This Question is unanswered, help us to find answer for this one

72.
What will be the output of the following code?

$Rent = 250;
function Expenses($Other)
{
$Rent = 250 + $Other;
return $Rent;
}
Expenses(50);
echo $Rent;

300

250

200

The program will not compile

Answer

Correct Answer: 250

Note: This Question is unanswered, help us to find answer for this one

73.
Which permission setting allows a user to run an executable with the permission of the owner of that file?

Read

SUID

Write

SSH

Answer

Correct Answer: SUID

Note: This Question is unanswered, help us to find answer for this one

74.
Which of the following ways of creation of a virtual web site is not supported by Apache?

Name-based

IP-based

Multiple main servers

None of the above

Answer

Correct Answer: None of the above

Note: This Question is unanswered, help us to find answer for this one

75.
Which of the following are correct with regard to the sbin subdirectory of the root directory in Linux?

It is the place to find system executables

Programs in sbin directories pertain to system management

Regular users usually do not have sbin components in their command paths

All of the above

Answer

Correct Answer: All of the above

Note: This Question is unanswered, help us to find answer for this one

76.
Which of the following statements are true with regard to comparisons in PHP5?

With the "= =" operator, two object instances are equal if they have the same attributes and values, and are instances of different classes

With the "= =" operator, two object instances are equal if they have the same attributes and values, and are instances of the same class

With the (===) operator, object variables are identical if and only if they refer to the same instance of the same class

With the (===) operator, object variables are identical if and only if they refer to a different instance of the same class

Answer

Correct Answer: With the "= =" operator, two object instances are equal if they have the same attributes and values, and are instances of the same class

Note: This Question is unanswered, help us to find answer for this one

77.
Which of the following is the standard authentication module, which implements Basic HTTP authentication?

mod_auth

mod_auth_dbm

mod_auth_digest

mod_access

None of the above

Answer

Correct Answer: mod_auth

Note: This Question is unanswered, help us to find answer for this one

78.
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. fi
8. done

What does '-f' in line 2 mean?

It stores a file name in the memory

It tests all the items in the current file

It tests all the items in the current working directory

None of the above

Answer

Correct Answer: It tests all the items in the current working directory

Note: This Question is unanswered, help us to find answer for this one

79.
During heavy INSERT, UPDATE, and DELETE activity, indexes slow down the performance. Which of the following setting controls this behavior?

compound index

index_timer

delay_key_write

None of the above

Answer

Correct Answer: delay_key_write

Note: This Question is unanswered, help us to find answer for this one

80.
Which of the following is correct for specifying the default value?

function GetDiscount($Type = "Special") { . . . }

function GetDiscount(Type := "Special") { . . . }

function GetDiscount($Type := "Special") { . . . }

function GetDiscount($Type : "Special") { . . . }

Answer

Correct Answer: function GetDiscount($Type = "Special") { . . . }

Note: This Question is unanswered, help us to find answer for this one

81.
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?

MetaExt

MetaFileType

MetaExtension

MetaSuffix

Answer

Correct Answer: MetaSuffix

Note: This Question is unanswered, help us to find answer for this one

82.
The Manager and Office classes are as follows:

<?php
   class Manager{
       function printName() {
             echo "Manager";
       }
   }
   class Office{
       function getManager() {
             return new Manager();
       }
   }
$ofc = new Office();
???
?>

Which of the following should replace '???' to obtain the value of printName() function?

$ofc->getManager()->printName();

new Office()->getManager()->printName();

$ofc->getManager->printName;

Office::getManager()::printName();

Answer

Correct Answer: $ofc->getManager()->printName();

Note: This Question is unanswered, help us to find answer for this one

83.
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() is used to send some headers.

Statement 1 is true but statement 2 is false

Statement 1 is false but statement 2 is true

Both the statements are true

Both the statements are false

Answer

Correct Answer: Statement 1 is false but statement 2 is true

Note: This Question is unanswered, help us to find answer for this one

84.
Which of the following special variables of a shell script holds the number of arguments passed onto the script?

Answer

Correct Answer: $@

Note: This Question is unanswered, help us to find answer for this one

85.
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'?

echo "$company $$company";

echo "$company ${$company}";

echo "$company ${'ABS Ltd'}";

echo "$company {$$company}";

Answer

Correct Answer: echo "$company ${$company}";

Note: This Question is unanswered, help us to find answer for this one

86.
'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 clerk or a salesman. Which of the following is correct?

select * from Pers where joining_date from #1/1/2005# to #31/12/2005#, job=Analyst or clerk or salesman

select * from Pers where joining_date between #1/1/2005# to #31/12/2005#, job=Analyst or job=clerk or job=salesman

select * from Pers where joining_date between #1/1/2005# and #31/12/2005# and (job=Analyst or clerk or salesman)

None of the above

Answer

Correct Answer: None of the above

Note: This Question is unanswered, help us to find answer for this one

87.
Which of the following can be used to implement data validation while creating a table in MySql?

Checking constraint with specified values

Referential constraint by creating a foreign key for another table

Default value of a column

Null constraint

Answer

Correct Answer: Checking constraint with specified values

Note: This Question is unanswered, help us to find answer for this one

88. What is the precision limit for MySQL datatype DOUBLE?

Answer

Correct Answer: 53

Note: This Question is unanswered, help us to find answer for this one

89. What is the maximum allowable length of MySQL datatype VARCHAR?

256

There is no limit

2000

1000

Answer

Correct Answer: 2000

Note: This Question is unanswered, help us to find answer for this one

90. Which of the following holds environment variables used when starting Apache?

/etc/httpd/conf/httpd.conf

/etc/sysconfig/httpd

/etc/httpd/conf.d/application.conf

/etc/httpd/conf.d

Answer

Correct Answer: /etc/sysconfig/httpd

Note: This Question is unanswered, help us to find answer for this one

91. The default PHP session lifetime is…

24 min

30 min

there is no lifetime

60 min

Answer

Correct Answer: 24 min

Note: This Question is unanswered, help us to find answer for this one

92. Which of the following commands will match commands with keyword(s) on their main pages?

whatis

head

man

apropos

Answer

Correct Answer: apropos

Note: This Question is unanswered, help us to find answer for this one

93. Which of the following commands can be used to set stick bit on a file?

chmod 2644 file

chmod 1645 file

chmod 1455 file

set 466 file

Answer

Correct Answer: chmod 1645 file

Note: This Question is unanswered, help us to find answer for this one

94. At login which of the following is first read by C shell?

.cshrc

Both .cshrc and .login

.login

.profile

Answer

Correct Answer: .cshrc

Note: This Question is unanswered, help us to find answer for this one

95. Which of the following commands can be used for setting attributes on files/folders?

attr

chattr

setattr

chmod

Answer

Correct Answer: chattr

Note: This Question is unanswered, help us to find answer for this one

96. What output will be If you try to perform an arithmetic operation on a column containing NULL values?

Cannot be determined

None of the above

An error will be generated

Answer

Correct Answer: 0

Note: This Question is unanswered, help us to find answer for this one

97. Which of the following is NOT a valid unix env variable?

USR

HOME

ARCH

HOST

Answer

Correct Answer: USR

Note: This Question is unanswered, help us to find answer for this one

98. Which of the following Linux command can be used to output the shared library dependencies ?

libd

libdd

ldd

Answer

Correct Answer: ldd

Note: This Question is unanswered, help us to find answer for this one

99. Which of the following Linux command outputs the processor architecture ?

arch

proc

procarch

info

Answer

Correct Answer: arch

Note: This Question is unanswered, help us to find answer for this one

100. Which of the following command can be used to shutdown an already running MySQL server?

./mysqld -u root -p shutdown

./mysqladmin -u root -p shutdown

./safe_mysqld -u root -p shutdown

./mysqladmin -u root -p kill

Answer

Correct Answer: ./mysqladmin -u root -p shutdown

Note: This Question is unanswered, help us to find answer for this one

101. Who clears a session files on server?

garbage cleaner daemon

no one

Apache

PHP [Garbage Collector]

Answer

Correct Answer: PHP [Garbage Collector]

Note: This Question is unanswered, help us to find answer for this one

102. Which of the following is not a VALID MySQL datatype?

DOUBLE

STRING

DATE

DATETIME

Answer

Correct Answer: STRING

Note: This Question is unanswered, help us to find answer for this one

103. What will happen if AUTO INCREMENT field reaches its maximum value?

error message will appear

everything will start again from 0

None of the above

everything will start again from 1

Answer

Correct Answer: error message will appear

Note: This Question is unanswered, help us to find answer for this one

104. What is the output of the command "service httpd configtest" if no errors are found in Apache's configuration file?

*.conf files OK

Syntax OK

configtest OK

Config OK

Answer

Correct Answer: Syntax OK

Note: This Question is unanswered, help us to find answer for this one

105. The command "service httpd ______" allows users to check the syntax of Apache's configuration files.

testconfig

configtest

chkconfig

configchk

Answer

Correct Answer: configtest

Note: This Question is unanswered, help us to find answer for this one

106. In which tcp_wrappers file can you specify all connections from all hosts?

/etc/tcp.conf

/etc/hosts.allow

/etc/hosts

/etc/hosts.deny

Answer

Correct Answer: /etc/hosts.allow

Note: This Question is unanswered, help us to find answer for this one

107. Which of the following is TRUE about Inetd?

(both are correct)

UNIX handles many of its services through the internet daemon (inetd), as opposed to a constantly running daemon

(neither is correct)

Inetd is a super server that listens to the various ports and handles connection requests as it receives them

Answer

Correct Answer: (both are correct)

Note: This Question is unanswered, help us to find answer for this one

108. Where can you set up a server's name?

php.ini

httpd.conf

/etc/hosts

Answer

Correct Answer: httpd.conf

Note: This Question is unanswered, help us to find answer for this one

109. What is the year range for MySQL datatype YEAR (2)?

1969 to 2070

1099 to 2099

1900 to 2099

1970 to 2069

Answer

Correct Answer: 1970 to 2069

Note: This Question is unanswered, help us to find answer for this one

110. One advantage of hard links over symbolic links is:

A hard link allows you to change the permissions on the underlying file

You can determine the inode used by a hard link, but not for a symbolic link

A hard link can span different filesystems

A hard link does not become disconnected from the underlying file if the file is moved

Answer

Correct Answer: A hard link does not become disconnected from the underlying file if the file is moved

Note: This Question is unanswered, help us to find answer for this one

111. Are the IOT (Index Organized Tables) supported by MySQL?

yes

the support will be added in the next (6) version

no [it's the Oracle's type]

Answer

Correct Answer: no [it's the Oracle's type]

Note: This Question is unanswered, help us to find answer for this one

112. Which of the following command can be used to get the value of env variables?

env

printenv

Both env and printenv

echo

Answer

Correct Answer: Both env and printenv

Note: This Question is unanswered, help us to find answer for this one

113. Which of the following Apache Control Command: apachectl directive restarts the Apache httpd daemon?

Both graceful and restart

start

graceful

restart

Answer

Correct Answer: Both graceful and restart

Note: This Question is unanswered, help us to find answer for this one

114. What will be the output of the following code? <? echo false; ?>

Nothing

None of the above

Syntax error

Answer

Correct Answer: Nothing

Note: This Question is unanswered, help us to find answer for this one

115. Which of the following is an INVALID column in user table in mysql database?

Truncate_priv

Insert_priv

Select_priv

Delete_priv

Answer

Correct Answer: Truncate_priv

Note: This Question is unanswered, help us to find answer for this one

116. What will be the output of command mysqladmin -u root -p create TEST?

Invalid Command

It will create a new table TEST

It will create a new database TEST

It will create a new user TEST

Answer

Correct Answer: It will create a new database TEST

Note: This Question is unanswered, help us to find answer for this one

117. How to use other/additional extensions/file types for PHP scripts, instead of using just .php?

edit the 'extension' directive in php.ini

None of the above

edit the extensions in php.ini

use AddType directive in httpd.conf

Answer

Correct Answer: use AddType directive in httpd.conf

Note: This Question is unanswered, help us to find answer for this one

118. What is SESSION in PHP?

a file in the cloud

a record in config file

a text file

Answer

Correct Answer: a text file

Note: This Question is unanswered, help us to find answer for this one

119. Which ID always has a *nix superuser ?

100

Answer

Correct Answer: 0

Note: This Question is unanswered, help us to find answer for this one

120. What is the size limit for strings in php?

100Mbytes

256Kbytes

There is no limit (hardware limit)

1024bytes

Answer

Correct Answer: There is no limit (hardware limit)

Note: This Question is unanswered, help us to find answer for this one

121. When will a PHP session be closed?

after a span of user inactivity

every 15 minutes

when the browser is closed

when the browser is closed or after a span of user inactivity

Answer

Correct Answer: when the browser is closed or after a span of user inactivity

Note: This Question is unanswered, help us to find answer for this one

122. What's the name of a time-based job scheduler in *nix systems?

chronos

crontab

shell

cron

Answer

Correct Answer: cron

Note: This Question is unanswered, help us to find answer for this one

123. You need to use SSL Certificates on your Apache server. Which of the directives you need to assign inside <VirtualHost> section of Apache configuration file?

SSLEngine

SSLCertificateFile

SSLCertificateKeyFile

All of these

Answer

Correct Answer: All of these

Note: This Question is unanswered, help us to find answer for this one

124. What will be the ouput of this command: head -5 test.txt

It will write the first 5 lines of test.txt to the screen

It will create a new file with first 5 lines from test.txt

It will create a new file with last 5 lines from test.txt

It will write the last 5 lines of test.txt to the screen

Answer

Correct Answer: It will write the first 5 lines of test.txt to the screen

Note: This Question is unanswered, help us to find answer for this one

125. Which of the following is a way to restart Apache on *nix system?

apache restart

apache reboot

httpd reboot

httpd restart

Answer

Correct Answer: httpd restart

Note: This Question is unanswered, help us to find answer for this one

126. Which of the following statement tells the server to reload the grant tables?

RELOAD PRIVILEGES

UPDATE PRIVILEGES

REFRESH PRIVILEGES

FLUSH PRIVILEGES

RESET PRIVILEGES

Answer

Correct Answer: FLUSH PRIVILEGES

Note: This Question is unanswered, help us to find answer for this one

127. Directive for definition a hostname is called…

ServerName

Hostel

NameOfTheHost

Host

Answer

Correct Answer: ServerName

Note: This Question is unanswered, help us to find answer for this one

128. What's the name of file, where user's information can be stored?

config

biscuit

php.ini

Answer

Correct Answer: cookie

Note: This Question is unanswered, help us to find answer for this one

129. What has a higher priority: a record from the hosts file or a record from the DNS-server?

a record from the hosts file

nothing

a record from the DNS-server

both

Answer

Correct Answer: a record from the hosts file

Note: This Question is unanswered, help us to find answer for this one

130. Which of the following is NOT a main apache directory?

conf

logs

htdocs

apps

Answer

Correct Answer: apps

Note: This Question is unanswered, help us to find answer for this one

131. What domain name will have the following address - 127.0.0.1?

there is no name for this address

localhost

test

home

Answer

Correct Answer: localhost

Note: This Question is unanswered, help us to find answer for this one

132. What's LAMP (in the most cases)?

Linux + Apache+MySQL +Python

Linux + ASP+MySQL +Python

Linux + Apache+MySQL +PHP

Linux + Apache+MySQL +Perl

Answer

Correct Answer: Linux + Apache+MySQL +PHP

Note: This Question is unanswered, help us to find answer for this one

133. What is HTTP?

HyperThreading Transfer Protocol

nothing

Home Television Transfer Protocol

Hypertext Transfer Protocol

Answer

Correct Answer: Hypertext Transfer Protocol

Note: This Question is unanswered, help us to find answer for this one

134. The name of a web-based interface for work with databases is called…

myadmin

webDBadmin

phpmyadmin

mysqladmin

Answer

Correct Answer: phpmyadmin

Note: This Question is unanswered, help us to find answer for this one

135. What's the name of Apache configuration file?

config.ini

httpd.conf

https.conf

config.conf

Answer

Correct Answer: httpd.conf

Note: This Question is unanswered, help us to find answer for this one

136. Which PHP extension is required for work with MySQL?

php_msql

php_my_sql

php_db

php_mysql

Answer

Correct Answer: php_mysql

Note: This Question is unanswered, help us to find answer for this one

137. Are there any variations of LAMP for other platforms?

yes [WAMP, WIMP (for Windows), MAMP (Mac OS), BAMP (BSD)]

Answer

Correct Answer: yes [WAMP, WIMP (for Windows), MAMP (Mac OS), BAMP (BSD)]

Note: This Question is unanswered, help us to find answer for this one

138. What language should you use for writing a queries for database?

Java

PHP

Python

SQL

Answer

Correct Answer: SQL

Note: This Question is unanswered, help us to find answer for this one

139. What is GNU Linux?

programming language

the nickname of Linus Torvalds

operating system

the name of penguin

Answer

Correct Answer: operating system

Note: This Question is unanswered, help us to find answer for this one

140. Which directive is used to determine a virtual host?

Answer

Correct Answer: <VirtualHost>...</VirtualHost>

Note: This Question is unanswered, help us to find answer for this one

141. How can you block users by IP address or by domain?

using a php.ini file

using a .htaccess file

.htpasswd

this is impossible

Answer

Correct Answer: using a .htaccess file

Note: This Question is unanswered, help us to find answer for this one

142. What is MySQL?

it's a variation of a structured query language

it's a PHP interpreter

it's a database server

it's a programming language

Answer

Correct Answer: it's a database server

Note: This Question is unanswered, help us to find answer for this one

143. You do not have to specify a length with which of the following MySQL datatypes?

TINYTEXT

MEDIUMBLOB

TINYBLOB

All of the options are valid

Answer

Correct Answer: All of the options are valid

Note: This Question is unanswered, help us to find answer for this one

144. What will this command cp file1 file2 do?

Will make a copy of file1 in the root directory and call it file2

Will make a copy of file1 in the current working directory and call it file2 and will delete file1

Will make a copy of file1 in the root directory and call it file2 and will delete file1

Will make a copy of file1 in the current working directory and call it file2

Answer

Correct Answer: Will make a copy of file1 in the current working directory and call it file2

Note: This Question is unanswered, help us to find answer for this one

145. Which of the following Linux command can be used to change the group ownership of files ?

chgrp

changegrp

chggrp

chggroup

Answer

Correct Answer: chgrp

Note: This Question is unanswered, help us to find answer for this one

146. What will be the output of command mysqladmin -u root -p drop TEST?

Invalid Command

It will drop TEST database

It will drop TEST table

It will drop TEST user

Answer

Correct Answer: It will drop TEST database

Note: This Question is unanswered, help us to find answer for this one

147. How can you start a session in PHP script?

sessionstart()

session_begin()

start_ session()

session_start()

Answer

Correct Answer: session_start()

Note: This Question is unanswered, help us to find answer for this one

148. Where hosts file (on *nix systems) is usually located?

/usr/etc/hosts

/etc/hosts

/root/hosts

/var/www/hosts

Answer

Correct Answer: /etc/hosts

Note: This Question is unanswered, help us to find answer for this one

149. Which of the following represents root directory?

"\*"

"/"

"\"

"*/"

Answer

Correct Answer: "/"

Note: This Question is unanswered, help us to find answer for this one

150. Which of the following Linux command can be used to change file owner and group ?

chgowner

chown

chggrp

chwn

Answer

Correct Answer: chown

Note: This Question is unanswered, help us to find answer for this one

151. Which of the following are VALID SELinux (Security Enhanced Linux) security policies?

httpd_enable_cgi

httpd_enable_homedirs

httpd_ssi_exec

All of the options are valid

Answer

Correct Answer: All of the options are valid

Note: This Question is unanswered, help us to find answer for this one

152. Which of the following is the main Apache configuration file?

/etc/apache.conf

/etc/srm.conf

/etc/httpd/conf/httpd.conf

/etc/httpd/config.ini

Answer

Correct Answer: /etc/httpd/conf/httpd.conf

Note: This Question is unanswered, help us to find answer for this one

153. What does "." (DOT) signify in Unix?

Parent Directory

Root Directory

It is not supported

Current directory

Answer

Correct Answer: Current directory

Note: This Question is unanswered, help us to find answer for this one

154. How to see information about PHP configuration from a script?

phpinfo()

phpconfig()

php_info()

php_config()

Answer

Correct Answer: phpinfo()

Note: This Question is unanswered, help us to find answer for this one

155. Which of the following is not a valid directive of Apache Control Command (apachectl)?

start

kill

stop

status

Answer

Correct Answer: kill

Note: This Question is unanswered, help us to find answer for this one

156. What will be the output of this command : ls list* ?

This will list all files in the current directory ending with list

This will list all files in the root directory starting with list

This will list all files in the current directory starting with list

This will list all files in the root directory ending with list

Answer

Correct Answer: This will list all files in the current directory starting with list

Note: This Question is unanswered, help us to find answer for this one

157. Which of the following apache directory has all server configuration files?

htdocs

conf

logs

cgi-bin

Answer

Correct Answer: conf

Note: This Question is unanswered, help us to find answer for this one

158. To quote a string within a string, which of the following can you use?

'This is the "quoted" message'

'This is the quoted" message"'

This is the "quoted" message

Answer

Correct Answer: 'This is the "quoted" message'

Note: This Question is unanswered, help us to find answer for this one

159. Which of the following Linux command outputs the available free space in local hard-disk partitions?

free

fdisk

Answer

Correct Answer: df

Note: This Question is unanswered, help us to find answer for this one

160. What does the following error "Access denied for user 'root'@'localhost' (using password: YES)" mean?

wrong password

wrong database name

wrong password and username

wrong username

Answer

Correct Answer: wrong password

Note: This Question is unanswered, help us to find answer for this one

161. Which of the following file is a MySQL configuration file?

/etc/conf/my.cnf

/etc/mysql.cnf

/etc/conf/mysql.cnf

/etc/my.cnf

Answer

Correct Answer: /etc/my.cnf

Note: This Question is unanswered, help us to find answer for this one

162. Why LAMP?

all servers work under Linux

it's flexible, productive, widespread and low cost (all components can be downloaded for free from Internet)

there are no alternative

only professionals can work with other alternatives

Answer

Correct Answer: it's flexible, productive, widespread and low cost (all components can be downloaded for free from Internet)

Note: This Question is unanswered, help us to find answer for this one

LAMP MCQs | Topic-wise

MCQ on Basic LAMP

General LAMP MCQs

LAMP Subjects

More Resources

LAMP MCQ

LAMP Skill Assessment

LAMP PDF

Related MCQs

Linux MCQs

Lisp Programming MCQs

Machine learning MCQs

Magento MCQs

MATLAB MCQs

Basic LAMP MCQ

1. 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?

2. 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 following is correct?

4. 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 enhance security on the system?

6. 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?

7. 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" value="30000" /> 2 Send this file: 3 4 <input type="submit" value="Send File" />

8. 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?

9. 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?

10. 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 without problems?

11. 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?

12. 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 echo get_class($this); 6 } 7 } 8 $cl = new Insurance(); 9 $cl->clsName(); 10 Insurance::clsName();

13. 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 edit those files.

14. Refer to the small php script given below: <?php class person{ function getSal() { . . . . . . } } class emp extends person{ function getSal() { ??? } } ?> The getSal() of emp has to behave exactly as getSal() of person. Which of the following lines of code would you use to replace the '???'

15. Which sequence will run successfully for the code given below? <?php function Expenses() { function Salary() { } function Loan() { function Balance() { } } } ?>

16. 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?

17. What should you do before beginning the installation of Linux?

18. Which of the following is true with regard to references in PHP?

19. Which of the following statements are correct with respect to the get_browser function of PHP?

22. Which of the following statements are correct with respect to PHP connections?

23. 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();

24. The architecture of MySql sets it apart from nearly every other database server. Which of the following are correct about different layers of MySql?

25. 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 option for the configure script?

26. 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 employees. Which of the following queries returns the required result?

27. 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?

28. Which of the following are correct regarding the .htaccess file in an Apache server?

29. 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

30. Which of the following MySQL field names are correct?

31. 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 the following hard limits should he change?

32. Which program automatically determines the number of blocks in a device and sets some reasonable defaults?

33. 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?

34. Refer to the classes that are defined as follows: abstract class BaseCls{ protected abstract function getName(); } class ChildCls extends BaseCls{ } Which of the following implementations of getName() is invalid in ChildCls?

35. What is the function of the 'swapon' command while installing Linux in the command line interface mode?

37. Which of the following are the valid operations that MySQL performs simultaneously when a table is dropped?

38. 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 1.1 protocol. Statement 2: Apache can be turned into a caching (forward) proxy server.

39. Which of the following statements is incorrect with regard to PHP interfaces?

40. 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?

42. 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 would you use in this scenario?

43. 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?

44. How would you convert the date set in the following format into a PHP timestamp? $date = "Monday, July 28, 2008 @ 12:15 am";

45. You are building Apache from the source distribution. Which of the following is a mandatory requirement for Apache installation?

47. Consider the following sample code: $x = 0xFFFE; $y = 2; $z = $x && $y; What will be the value of $z?

48. rpm -Uvh filename- 1.2-2.i386.rpm can be used to install an RPM package. What functions does it perform?

49. 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?

50. 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?

51. Read the following statement: select * from Orders where OrderID=(select OrderID from OrderItems where ItemQty>50) Which of the following correctly defines the error in the code given above?

52. What do you infer from the following code? <?php $str = 'Dear Customer,\nThanks for your query. We will reply very soon.?\n Regards.\n CustomerService Agent'; print $str; ?>

53. You want to set the variable "sort_buffer_size" as non global so that it applies only to the current MySQL client session. Which of the following statements is correctly defined with regard to this case?

54. 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?

56. What is the condition indicated if only the LI appears while attempting to boot a Linux system with LILO?

59. '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 clerk or a salesman. Which of the following is correct?

60. Which of the following statements are incorrect regarding referential integrity?

61. 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: mysql_fetch_row - Returns a positive MySQL result resource to the query result, or FALSE on error.

62. Which of the following are correct regarding Linux devices?

63. 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?

64. What will be the output of the following code? $var1="a"; $$var1="b"; echo "$var1 $a";

65. Which of the following can be used to implement data validation while creating a table in MySql?

66. Which of the following are correct with regard to indexes in MySql?

67. Which of the following is introduced in PHP5?

68. Which of the following is the correct way to check whether the cookie is set or not before retrieving the value from "LoginCookie"?

69. 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 httpd.conf?

71. Which of the following are correct with regard to PHP functions?

72. What will be the output of the following code? $Rent = 250; function Expenses($Other) { $Rent = 250 + $Other; return $Rent; } Expenses(50); echo $Rent;

73. Which permission setting allows a user to run an executable with the permission of the owner of that file?

74. Which of the following ways of creation of a virtual web site is not supported by Apache?

75. Which of the following are correct with regard to the sbin subdirectory of the root directory in Linux?

76. Which of the following statements are true with regard to comparisons in PHP5?

77. Which of the following is the standard authentication module, which implements Basic HTTP authentication?

78. 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. fi 8. done What does '-f' in line 2 mean?

79. During heavy INSERT, UPDATE, and DELETE activity, indexes slow down the performance. Which of the following setting controls this behavior?

80. Which of the following is correct for specifying the default value?

81. 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?

82. The Manager and Office classes are as follows: <?php class Manager{ function printName() { echo "Manager"; } } class Office{ function getManager() { return new Manager(); } } $ofc = new Office(); ??? ?> Which of the following should replace '???' to obtain the value of printName() function?

83. 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() is used to send some headers.

84. Which of the following special variables of a shell script holds the number of arguments passed onto the script?

85. 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'?

86. '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 clerk or a salesman. Which of the following is correct?

87. Which of the following can be used to implement data validation while creating a table in MySql?

88. What is the precision limit for MySQL datatype DOUBLE?

89. What is the maximum allowable length of MySQL datatype VARCHAR?

90. Which of the following holds environment variables used when starting Apache?

1.
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?

2.
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 following is correct?

4.
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 enhance security on the system?

6.
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?

7.
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" value="30000" />
2 Send this file:
3
4 <input type="submit" value="Send File" />

8.

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?

9.
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?

10.
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 without problems?

11.
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?

12.
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 echo get_class($this);
6 }
7 }

8 $cl = new Insurance();
9 $cl->clsName();
10 Insurance::clsName();

13.
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 edit those files.

15.
Which sequence will run successfully for the code given below?

<?php

function Expenses()

{

function Salary()

{

}

function Loan()

{

function Balance()

{ }

}

}

?>

16.
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?

17.
What should you do before beginning the installation of Linux?

18.
Which of the following is true with regard to references in PHP?

19.
Which of the following statements are correct with respect to the get_browser function of PHP?

22.
Which of the following statements are correct with respect to PHP connections?

23.
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();

24.
The architecture of MySql sets it apart from nearly every other database server. Which of the following are correct about different layers of MySql?

25.
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 option for the configure script?

26.
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 employees. Which of the following queries returns the required result?

27.
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?

28.
Which of the following are correct regarding the .htaccess file in an Apache server?

29.
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

30.
Which of the following MySQL field names are correct?

31.
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 the following hard limits should he change?

32.
Which program automatically determines the number of blocks in a device and sets some reasonable defaults?

33.
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?

34.
Refer to the classes that are defined as follows:

abstract class BaseCls{
protected abstract function getName();
}
class ChildCls extends BaseCls{
}

Which of the following implementations of getName() is invalid in ChildCls?

35.
What is the function of the 'swapon' command while installing Linux in the command line interface mode?

37.
Which of the following are the valid operations that MySQL performs simultaneously when a table is dropped?

38.
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 1.1 protocol.

Statement 2: Apache can be turned into a caching (forward) proxy server.

39.
Which of the following statements is incorrect with regard to PHP interfaces?

40.
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?

42.
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 would you use in this scenario?

43.
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?

44.
How would you convert the date set in the following format into a PHP timestamp?

$date = "Monday, July 28, 2008 @ 12:15 am";

45.
You are building Apache from the source distribution. Which of the following is a mandatory requirement for Apache installation?

47.
Consider the following sample code:

$x = 0xFFFE;
$y = 2;
$z = $x && $y;
What will be the value of $z?

48.
rpm -Uvh filename- 1.2-2.i386.rpm can be used to install an RPM package. What functions does it perform?

49.
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?

50.
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?

51.
Read the following statement:

select * from Orders where OrderID=(select OrderID from OrderItems where ItemQty>50)

Which of the following correctly defines the error in the code given above?

52.
What do you infer from the following code?

<?php
$str = 'Dear Customer,\nThanks for your query. We will reply very soon.?\n Regards.\n CustomerService Agent';
print $str;
?>

53.
You want to set the variable "sort_buffer_size" as non global so that it applies only to the current MySQL client session. Which of the following statements is correctly defined with regard to this case?

54.
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?

56.
What is the condition indicated if only the LI appears while attempting to boot a Linux system with LILO?

59.
'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 clerk or a salesman. Which of the following is correct?

60.
Which of the following statements are incorrect regarding referential integrity?

62.
Which of the following are correct regarding Linux devices?

63.
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?

64.
What will be the output of the following code?

$var1="a";

$$var1="b";

echo "$var1 $a";

65.
Which of the following can be used to implement data validation while creating a table in MySql?

66.
Which of the following are correct with regard to indexes in MySql?

67.
Which of the following is introduced in PHP5?

68.
Which of the following is the correct way to check whether the cookie is set or not before retrieving the value from "LoginCookie"?

69.
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 httpd.conf?

71.
Which of the following are correct with regard to PHP functions?

72.
What will be the output of the following code?

$Rent = 250;
function Expenses($Other)
{
$Rent = 250 + $Other;
return $Rent;
}
Expenses(50);
echo $Rent;

73.
Which permission setting allows a user to run an executable with the permission of the owner of that file?

74.
Which of the following ways of creation of a virtual web site is not supported by Apache?

75.
Which of the following are correct with regard to the sbin subdirectory of the root directory in Linux?

76.
Which of the following statements are true with regard to comparisons in PHP5?

77.
Which of the following is the standard authentication module, which implements Basic HTTP authentication?

78.
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. fi
8. done

What does '-f' in line 2 mean?

79.
During heavy INSERT, UPDATE, and DELETE activity, indexes slow down the performance. Which of the following setting controls this behavior?

80.
Which of the following is correct for specifying the default value?

81.
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?

82.
The Manager and Office classes are as follows:

<?php
class Manager{
function printName() {
echo "Manager";
}
}
class Office{
function getManager() {
return new Manager();
}
}
$ofc = new Office();
???
?>

Which of the following should replace '???' to obtain the value of printName() function?

83.
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() is used to send some headers.

84.
Which of the following special variables of a shell script holds the number of arguments passed onto the script?

85.
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'?

86.
'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 clerk or a salesman. Which of the following is correct?

87.
Which of the following can be used to implement data validation while creating a table in MySql?