This set of SQL Multiple Choice Questions & Answers (MCQs) focuses on “SQL Hosting”.
1. Which of the following process is used for your web server to have access to a database-system that uses the SQL language?
a) SQL Connectivity
b) SQL Hosting
c) SQL Injection
d) SQL Deployment
View Answer
Explanation: SQL hosting is the process which used for the web server to have access to a database-system that uses the SQL language. This helps our website to store and retrieve data from the database.
2. Which of the following SQL database management system is an open source software?
a) MySQL
b) MS SQL Server
c) Oracle
d) MS Access
View Answer
Explanation: MySQL is a free and open source based database management system. It is a very powerful, robust and full featured SQL database system. It is a free alternative to the MS SQL server and Oracle database systems.
3. Which of the following database management system is inappropriate for high traffic database-driven websites?
a) MySQL
b) MS SQL Server
c) Oracle
d) MS Access
View Answer
Explanation: When websites requires only a simple database then the MS Access can be used. It does not works well with a high traffic database driven websites. It is not as powerful as MySQL, MS SQL Server or Oracle database.
4. The MS SQL Server uses PL/SQL as its language.
a) True
b) False
View Answer
Explanation: The MS SQL Sever uses Transact SQL or T-SQL ass its language. PL/SQL is used by Oracle database as its language.
5. Which of the following database management system can be used only on the Windows operating system?
a) Oracle
b) MongoDB
c) MySQL
d) SQL Server
View Answer
Explanation: The SQL Server database management server is owned by Microsoft and can only run on Windows operating system. Whereas, the database systems like Oracle, MySQL and MongoDB can work on Windows, Mac as well as Linux Operating Systems.
Sanfoundry Global Education & Learning Series – SQL.
To practice all areas of SQL, here is complete set of 1000+ Multiple Choice Questions and Answers.
If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]
