Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
8 Cards in this Set
- Front
- Back
____ is an excellent cross platform package that includes MySQL, the Apache web server and PHP.
•TextWrangler •SQL •XAMPP •Notepad ++ |
XAMPP |
|
In which flooded do you install or create your application so that they can be seen by the web server?
•local host •root •XAMPP •htdocs |
Htdocs |
|
The ___ statement is used to delete rows from a table, the ____ statement will remove the table from the database |
Delete, drop |
|
___ key provided both not null, and unique index constraint. And it provides an index named primary.
•index •alternative •unique •primary |
Primary |
|
If SELECT PI(); returns "3.141593", what will SELECT TRUNCATE (PI(), 3); return?
•593 •3.1 •3.14 •3.141 |
3.141 |
|
Apache is a web server, MySQL is a database server, PHP is the programming language. |
Apache, MySQL, PHP |
|
The _ user has lots of privileges. You need this in order to manage the database. Which is why phpMyAdmin uses it.
•admin •Linux •global •root |
Root |
|
Which of the following is correct SELECT statement?
•SELECT * FROM Album Label = 'Columbia'; •SELECT * FROM Album WHERE Label = Columbia; •SELECT * FROM Album WHERE Label = 'Columbia'; •SELECT COUNT FROM Album |
SELECT * FROM Album WHERE Label = 'Columbia'; |