1. What is Density-based Clustering?
Density-Based Clustering is an unsupervised machine learning method that identifies different groups or clusters in the data space. These clustering techniques are based on the concept that a cluster in the data space is a contiguous region of high point density, separated from other such clusters by contiguous regions of low point density.
Partition-based(K-means) and Hierarchical clustering techniques are highly efficient with normal-shaped clusters while density-based techniques are efficient in arbitrary-shaped clusters or detecting outliers.
2. How to create empty tables with the same structure as another table?
To create empty tables:
Using the INTO operator to fetch the records of one table into a new table while setting a WHERE clause to false for all entries, it is possible to create empty tables with the same structure. As a result, SQL creates a new table with a duplicate structure to accept the fetched entries, but nothing is stored into the new table since the WHERE clause is active.
3. What is a Parameter in Tableau? Give an Example.
A parameter is a dynamic value that a customer could select, and you can use it to replace constant values in calculations, filters, and reference lines.
For example, when creating a filter to show the top 10 products based on total profit instead of the fixed value, you can update the filter to show the top 10, 20, or 30 products using a parameter.
4. How will you write the formula for the following in Excel? - Multiply the value in cell A1 by 10, add the result by 5, and divide it by 2.
To write a formula for the above-stated question, we have to follow the PEDMAS Precedence. The correct answer is ((A1*10)+5)/2.
Answers such as =A1*10+5/2 and =(A1*10)+5/2 are not correct. We must put parentheses brackets after a particular operation.
5. How can you remove duplicate values in a range of cells?
1. To delete duplicate values in a column, select the highlighted cells, and press the delete button. After deleting the values, go to the ‘Conditional Formatting’ option present in the Home tab. Choose ‘Clear Rules’ to remove the rules from the sheet. 2. You can also delete duplicate values by selecting the ‘Remove Duplicates’ option under Data Tools present in the Data tab.
Density-Based Clustering is an unsupervised machine learning method that identifies different groups or clusters in the data space. These clustering techniques are based on the concept that a cluster in the data space is a contiguous region of high point density, separated from other such clusters by contiguous regions of low point density.
Partition-based(K-means) and Hierarchical clustering techniques are highly efficient with normal-shaped clusters while density-based techniques are efficient in arbitrary-shaped clusters or detecting outliers.
2. How to create empty tables with the same structure as another table?
To create empty tables:
Using the INTO operator to fetch the records of one table into a new table while setting a WHERE clause to false for all entries, it is possible to create empty tables with the same structure. As a result, SQL creates a new table with a duplicate structure to accept the fetched entries, but nothing is stored into the new table since the WHERE clause is active.
3. What is a Parameter in Tableau? Give an Example.
A parameter is a dynamic value that a customer could select, and you can use it to replace constant values in calculations, filters, and reference lines.
For example, when creating a filter to show the top 10 products based on total profit instead of the fixed value, you can update the filter to show the top 10, 20, or 30 products using a parameter.
4. How will you write the formula for the following in Excel? - Multiply the value in cell A1 by 10, add the result by 5, and divide it by 2.
To write a formula for the above-stated question, we have to follow the PEDMAS Precedence. The correct answer is ((A1*10)+5)/2.
Answers such as =A1*10+5/2 and =(A1*10)+5/2 are not correct. We must put parentheses brackets after a particular operation.
5. How can you remove duplicate values in a range of cells?
1. To delete duplicate values in a column, select the highlighted cells, and press the delete button. After deleting the values, go to the ‘Conditional Formatting’ option present in the Home tab. Choose ‘Clear Rules’ to remove the rules from the sheet. 2. You can also delete duplicate values by selecting the ‘Remove Duplicates’ option under Data Tools present in the Data tab.
❤24👍17👏2🔥1
Which of the following is immutable built-in type in python?
Anonymous Quiz
17%
List
58%
Tuple
12%
Set
12%
Dictionary
👍16😁8🥰5❤2👏2
Which of the following is not a DDL command in SQL?
Anonymous Quiz
20%
CREATE
23%
ALTER
23%
DROP
34%
DELETE
👍25👎6👏6
Which of the following helps us deal with controls, rights, and permission in the database system?
Anonymous Quiz
15%
DDL (Data Definition Language)
67%
DCL (Data Control Language?
18%
DML (Data Manipulation Language)
👍8😁5👏2❤1
Which of the following is a is a DDL command which changes or modifies the existing structure of the database, and it also changes the schema of database objects?
Anonymous Quiz
64%
ALTER
27%
UPDATE
5%
DELETE
4%
SELECT
👍14😁7
Which of the following is a DML command used to update data in an existing database table?
Anonymous Quiz
11%
INSERT
73%
UPDATE
5%
EXISTING
12%
ALTER
👍21👌4❤1👏1
Which of the following is a DCL command used to take back permissions from the user?
Anonymous Quiz
21%
GRANT
70%
REVOKE
5%
RENAME
4%
INSERT
👍15😁3
Which of the following anomaly occur when deleting a record from a database can result in the unintentional loss of data?
Anonymous Quiz
9%
Updation
64%
Deletion
23%
Interuption
4%
Insertion
👍6
Which of the following anomalies occur when modifying data in a database can result in inconsistencies or error?
Anonymous Quiz
11%
Insertion
34%
Update
50%
Modification
5%
Deletion
🔥10😁2❤1👍1🤔1
Which of the following anomaly occurs when there is a new row inserted in the table and it creates the inconsistency in the table?
Anonymous Quiz
59%
Insertion
7%
Deletion
15%
Creation
19%
Update
👍8❤4🔥1
Which of the following is not a window function in sql?
Anonymous Quiz
6%
RANK()
22%
DENSE_RANK
62%
RN()
10%
ROW_NUMBER()
👍6
Which of the following is a virtual table based on the result-set of an SQL statement?
Anonymous Quiz
60%
View
21%
Subset
10%
Set
9%
Dictionary
❤5👍2👏2
Which of the following function converts the value of a field to uppercase in SQL?
Anonymous Quiz
4%
LCASE()
84%
UCASE()
8%
CONVERTS()
3%
VALUE()
👍4❤2
Which of the following is not LOD(Level of detail) expression in tableau?
Anonymous Quiz
26%
FIXED
19%
INCLUDE
16%
EXCLUDE
39%
CONSTANT
👍15😁4❤2🥰2
Which of the following is a python library?
Anonymous Quiz
4%
Javascript
87%
Pandas
3%
C++
6%
Tableau
👍23❤5👏2
Data Analytics
Data Analyst Roadmap 👆👆 More quality content coming soon 😄❤️
What to cover next?
Anonymous Poll
46%
SQL
38%
Python
29%
Statistics
44%
Power BI
25%
Tableau
7%
Qlik
13%
R
17%
ML/AI
30%
Excel
👍89👏10🔥9😢4🥰2❤1👎1😁1
Which of the following SQL statement is used to fetch only those Company and Country columns from Customers table where County is 'USA'?
Anonymous Quiz
21%
SELECT Company FROM Customers WHERE Country = 'USA'
63%
SELECT Company, Country FROM Customers WHERE Country = 'USA'
8%
SELECT Country FROM Customers WHERE Country = 'USA'
8%
FETCH Company, Country FROM Customers WHERE Country = 'USA'
🔥28👍25❤7👏7😁7
Data Analytics
What to cover next?
Nice to see amazing response for SQL, Power BI, Statistics, Python & Excel :)
👍47❤8👏2