To insert 2 values into a table, you use which query?

  • INSERT INTO `table`(column, column2) VALUES('One', 'Two')

When connecting to a database through PHP, do you use mysql or mysqli?

  • mysqli

To update a table using a WHERE clause, we’d write: UPDATE table SET column='New Value' WHERE column IS NOT NULL

  • ture

Before insert information into a database for any reason, you need to escape the content so you don’t get SQL hacked (injected)

  • true

How do you store passwords?

  • One way encryption.

The following SQL query will get how many columns from the table? SELECT * FROM table

  • All

© 2018 Micro Solutions Bangladesh and/or MCQ Academy.