Relational Databases

Question 1

What type of SQL statements are associated with the DML (Data Manipulation Language) group

Insert, alter, or grant

Answer 1

Insert

Question 2

What SQL statements are associated with the DDL (Data Definition Language) group?

Insert, alter, or grant

Answer 2

Alter

Question 3

Which application is best supported through the use of a relational database?

A. Data gathering for a customer resource management application must support and retain values for entities with different numbers of values

B. An application where users need fast, reliable access to streaming media files that vary in size between 20GB and 5 MB.

C. An order processing engine for an online sales application that needs to perform high-speed OLTP operations

D. An application that must be able to rapidly load values from different IoT sensors that are coded by time into temporary storage with data treated as transparent

Answer 3

C. An order processing engine for an online sales application that needs to perform high-speed OLTP operations

Question 4

The structure used to sort values to help optimize query performance is?

Answer 4

Index

Question 5

A virtual table whose content is defined through a query

Answer 5

View

Question 6

The value used to identify each table entity as unique

Answer 6

Primary Key

Question 7

T/F: Rows in the same table can have different numbers of columns

Answer 7

False

Question 8

T/F: A table can have any number of any rows

Answer 8

True

Question 9

T/F: The primary key is used to enforce uniqueness on rows

Answer 9

True

Question 10

T/F:
Normalization helps to minimize data duplication

Answer 10

True

Question 11

What are two characteristics of database normalization?

A. Less data to store
B. Reduced query complexity
C. Fewer Tables
D. Improved data integrity
E. Fewer foreign keys

Answer 11

A (less data to store)
D (improved data integrity)

Question 12

What DB object should be used to uniquely identify each row in the table?

Answer 12

Primary Key

Question 13

Which Db object should you use to enable easily accessible aggregated results from the table!

Answer 13

View

Question 14

To quickly access rows using specific product tags in the table what Db object should you use?

Answer 14

Index

Question 15

You have an Azure Database that is used to store employee salaries. How would you write the query for the top 10 salaries?

Answer 15

SELECT*
FROM employee.salaries
ORDER BY salary DESC
LIMIT 10;

Question 16

In a relational database, what is the purpose of an index

Answer 16

To improve read performance by searching for specific data in a table

Question 17

What SQL command should you use to remove a database table and it’s content from a database

Answer 17

Drop

Question 18

What type of cloud service is delivered by SQL Server in Azure Virtual Machines (VMs)

Answer 18

Iaas

Question 19

Which type of cloud service is delivered by Azure SQL Managed Instances

Answer 19

PaaS

Question 20

Which type of cloud service is delivered by Azure SQL Database

Answer 20

PaaS

Question 21

Which command is a Data Manipulation Language Command?

DROP
UPDATE
ALTER
CREATE

Answer 21

UPDATE

Question 22

T/F:
Azure SQL Database allows you to choose the SQL Server engine version

Answer 22

False

Question 23

T/F:
Azure SQL Database includes a fully managed backup service

Answer 23

True

Question 24

T/F:
Azure SQL Database automatically applies security patches in the underlying OS

Answer 24

True

Question 25

_______ is a constraint used to enforce data integrity in relational databases by indicating which column (or combination of columns) uniquely identifies each row in a table.

Answer 25

Primary Key

Question 26

A company is moving its on-prem DB to azure. The databases support custom applications. Two applications are stable only when they are used with SQL Server 2016 SP2

What Azure SQL Service should you choose

Answer 26

SQL Server on virtual machine