Question

which of the folowing can add a row to a table in php mcq question ans. 1 alter ,2 Add,3insert ,update ,?? fast​

Answer 1

Answer:

MYSQL QUESTIONS AND ANSWERS

1) MySQL runs on which operating systems?

a) Linux and Mac OS-X only

b) Any operating system at all

c) Unix, Linux, Windows and others

d) Unix and Linux only

Show Answer

2) To remove duplicate rows from the result set of a SELECT use the following keyword:

a) NO DUPLICATE

b) UNIQUE

c) DISTINCT

d) None of the above

Show Answer

3) Which of the following can add a row to a table?

a) Add

b) Insert

c) Update

d) Alter

Show Answer

4) To use MySQL on your computer, you'll need?

a) FTP and Telnet

b) Some sort of client program to access the databases

c) A Browser

d) Perl, PHP or Java

Show Answer

5) Which SQL statement is used to insert a new data in a database?

a) INSERT INTO

b) UPDATE

c) ADD

d) INSERT NEW

Show Answer

6) In a LIKE clause, you can could ask for any value ending in "qpt" by writing

a) LIKE %qpt

b) LIKE *ton

c) LIKE ton$

d) LIKE ^.*ton$

Show Answer

7) A NULL value is treated as a blank or 0.

a) True

b) Fasle

c) None of the above

Show Answer