LAMP MCQ Questions Answers

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. Select CustomerName, AccountNumber from Customers where AccountNumber in(select AccountNumber from Transactions where TransactionDate=#12/12/2005#) Which of the following is correct?

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

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?

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

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

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

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 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. 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: The getSal() of emp has to behave exactly as getSal() of person. Which lines of code would you use to replace the '???'

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

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

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

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

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

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

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

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

23. 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 is 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 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 querie return 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 is correct regarding the .htaccess file in an Apache server?

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

30. Which 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 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 will help solve this problem?

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

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

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

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

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

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

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

41. 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 ''; }

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

43. You have defined three variables $to, $subject, and $body to send an email. Which method 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 is a mandatory requirement for Apache installation?

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

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 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 correctly defines the error in the code given above?

52. What do you infer from the following code?

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 statement 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 commands should you use in this scenario?

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
\n'; }

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

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

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

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

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

61. Which statement is incorrect regarding referential integrity?

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

63. Which is correct regarding Linux devices?

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

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

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

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

68. Which is introduced in PHP5?

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

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

72. Which is correct with regard to PHP functions?

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

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

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

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

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

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

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

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

81. Which is correct for specifying the default value?

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

83. The Manager and Office classes are as follows: Which should replace '???' to obtain the value of printName() function?

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

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

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

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

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

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

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

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

92. The default PHP session lifetime is…

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

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

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

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

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

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

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

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