Include answers.
What is an advantage of JSON over XML?
JSON is text-based and structured for humans, whereas XML is a set of rules in machine-readable format.
JSON has a smaller file size than XML.
Q: What kind of database is Mongodb?
A: Document oriented database.
Q. How can you extract month name from a date column like "9/4/2016" using SQL query in Access?
A. In the Select statement, write MONTHNAME(MONTH(date_column)). MONTH(...) is to extract the month in number, and MONTHNAME(...) is to transform the number into month name.
Question: What is a benefit of using a single-page application?
Answer: Because it dynamically alters one web application, there is no need to constantly load between many other pages. This also helps create a fluid and responsive application.
What is 1 advantage and 1 disadvantage of using MariaDB over MySQL?
Advantages:
-Faster/more efficient
-More features
Disadvantages:
-Releases lag behind MySQL
-No 'official' support
How would you close a MySQL connection in PHP? When is this most needed?
$connection->close();
or
msql_close($connection);
It is useful when you have a long script that only requires data at the beginning. After you have all the data you need it is best to close the connection for security and to take a load off the server.
How do you pass a variable into a MySQL query from C#?
MySQL Command parameters add with value ( name, value)
The client wants to display an Access Database column with the header Time. Time is a reserve word. Can Time be used as a column header? If so write a short SQL statement that uses Time as a column header and a sample column that could be displayed.
Answer: Yes
SELECT StartTime AS ‘Time’
FROM TableName;