Exam Details
| Subject | programming with linux, apache,mysql, and php (lamp) | |
| Paper | ||
| Exam / Course | mca | |
| Department | ||
| Organization | Gujarat Technological University | |
| Position | ||
| Exam Date | June, 2017 | |
| City, State | gujarat, ahmedabad |
Question Paper
1
Seat No.: Enrolment
GUJARAT TECHNOLOGICAL UNIVERSITY
MCA SEMESTER- III EXAMINATION SUMMER 2017
Subject Code:3630010 Date: 09-06-2017
Subject Name: Programming with Linux, Apache, MySQL, and PHP (LAMP)
Time: 02:30 pm 05:00 pm Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1
Answer the Following.(Any Seven)
1. What is the use of isset() Function.
2. How can we destroy the Cookie?
3. How would you break up a delimited string into an array of substrings?
4. Which predefined variable do you use to find the name of the script?
5. What are the five arguments used by the mail() function?
6. What function do you use to find out whether a file is present on your file system?
7. How do you formulate a string comparison using LIKE to match first names of John or Joseph?
8. What are two advantages of using stored procedures?
9. Which PHP function retrieves the text of a MySQL error message?
07
What is open source? Explain importance of PHP, MySQL and Apache web server.
07
Q.2
Explain the Following Difference.
GET POST.
Static variable Global variable.
Numeric Associative Array.
02
03
02
(1)Write PHP code to sort array of five cities in ascending order.
Explain following functions with example(Any Two)
1. str_replace().
2. getdate().
3. strcmp()
03
04
OR
Explain with example how user defined functions used in php?
07
Q.3
What is JavaScript? How external JavaScript File Linking and what are the benefits of External file?
07
What is importance of form validation? Explain with example how to
validate form in PHP.
07
OR
Q.3
Write PHP Script Validate Email-id and Mobile Number.
07
Write PHP Script for Sending Mail.
07
Q.4
Explain following functions with Example.(Any Two)
1. CONCAT_WS().
2. SUBSTRING().
3. DATE_ADD().
What is Join? Explain type of Join In Mysql.
04
03
Explain Following Different.
1. Delete Versus Drop
2. MySQL Versus MySQLi
03
04
2
OR
Q.4
What are Transaction? Explain Basic Syntax used in Transaction.
07
1. Explain following functions with Example.(Any Two).
1. mysqli_connect_error()
2. mysqli_query().
3. mysqli_rollback()
2. Explain SQL injection.
04
03
Q.5
What is a cookie? Explain with example how to create and delete cookie in PHP.
07
Write PHP Script for Validating File.
07
OR
Q.5
Explain how to create image From User Input. Explain with Example.
07
How to create object in JSON? Explain with Example.
07
Seat No.: Enrolment
GUJARAT TECHNOLOGICAL UNIVERSITY
MCA SEMESTER- III EXAMINATION SUMMER 2017
Subject Code:3630010 Date: 09-06-2017
Subject Name: Programming with Linux, Apache, MySQL, and PHP (LAMP)
Time: 02:30 pm 05:00 pm Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1
Answer the Following.(Any Seven)
1. What is the use of isset() Function.
2. How can we destroy the Cookie?
3. How would you break up a delimited string into an array of substrings?
4. Which predefined variable do you use to find the name of the script?
5. What are the five arguments used by the mail() function?
6. What function do you use to find out whether a file is present on your file system?
7. How do you formulate a string comparison using LIKE to match first names of John or Joseph?
8. What are two advantages of using stored procedures?
9. Which PHP function retrieves the text of a MySQL error message?
07
What is open source? Explain importance of PHP, MySQL and Apache web server.
07
Q.2
Explain the Following Difference.
GET POST.
Static variable Global variable.
Numeric Associative Array.
02
03
02
(1)Write PHP code to sort array of five cities in ascending order.
Explain following functions with example(Any Two)
1. str_replace().
2. getdate().
3. strcmp()
03
04
OR
Explain with example how user defined functions used in php?
07
Q.3
What is JavaScript? How external JavaScript File Linking and what are the benefits of External file?
07
What is importance of form validation? Explain with example how to
validate form in PHP.
07
OR
Q.3
Write PHP Script Validate Email-id and Mobile Number.
07
Write PHP Script for Sending Mail.
07
Q.4
Explain following functions with Example.(Any Two)
1. CONCAT_WS().
2. SUBSTRING().
3. DATE_ADD().
What is Join? Explain type of Join In Mysql.
04
03
Explain Following Different.
1. Delete Versus Drop
2. MySQL Versus MySQLi
03
04
2
OR
Q.4
What are Transaction? Explain Basic Syntax used in Transaction.
07
1. Explain following functions with Example.(Any Two).
1. mysqli_connect_error()
2. mysqli_query().
3. mysqli_rollback()
2. Explain SQL injection.
04
03
Q.5
What is a cookie? Explain with example how to create and delete cookie in PHP.
07
Write PHP Script for Validating File.
07
OR
Q.5
Explain how to create image From User Input. Explain with Example.
07
How to create object in JSON? Explain with Example.
07
Other Question Papers
Subjects
- advance database management system
- advanced biopharmaceutics & pharmacokinetics
- advanced medicinal chemistry
- advanced networking (an)
- advanced organic chemistry -i
- advanced pharmaceutical analysis
- advanced pharmacognosy-1
- advanced python
- android programming
- artificial intelligence (ai)
- basic computer science-1(applications of data structures and applications of sql)
- basic computer science-2(applications of operating systems and applications of systems software)
- basic computer science-3(computer networking)
- basic computer science-4(software engineering)
- basic mathematics
- basic statistics
- big data analytics (bda)
- big data tools (bdt)
- chemistry of natural products
- cloud computing (cc)
- communications skills (cs)
- computer aided drug delivery system
- computer graphics (cg)
- computer-oriented numerical methods (conm)
- cyber security & forensics (csf)
- data analytics with r
- data mining
- data structures (ds)
- data visualization (dv)
- data warehousing
- data warehousing & data mining
- database administration
- database management system (dbms)
- design & analysis of algorithms(daa)
- digital technology trends ( dtt)
- discrete mathematics for computer science (dmcs)
- distributed computing (dc1)
- drug delivery system
- dynamic html
- enterprise resource planning (erp)
- food analysis
- function programming with java
- fundamentals of computer organization (fco)
- fundamentals of java programming
- fundamentals of networking
- fundamentals of programming (fop)
- geographical information system
- image processing
- industrial pharmacognostical technology
- information retrieving (ir)
- information security
- java web technologies (jwt)
- language processing (lp)
- machine learning (ml)
- management information systems (mis)
- mobile computing
- molecular pharmaceutics(nano tech and targeted dds)
- network security
- object-oriented programming concepts & programmingoocp)
- object-oriented unified modelling
- operating systems
- operation research
- operations research (or)
- pharmaceutical validation
- phytochemistry
- procedure programming in sql
- programming skills-i (ps-i-fop)
- programming skills-ii (ps-oocp)
- programming with c++
- programming with java
- programming with linux, apache,mysql, and php (lamp)
- programming with python
- search engine techniques (set)
- soft computing
- software development for embedded systems
- software engineering
- software lab (dbms: sql & pl/sql)
- software project in c (sp-c)
- software project in c++ (sp-cpp)
- software quality and assurance (sqa)
- statistical methods
- structured & object oriented analysis& design methodology
- system software
- virtualization and application of cloud
- web commerce (wc)
- web data management (wdm)
- web searching technology and search engine optimization
- web technology & application development
- wireless communication & mobile computing (wcmc)
- wireless sensor network (wsn)