FUNDAMENTALS OF COMPUTER

WEB BROWSERS TECHNOLOGY

WHAT IS WEB TECHNOLOGY

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of these statements were true?
A
The SQL query must be quoted in PHP
B
String values inside the SQL query must not be quoted
C
Numeric values must be quoted
D
The word NULL must be quoted
Explanation: 

Detailed explanation-1: -The mysqli query function is used to execute SQL queries.

Detailed explanation-2: -Which of the following statement is true? Explanation: The SQL TRUNCATE command is used to delete all the rows from the table and free the space containing the table.

Detailed explanation-3: -Correct statements are: b) the quote (q) operator can be used to escape a “’´ in a literal and c) Date values must be enclosed within single quotation marks. Each string or date value needs to be declared as a string by enclosing it in single quotes.

Detailed explanation-4: -The correct answer to the question “Which of the SQL statements is correct” is option (b). SELECT Username, Password FROM Users. And all the other options are incorrect.

There is 1 question to complete.