Question

Application based questions :

Akash wants to help his father to keep a database of all the toys in his toy shop. He has decided to create a

table with the following fields.

Toy_no, Toy_Name, Toy_type, Price, Colour

Date of Purchase.

(a) Suggest data type for each of the field. (3)

(b) Set a Primary key for the table, Which field would you set or a Primary key and why? ​

Answer 1

Answer:

If there is one language every data science professional should know – it is SQL. SQL stands for Structured Query Language. It is a query language used to access data from relational databases and is widely used in data science.

We conducted a skilltest to test our community on SQL and it gave 2017 a rocking start. A total of 1,666 participants registered for the skilltest.

This test focuses on practical aspects and challenges people encounter while using SQL. In this article, we provide answers to these test questions. If you took the test, check out which areas need improvement. If you did not take the