General LAMP MCQs

1. Why LAMP?

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

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

4. What port does squid listen, by default?

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

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

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

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

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

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

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

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

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

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

15. Which of the following represents root directory?

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

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

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

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

20. What is a superuser in mysql usually called ?

21. What will this command cp file1 file2 do?

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

23. What is MySQL?

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

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

26. What is GNU Linux?

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

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

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

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

31. An alternate name for a host is…

32. What is the name of a superuser in Linux?

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

34. What is HTTP?

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

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

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

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

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

40. Directive for definition a hostname is called…

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

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

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

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

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

46. When will a PHP session be closed?

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

48. Which ID always has a *nix superuser ?

49. What is SESSION in PHP?

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

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

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

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

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

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

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

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

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

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

60. Which of the following is TRUE about Inetd?

61. The SELinux (Security Enhanced Linux) security policies are enabled/disabled through which file?

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

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

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

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

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

67. Who clears a session files on server?

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

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

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

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

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

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

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

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

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

77. The default PHP session lifetime is…

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

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

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

81. Which can be used to implement data validation while creating a table in MySql?

82. '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 is correct?

83. Refer to the following declarations of the php variables: $company = 'ABS Ltd'; $$company = ', Sydney'; ?> Which is not a correct way of printing 'ABS Ltd , Sydney'?

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

85. Which 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.

87. You have an HTML file called mypage.html and you want to store meta headers of this html page. Which directives specifies the filename extension for metainformation files?

88. Which is correct for specifying the default value?

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

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

91. Which is the standard authentication module, which implements Basic HTTP authentication?

92. Which statement is true with regard to comparisons in PHP5?

93. Which is correct with regard to the sbin subdirectory of the root directory in Linux?

94. Which way of creation of a virtual web site is not supported by Apache?

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

96. Output of the following code? $Rent = 250; function Expenses($Other) { $Rent = 250 + $Other; return $Rent; } Expenses(50); echo $Rent;

97. Which is correct with regard to PHP functions?

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

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

100. Correct way to check whether the cookie is set or not before retrieving the value from 'LoginCookie'?

101. Which is introduced in PHP5?

102. Which is correct with regard to indexes in MySql?

103. Which can be used to implement data validation while creating a table in MySql?

104. Output of the following code? $var1='a'; $$var1='b'; echo '$var1 $a';

105. Which help to keep an eye on the existing number of objects of a given class without introducing a non-class member variable?

106. Which is correct regarding Linux devices?

107. Which statement is 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.

108. Which statement is incorrect regarding referential integrity?

109. '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 is correct?

110. 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 is correct with regard to creation of temporary files?

111. 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 is an incorrect server variable for URL Rewrite rules?

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

113. 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 use the same structure of the Sales table. Which method will you adopt to create this report?

115. You want to see the block and character devices for which your system currently has drivers. Which commands should you use in this scenario?

116. You want to set the variable 'sort_buffer_size' as non global so that it applies only to the current MySQL client session. Which statement is correctly defined with regard to this case?

117. What do you infer from the following code?

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

119. Which queries will correctly retrieve the ages and addresses of those students who have been studying in the school for the last 2 years?

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

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

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

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

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

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

126. You have defined three variables $to, $subject, and $body to send an email. Which method would you use to send an email?

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

128. 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 ''; while (...condition...) { echo ''. $myrow['state_text'].' '; } echo ''; }

129. The include directive inserts the text of a document into the SSI document being processed. Which statement has the correct syntax for the include directive?

130. Which statement is incorrect with regard to PHP interfaces?

131. Which 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.

132. Which is the valid operations that MySQL performs simultaneously when a table is dropped?

133. 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 will help in reducing the size of index space?

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

135. Abstract class BaseCls{ protected abstract function getName(); } class ChildCls extends BaseCls{ } Which implementation of getName() is invalid in ChildCls?

136. One of your PHP pages is very heavy and loading it takes about two minutes. But before it loads, a browser timeout occurs. Which will help solve this problem?

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

138. 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 hard limits should he change?

139. Which MySQL field names are correct?

140. Which subdirectory of the root directory provides system statistics through a directory-and-file interface which you can browse with standard Unix tools

141. Which is correct regarding the .htaccess file in an Apache server?

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

143. 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 querie return the required result?

144. 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 is an incorrect option for the configure script?

145. The architecture of MySql sets it apart from nearly every other database server. Which is correct about different layers of MySql?

146. what will be the value of $num if mytable contains 12 records? $result=mysql_query('DELETE from mytable'); $num=mysql_affected_rows();

147. Which statement is correct with respect to PHP connections?

148. Which 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.

149. Which 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.

150. Which statement is correct with respect to the get_browser function of PHP?

151. Which is true with regard to references in PHP?

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

153. 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 is the correct syntax to perform this?

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

155. Refer to the small php script given below: The getSal() of emp has to behave exactly as getSal() of person. Which lines of code would you use to replace the '???'

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

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

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

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

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

161. Which command will you use if you need to strip the extension off of a filename or get rid of the directories in a full pathname?

162. 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 2 Send this file: 3 4

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

164. Identify which 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.

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

166. 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)?

167. Select CustomerName, AccountNumber from Customers where AccountNumber in(select AccountNumber from Transactions where TransactionDate=#12/12/2005#) Which of the following is correct?

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