Relational Databases Flashcards
What type of SQL statements are associated with the DML (Data Manipulation Language) group
Insert, alter, or grant
Insert
What SQL statements are associated with the DDL (Data Definition Language) group?
Insert, alter, or grant
Alter
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
C. An order processing engine for an online sales application that needs to perform high-speed OLTP operations
The structure used to sort values to help optimize query performance is?
Index
A virtual table whose content is defined through a query
View
The value used to identify each table entity as unique
Primary Key
T/F: Rows in the same table can have different numbers of columns
False
T/F: A table can have any number of any rows
True
T/F: The primary key is used to enforce uniqueness on rows
True
T/F:
Normalization helps to minimize data duplication
True
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
A (less data to store)
D (improved data integrity)
What DB object should be used to uniquely identify each row in the table?
Primary Key
Which Db object should you use to enable easily accessible aggregated results from the table!
View
To quickly access rows using specific product tags in the table what Db object should you use?
Index
You have an Azure Database that is used to store employee salaries. How would you write the query for the top 10 salaries?
SELECT*
FROM employee.salaries
ORDER BY salary DESC
LIMIT 10;
In a relational database, what is the purpose of an index
To improve read performance by searching for specific data in a table
What SQL command should you use to remove a database table and it’s content from a database
Drop
What type of cloud service is delivered by SQL Server in Azure Virtual Machines (VMs)
Iaas
Which type of cloud service is delivered by Azure SQL Managed Instances
PaaS
Which type of cloud service is delivered by Azure SQL Database
PaaS
Which command is a Data Manipulation Language Command?
DROP
UPDATE
ALTER
CREATE
UPDATE
T/F:
Azure SQL Database allows you to choose the SQL Server engine version
False
T/F:
Azure SQL Database includes a fully managed backup service
True
T/F:
Azure SQL Database automatically applies security patches in the underlying OS
True
_______ 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.
Primary Key
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
SQL Server on virtual machine
