KEMBAR78
Internship Test - Endava Datamanagement Discipline | PDF | Microsoft Sql Server | Sql
Scribd
Upload
450 views4 pages

Internship Test - Endava Datamanagement Discipline

The document describes a 10-task SQL test for an internship at Endava Data Management. The test includes tasks like adding/modifying records in tables, writing queries to retrieve and display data from multiple tables based on certain conditions, and creating reports. Test takers are provided credentials to connect to a MS SQL Server database containing sales and customer data. The tasks involve different levels of complexity and test a variety of basic to intermediate SQL skills.

Uploaded by

Ecaterina Ivavova
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
450 views4 pages

Internship Test - Endava Datamanagement Discipline

The document describes a 10-task SQL test for an internship at Endava Data Management. The test includes tasks like adding/modifying records in tables, writing queries to retrieve and display data from multiple tables based on certain conditions, and creating reports. Test takers are provided credentials to connect to a MS SQL Server database containing sales and customer data. The tasks involve different levels of complexity and test a variety of basic to intermediate SQL skills.

Uploaded by

Ecaterina Ivavova
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 4

INTERNSHIP TEST – ENDAVA DATAMANAGEMENT DISCIPLINE

1 DESCRIPTION

About the test:

Applied Level Basic


Number of tasks 10
Domain Standard DB – MS SQL Server
Test type PC
Test duration 2 Days

Evaluation info:

Evaluated person
Evaluator name
Date of evaluation
Evaluation result (passed/failed)

2 TEST TASKS

Precondition: Use the below credentials:

Host: 172.23.176.149
Database/Schema: Master
Authentication: choose “SQL Server Authentication”
Port: 1433
Username: Intern_2020;
Password: Welcome123!

Note: F – First letter of the Person’s First Name ; LastName –Person’s Last Name.

1
1.1
Add a new record in the table Address  with the following information:  

AddressLine1 -> Sfatul Tarii 29 street   


City -> Chisinau   
StateProvince -> Republica Moldova   
Postal Code - > 2007   
Modified Date -> October,08 2012   

Query:

1.2
Modify entered record with below information (2 variants):

AddressLine1 -> Sfatul Tarii 15 street  


City -> Chisinau  
StateProvince -> Republica Moldova  
Postal Code - > 2065  
Modified Date -> the day before actual date

Query:

1.3
 Write a query displaying the Sales order ID, Order date, Total due and City from Address and
Sales.SalesOrderHeader table. Retrieve only those rows where the total due is less than 2000, for
orders that should be delivered to Toronto or Weston. Do not use IN.

Query:

2
1.4
Extract weight value along with Name, Color, UnitPrice for products with the smallest UnitPrice.
Write a query that will display Name, Color, UnitPrice and Weight for products with the smallest
UnitPrice and weight has a value.

Query:

1.5
Write a query to display the total freight per employee along with the EmployeeID, employee First
Name, LastName, Title and HireDate.

Query:

1.6
Write a query which will return all info about the orders where ShippedDate is on Monday.

Query:

1.7
Display customer first and last names that have no middle name and the last name is starting with ‘g’
or ‘h’ or ‘l’

Query:

1.8
 Create a report which will display due date, total due, first name, last name, company name,
address line 1 and address line 2, city, province, country region and postal code which due date is 10
days less than current date and Customer are from Dallas or Toronto.

3
Query:

1.9
Write a query that returns full customer’s name from the DB with a space separator in one string 
and full customer’s address in another string with (,) separator for all customers.
Be advised in manipulation with NULL values.

Query:

1.10
    Create a query to display the shipping country, quantity of orders for each country for orders
placed in winter period, if the quantity of orders is from 1 to 5 display   
 'LOW DEMAND, if the quantity of orders for each country is from 5 to 10 display 'MIDDLE DEMAND,
for all others display 'HIGH DEMAND', make the results to be displayed from lower quantity of orders
to higher.

Query:

You might also like