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
Which of the following is not a window function in SQL?
Anonymous Quiz
7%
RANK()
24%
ROW_NUMBER
59%
RANKIFY()
10%
DENSE_RANK()
😁27👍16
Which of the following is a SQL constraint?
Anonymous Quiz
8%
NOTIFY
27%
SELECT
9%
WRONG
57%
NOT NULL
👍17❤4👏3👌1
Which of the following is DML command in SQL?
Anonymous Quiz
66%
INSERT
22%
CREATE
7%
NOTIFY
6%
NULL
👍17🥰2
Which of the following function is used to return length of the string?
Anonymous Quiz
79%
LEN()
3%
LEFT()
1%
RIGHT()
17%
STRINGLENGTH()
👍11👏2😁1