 |
 |
|
|
MySQL stored in tables as
Data
variables
items
SHOW ANSWERTable consist of
rows and columns
headings and paragraphs
border and design
SHOW ANSWERPHP combined with MySQL are called
cross-platform
alternate-platform
platform
SHOW ANSWERA query is a
Question or request
Syntax
Command
SHOW ANSWERWhat does SQL stand for?
Structured Query Language
Strong Question Language
Structured Question Language
SHOW ANSWERWhich SQL statement is used to update data in a database?
UPDATE
MODIFY
SAVE AS
SHOW ANSWERWhich SQL statement is used to delete data from a database?
DELETE
UPDATE
ALTER
SHOW ANSWERWhich SQL statement is used to delete data from a database?
DELETE
UPDATE
ALTER
SHOW ANSWERDML means:
Data Manipulation Language
Data Maintenance Language
Data Manipulated Language
SHOW ANSWERDCL means
Data Control Language
Data conditional language
Data content Language
SHOW ANSWERHow can you see all indexes defined for a table?
SHOW INDEX FROM TABLE
SHOW INDEX OF TABLE
SHOW INNDEX IN TABLE
SHOW ANSWERWhich SQL command is used to change a column from VARCHAR (10) to VARCHAR (50)?
ALTER
UPDATE
INSERT
SHOW ANSWERHow would you delete a column?
ALTER TABLE table name DROP column name
DELETE table name WHERE column name
DROP column name
SHOW ANSWER
