Sample questions and answers

Try answering the following questions to test your knowledge:

1. Which administrative tool is used in Azure Database for MySQL?
   1. MySQL Workbench
   2. Azure Data Studio
   3. SQL Management Studio
   4. The Azure CLI
2. Which database service is the simplest option for migrating a LAMP application to Azure?
   1. Azure SQL Database
   2. Azure Database for PostgreSQL
   3. Azure Database for MySQL
   4. Azure Cosmos DB
3. You need to modify a view in a relational database by adding a new column. Which statement should you use?
   1. MERGE
   2. ALTER
   3. INSERT
   4. UPDATE
4. Matching the SQL data processing objects to requirements, find the two wrong statements:
   1. Tables store instances of entities as rows
   2. Views create relationships
   3. Indexes improve the processing speed for data searches
   4. Keys display data from predefined queries
5. You need to create a relation between two different tables that have one related column. Which statement should you use?
   1. SELECT AND DROP
   2. SELECT AND JOIN
   3. SELECT AND CASE
   4. CREATE AND RELATION

Answer...