Font size
WorksheetsSession 7, 8, 9 SQL
Total questions: 30
Worksheet time: 30mins
Which of these are services under Azure SQL ?
Azure SQL Managed Instance
SQL sever on Azure Virtual Machines
Azure SQL Database
All of these
What is Azure SQL Database ?
As a tool for web design
As a tool used to program applications
As a database service management platform
More result
Which of the following allows developers to develop their own set of tags and makes it possible for other programs to understand these tag ?
HTML
XML
DHTML
XQuery
XTML
___ Statement is not supported by Azure SQL. Hence, the user cannot switch between databases in Azure SQL as compared to on-premises SQL Sever
USE
WHERE
FROM
SELECT
For a ___ database, the vCore-based purchase model is ideal as it is flexible and allows you to scale memory and storage based on your requirements
multiple
single
all
Other answer ...
Automatic failover measure are provided in ____
SQL
Azure SQL
Database
DBMS
___ return all rows from two table are combined only if the rows from both the tables are matched based on a common column
Left Outer Join
Self - Join
Right Outer Join
Inner Join
Which of the following statements can be used with subqueries that return one column and many rows
All
In
Any
=
The ___ statement retrieves rows and columns from one or more tables
DISPLAY
SELECT
INSERT
SHOW
Which of the following clause with the SELECT satements is used to specify tables to retrieves records?
FROM
.VALUE
.WRITE
WHERE
___ is used to improve the effciency of queries on XML documents that are stored is an XML column
XML import
XML indexing
XML index
XML export
The ___ operator is used to display only the rows that are common to both the tables
union
except
intersect
union with all
___ is formed when records from two tables are combined only if the rows from both the tables are matched based on a common column
inner join
left outer join
right outer join
self-join
Which one of the following protocols is used by applications retrieves data from SQL Sever ?
DTS
ABS
TDS
WSQL
TDS stand for ___
Tabular Data Stream
Tabular Direct Stream
Tabular Direction Stream
Tabular Data System
How many operators can be used with the WHERE clause ?
6
7
8
9
10
___ is used to return the largest number, lastest date/time, or last occuring string
MAX
MAX function
SUM
ALL
How to count the number of elements in a column?
use COUNT function
COUNT
COUNTED
use COUNTED function
In what year was CTE first introduced?
2003
2004
2005
2009
The ___ operator returns all of the distinct rows from the query given on left of the ___ operator.
EXCEPT
UNION
UNION/EXCEPT
EXCEPT/UNION
How many OPERATORS in session 9 ?
5
4
6
Other answer
An ___ join is formed when records from two tables are combined only if the rows from both the tables are matched based on a common column.
inner
self
right outer
left outer
How many main type JOIN ?
2
1
Other Answer
3
Select all main type-name JOIN
inner join
outer join
left outer join
right outer join
self join
The ___ statement allows you to maintain a target table based on a source table using a single statements. You can now perform the following actions in one ___ statement
OUTER JOIN
MERGE
INNER JOIN
SELF JOIN
A ______ is used to find records in a table that are related to other records in the same table.
self join
inner join
outer join
other answer
___ allows you to generate subtotals for all combinations of grouping columns specified in the ___ clause
EXPECT / EXPECT
GROUP BY / EXPECT
CUBE / GROUP BY
EXPECT / GROUP BY
How to sort elements alphabetically ?
use ASC
use DESC
use ASCS
use DECC
The ___ clause can be used with different clauses, such as WHERE, ORDER BY and HAVING
GROUP BY
CUBE
EXPECT
MERGE
What is Azure SQL
A cloud computing database
A function name
Another coding app
Other answer
