This is a list of basic php and related questions, let’s see who knows their stuff.
- What does PHP, Apache & MySQL have in common?
- Name 2 cool thngs about Open Source Applications
- What is the purpose of MySQL?
- How many characters can be in a VARCHAR (length) field?
- A primary key must be unique and should never have a not NULL value. True/False
- Which function helps you to join 2 tables?
- Name 3 main types of errors you can find in Web Pages
- When does a Parse Error occur?
- What 4 elementary actions should you do to avoid errors in your code?
- Images file types can be converted in PHP. True/False
- Name 2 orders in which you can sort data and give a MySql command for each of these
- There are many types of searches, explain the simplest type.
- Why would one use the MATCH and WHERE clause in their search code?
- Name one way in which your searches can get complicated
- Give a brief description of a Relational Database
- Give any basic example of a relational database system used (Ex: Each superhero in a Superhero table has a League_ID that corresponds to an ID in the League table)
- Why is MySql the perfect choice for providing data via the internet?
- What is the typical syntax used to retrieve data by querying a database?
Let’s see who can answer the questions the quickest! Game on!
These posts are funny, but really isn’t useful.
I couldn’t parse your post because of a syntax error in the first question.
What does PHP, Apache & MySQL have in common?
What do PHP, Apache & MySQL have in common?
As far as I can see, nothing. Apache is a server designed to handle HTTP requests and return a page, using the driver it deems necessary. One of these is PHP. MySQL is software which PHP has, again, drivers to access. They’re used in web development, but so is a web browser (developing without using the browser regularly is like painting without looking at it regularly).
Open Source is generally a competitor to commercialism. Open Source applications are growing as fast as commercially built ones, thanks to the people who (a) gain benefit from product growth, (b) want their name on (potentially) widely used software, (b) just want to do some honest good for others or (d) have too much spare time on their hands. So essentially the main benefit it is often allows cheaper/free software of similar quality, and it also saves the energy used in producing, transporting and disposing of the tissue paper that many of the regular contributors under category (d) would pretty likely be using up with their otherwise spare time.
It makes data storage, managing and retrieval easier and faster. What I want to know is this: What is the purpose of a duvet? Why do humans have such a comfort requirement when dogs are happy with what they also wear throughout the daytime.
2^16 - 1.
False. It should always have a non-null value. I suppose one record may have a primary key equal to null but, being unique, none of the others should.
Lots of variations. You’re probably thinking of INNER JOIN, but LEFT JOIN, UNION and nested queries TECHNICALLY join 2 tables. Just with different results.
Typos, bad colour schemes and using XHTML without actually serving it as XML.
When you have had too much coffee and not enough sleep. Or when you’re using an outdated PHP version and are trying to use namespaces.
Sleep more. Drink less coffee. Pay attention to what you’re writing. Remove oven gloves before typing, after cooking.
True, kind of. The image function is handled by GD, so is technically C, but PHP calls the library.
Battery is dying on the laptop, so I will continue tomorrow if I remember. I’m annoyed there were no architecture or library development questions. Got my hopes up a bit…
These are all some pretty stupid, open ended questions fyi – school test? None the less, I left school a while ago – do your own damn homework – kids these days gesh…
This looks more like a database (well MySQL) quiz then a PHP quiz.
Only four of the questions have no mention of MySQL or database related.