2.1 Describe relational concepts
Time limit: 0
Skill Exam Summary
0 of 2 Questions completed
Questions:
Information
You have already completed the skill exam before. Hence you can not start it again.
Skill Exam is loading…
You must sign in or sign up to start the skill exam.
You must first complete the following:
Results
Skill Exam complete. Results are being recorded.
Results
0 of 2 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- 1
- 2
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 2
1. Question
Match the data processing objects on the left to the requirements on the right.
Sort elements
- Store instances of entities as rows.
- Improve processing speed for data searches.
- Display data from predefined queries.
- Create relationships.
-
Tables
-
Indexes
-
Views
-
Keys
CorrectIncorrect -
Question 2 of 2
2. Question
You are creating queries to retrieve data from an Azure SQL database.
Match the SQL clauses or functions on the left to the requirements on the right.
Sort elements
- Combine rows from multiple tables.
- Filter records.
- Calculate the total value of a numeric column.
- Determine the number of rows retrieved.
-
JOIN
-
WHERE
-
SUM
-
COUNT
CorrectIncorrect